Forum Discussion
REST query URL with parameters from initial query, with secure key
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.
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"]]))
1 Reply
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"]]))