All Collections
Connectors FAQ
API Connectors FAQ
Use cell values in API query URL
Use cell values in API query URL

How to dynamically create query URLs by using cell values

Andrei avatar
Written by Andrei
Updated over a week ago

Let's say that you want to use cell values in the Data URL input. For example, we want to query the URL http://api.plos.org/search?q=title:DNA

However, the "q=title:DNA" part of the above URL is dynamic. If we want to use this part from a cell value, we can do so by using the following format: http://api.plos.org/search?q={{Sheet1!A4}}

In the above example, Sheet1 is the sheet where the cell resides and A4 is the cell containing the dynamic URL part.

Did this answer your question?