Forum Discussion
Best way to acquire data from an API using token and parameters
I want to acquire data from an API connection using a Token authentication and parameters.
Basically I want to do this:
curl -X GET \ -H "Content-Type: application/json" \ -H "Shortcut-Token: $SHORTCUT_API_TOKEN" \ -d '{ "page_size": 123, "query": "type:feature" }' \ -L "https://api.app.shortcut.com/api/v3/search"
I have the URL "https://api.app.shortcut.com/api/v3/" and the Token as parameters in Power Query.
How can I do that ?
Hi cccarv82
The following links should be helpful.
Getting Started with API's in Power Query • My Online Training Hub
Web.Contents - PowerQuery M | Microsoft Docs
Your token is used in the headers, so put it in the Headers property. You can create a query parameter to store the token and use its name in the code. Parameters - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
1 Reply
Hi cccarv82
The following links should be helpful.
Getting Started with API's in Power Query • My Online Training Hub
Web.Contents - PowerQuery M | Microsoft Docs
Your token is used in the headers, so put it in the Headers property. You can create a query parameter to store the token and use its name in the code. Parameters - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.