Use cell values in API query URL

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.