Run Multiple Queries in a Single Request

Run Multiple Queries in a Single Request

Last Updated On July 19, 2019
You are here:
< Back

This advanced feature of the API Connector add-on for Google Sheets allows you to stack multiple requests together and run them all at once. This enables great efficiency when you need to query the same API endpoint multiple times, e.g. for different user IDs or different time periods. This also allows you to retrieve multiple API responses to a single sheet, since each subsequent request will be appended to the first empty row of the selected sheet.

This is a paid feature, please upgrade to access.

There are a few methods for accessing this feature:

Note: when running multiple queries, a 1.1 second delay is automatically inserted between requests to help avoid rate limits.

Method 1: List URLs in the URL input box

To run multiple requests, list your URLs on separate lines. When you Run the request, each subsequent response will be appended to the first empty row.

api-connector-multiple-queries-img1

Method 2: List URLs in a cell

As an alternative to the above, you can list your URLs in a single cell. Just make sure they are on separate lines, like this:
api-connector-multiple-queries-img2

Now you can reference the cell (info) like this, with the same results as above:
api-connector-multiple-queries-img3

Method 3: Combination

You can also combine the two methods if you like, for example by listing out references to cells in the input box. Again, make sure each separate request is on a new line, to ensure API Connector recognizes it as a new request:

api-connector-multiple-queries-img4

Comments:0

Leave a Reply

Your email address will not be published.