Advanced JSON Data Query with Web API (URL parts?)

[SheToastsMe]

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

=HYPERLINK($A$3&"/API/?search"&A7)

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??

 

[ArtPur]

Got the same problem. Need to use the first query info. ie vehicle_id and put that id (cell range.copy) and paste it into part of the API to reference the vehicles details or specifications. Then paste the result into a table in sheet 2. I need to step through 6880 vehicles. Any VBA code will do.