Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 usin...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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
  json

    In 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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

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
  json

In 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.