New feature: base requests on a range of cells
By @ana
When running requests, it can be useful to run through a list of cells to hit different endpoints. For example, if you were querying stock quotes, you may have to hit a different endpoint for each request, like this:
/api/quote/AAPL
/api/quote/GOOG
/api/quote/AMZN
Instead of listing them all out in API Connector, you can instead list them in your sheet and enter them like this:
+++Sheet1!A1+++
+++Sheet1!A2+++
+++Sheet1!A3+++
This new feature takes it one step further by adding a convenient shorthand method. Instead of listing out cells one by one, you can now reference an entire range, like this:
+++Sheet1!A1:A3 +++
Documentation: https://mixedanalytics.com/knowledge-base/api-connector-run-multiple-queries-single-request/