how do i use a lookup in flow but but have it run serially for each record passed into the flow?

Answered

Anthony Rosenkrantz

• March 02, 2020 17:43

current flow e.g.

step 1: extract 100 records

step 2: lookup skubana purchase order item status  (celigo does 100 lookups)

step 3: receive item  ...... then processes the receipts

 

I need:

step 1: extract 100 records   (postgres extract)

step 2: lookup individual record /  po item status  (skubana lookup)

step 3: process receipt (add skubanana receipt)

step 4 : loop and goto step 2 or  one if needed

 

0

• Official comment

  

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • March 09, 2020 20:28
  • Edited

  

  

  

  Hi Anthony Rosenkrantz , 

  You can set your Concurrency level for that app connector's connection to 1 to process records sequentially. We don't have a connection article for Skubana, but you can see the field descriptions here: https://celigosuccess.zendesk.com/hc/en-us/articles/360039181552-Set-up-a-connection-to-3dCart

  Is that the root problem, though? Why do you need the lookups to run in serial order? This will slow down your flows considerably. Are you running into API governance errors?
  
  If you do not set Concurrency level, then the default behavior for integrator.io is to send API requests as quickly as possible, so a good compromise would be to set Concurrency level to something like 5, which most APIs can handle.
  
  Please let us know more information so that we can provide further assistance if needed.

   

Please sign in to leave a comment.