Hello,
I'm using a Web API to retrieve tables of JSON data successfully into my spreadsheet.

In the Query Editor window, there's an "applied steps" sequential list, featuring the first step, "source". Source is the actual web URL of the API itself.

The dialog box for source allows entry of the URL in Basic and Advanced modes. In Basic, I put the entire URL string; in Advanced, I can add fields that will concatenate the URL string in parts. In fact, the box calls this field "URL Parts"

Well, I'd like to fill in fields based on data found in the sheet itself. In otherwords, I want to use data in my sheet to build the URL for the Web Query-- much in the way you can make a hyperlink in a cell by using text operations 

Please Login or Register  to view this content.

So restated; how can I use an in-sheet formula to assemble a text string to feed the Source of a Web Query?

Should be easy, right??