URL Query Help

[Anonymous]

Hello all, I am new to the forum and new to Power Bi in general, so please bare with me and my understanding.

I have the below part of a query written:

startUrl = Json.Document(Web.Contents("https://WEBSITE.COM?page[first]=50")),

 Blanking out the website for obvious personal reasons. It has a query at the end of the url, calling the first 50 results that this specific API gets. While this code works perfectly the way it is, I am wanting to convert this for use in Bi Service.

I have tried using some thing like:

startUrl = Json.Document(Web.Contents("https://WEBSITE.COM",[Query=[page[first]=50]]))

But it gives an error that "page" is an Invalid identifier. I am able to use query with other url queries fine, but I believe it does not like the brackets.

Any help with this issue would be grateful, and please pardon my lack of knowledge with Bi.

[ams1]

Hi,

Try:

...
[Query=[#"page[first]"="50"]]
...

Please mark this reply as answer if it helped.