Bridge - How to Store All Data From Multiple Child Runs For Comparison

Ryan Sides

Hello Bridge folks!

Scenario: I’m calling an API that paginates its response data by providing a “next_page_token”. I use this in another call to get the second page of the response data.

I’m using a child workflow to run once to get the first page of data, determine if there is a next_page_token, and if there is, call itself again to get the next page of data.

I can pass the first page data to the second run through child entities and append the first set to the second set but I can’t seem to get the full list from the last child run back to the parent workflow since the parent doesn’t know how many times the child will run.

Question: What is the best way to store the full data set (from both pages) so I can process it as a whole? (For example, compare all rows in a sheet to all rows in the full data set returned by the API)

I’d prefer to NOT write both responses to a sheet because I’d need to get those rows later which would add to the processing time of my workflow.

Georgie

Hi @Ryan Sides,

I found a related thread here in the Community which may be of use: How to read and store multiple rows of data using Bridge?.

Have you looked at using the “Store Data”, “Check Data”, and “Retrieve Data” utility functions? I haven’t tested these myself but wonder if these modules might be useful for you.

Perhaps other members will also have some suggestions for you, but I hope this information helps!

Thanks,

Georgie