powerquery – How do I use Excel Power Query with AutoDesk Takeoff?

I am new to using both AutoDesk Construction Cloud API and Excel Power Query.

I have a sample curl request from the documentation:

curl -X GET -H "Authorization: Bearer nFRJxzCD8OOUr7hzBwbr06D76zAT" "https://developer.api.autodesk.com/project/v1/hubs/b.d6cf8c84-c25e-4534-ae5c-62e08480e751/projects"

I know both my bearer token and the hub id which is after the ‘hubs’ portion in the url. The ones I list here are from the documentation sample, taken from here: aps.autodesk.com/en/docs/acc/v1/tutorials/getting-started/retrieve-account-and-project-id/

I don’t understand where I would input these credentials in Power Query to get a response from this request.
I’m seeing an option for using an API key, but I don’t think I am given one.

I have Excel installed locally but I have Office 365.

Read more here: Source link