how do i use a lookup in flow but but have it run serially for each record passed into the flow?Answered
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
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
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.