Sql variable inside retool variable

Cool! Would something like this work? :slight_smile:

http://community.retool.com/t/how-to-run-a-rest-api-query-for-each-item-in-an-array-and-return-all-results-together/2352

It basically uses the Retool query property “additionalScope” to call the target query as many times as you need and dynamically pass in each value.

Here’s a more in depth read on additionalScope!

http://community.retool.com/t/how-to-use-additionalscope-in-your-queries/13343