how can I use records from one query results as dynamic inputs for runtime query?

Answered

Lets say I have MySQL query that returns 5 records (i.e. order number), and I want to use each order number as query parameters to an API endpoint to return the order details from each order number. How would I go about it?

1 comment

Official comment

Manny Ezeagwula October 29, 2020 14:50

In this case, what you want to do is use a LOOP JOIN, which iterates through each record from your MySQL query results and uses it as input for the API request.

Example walkthrough here: https://www.loom.com/share/e75285240c5a4d33a0201aa7939e28b2

You can read more on the LOOP JOIN here, https://docs.knowi.com/hc/en-us/articles/115006062748-Multi-Data-Source-Joins

Comment actions Permalink

Please sign in to leave a comment.