Search API Connector Documentation
Print Request URL
The API Connector add-on for Google Sheets provides an option to include your request URL in your sheet each time your data refreshes. To access, click on the Output options button and check the Add request URL box.
Contents
Before You Begin
If you haven’t already, click here to install the API Connector add-on from the Google Marketplace.
Why Add Request URLs?
This feature lets you print your request URL into your response sheet. This is useful in a few cases:
Get metadata
For example, imagine you're fetching YouTube data for various search terms. YouTube's API sends back a list of statistics, but doesn't include the search term in their response. If you are searching for data on multiple search terms, adding in the request URL tells you which statistics correspond to which term.
Convert a preset request into a custom request
API Connector's preset API integrations are a convenient way to quickly pull data from many different APIs. However, for more advanced or custom requests you may prefer to start with the raw API URL instead of using the preset integration.
To view the underlying API URL, tick the Add request URL box before running your request. This will print out the request URL, which can then be copied and pasted into a custom request.
Each Row Option
By default, the request URL will be printed on the first line of the data set (in either the first or second column, depending on whether or not you have enabled timestamps).
If you prefer to see the request URL printed on every line, click the "Each row?" option to enable it.