Enrich with API for only certain rows

Hi all! @Joachim_Brindeau shared this question in another community post thread, and I thought that it deserved a post of its own. Here is the question:

Do you have any idea for a workaround (at least for runs after the first one)?
I’m trying to figure out a way. I was thinking this:

  1. Detect empty cells in columns x,y,z.
  2. If any of those are empty, push these rows (and these rows only) to API enrichment.
  3. Rebuild complete table.

Or simply put: “enrich if column [user input] is empty”


Hi @Joachim_Brindeau,

Happy to help with a workaround here! You can start by inserting an Insert If/ Else Column, and can then create 3 rules (one for each column). We want to mark all columns with a blank value in columns x, y, or z.

Here is a screenshot of those step settings:

Next, we can create a new branch, starting with a Filter Rows step, keeping rows where ‘API Enrichment’ is equal to ‘yes’. You can create another branch keeping rows where ‘API Enrichment’ is blank so that your two branches in total contain all rows of data.

Now that you’ve isolated the rows that you are interested in enriching, you can pass those rows through an Enrich with API step, before using the Stack Tables step to put the 2 (now complete) tables back together.

Hope this helps! Let me know if you have any other questions, and if this works for you.

1 Like

I did not see your answer, thank you very much for the help.
I’ll try it and let you know.
For now, I had removed all API enrichment as it cost me all my google credits. :sweat_smile:
Thanks again

1 Like