Forum Discussion
WEB Source GET Request - Adding query after header
So I have this successful GET request built in a Power Automate Flow (see screenshot below)
I want to create this exact same GET request in Power BI which I have partially succeeded in using the WEB source:
What I am missing however is the "Offset" & "limit" queries which I need, as otherwise I only get shown 50 results from over 150.
How can I achieve this?
(Please note, I do not have a lot of experience with Curl commands or the like, so a easy to understand explanation would be amazing)
Hi Anonymous ,
Please try to use query parameters in Power Query (M language). Here is an example, assuming the output is JSON, you would do it like this(you do it in the advanced editor):
let src=Web.Contents(baseUrl, [RelativePath = urlPath, Query=[#"api_token" = apiKey, limit=Text.From(limit), start=Text.From(offset)]]) json = Json.Document(src) in jsonIn the above examples, parameters are:
- baseUrl for root API path
- urlPath for API endpoint
- apiKey for API authorization token
- limi and offset for getting a subset of data
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
Please try to use query parameters in Power Query (M language). Here is an example, assuming the output is JSON, you would do it like this(you do it in the advanced editor):
let src=Web.Contents(baseUrl, [RelativePath = urlPath, Query=[#"api_token" = apiKey, limit=Text.From(limit), start=Text.From(offset)]]) json = Json.Document(src) in jsonIn the above examples, parameters are:
- baseUrl for root API path
- urlPath for API endpoint
- apiKey for API authorization token
- limi and offset for getting a subset of data
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.