REST query URL with parameters from initial query, with secure key

[ellisx]

How can I retrieve data from a REST API which requires key headers that depends on an initial query to first get the parameters.

e.g. my first query gets a list of building IDs, I then need to loop through each building to retrieve the data about them with a URL like: https://api.buildings.com/api/occupancy?buildingID=1

I can add the secret key into the first query, but I don't know how to tell it to loop through the queries and second level queries and include headers, and I can't find any tutorials or information on how to do it.

[ellisx · Accepted solution]

answered my own question, for anyone else struggling, edit the query and add the headers in, you can view the way to do this by clicking on advanced editor on a query that has the key in, it will look like this:

Source = Json.Document(Web.Contents("https://api.buildings.co.uk/api/homes", [Headers=[key="9fw8hdfdhs9fhsd8fhusdh"]]))