Please Help with Relative Path for API Web Link (Json) with a Token

[DMB90]

I have the following weblink:

Web Link:

https://mycompany.app.com/api/v1/reports/7/json?token=89350b503e305392c0b9256

I would like to put it into a RelativePath format for Json document.

This is what it currently shows:

let

Source = Json.Document(Web.Contents("https://mycompany.app.com/api/v1/reports/7/json?token=89350b503e305392c0b9256")),

#"Converted to Table" = Table.FromList

I want it to read similar to this as I'm having issues getting the web link for this API to integrate with Power BI Desktop with the format above. I'm not sure sure if this is the correct way to slice and dice the url though as shown below but I've seen something like this may help resolve the issue.

Source = Json.Document(Web.Contents("https://mycompany.app.com/api",

   [

   RelativePath="/v1/reports/7/json?token=89350b503e305392c0b9256",

   Query

[v-menakakota]

Hi @DMB90 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @DMB90 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[lbendlin · Accepted solution]

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1