Web.Contents - dynamic url

[mclaasen]

Hi,

I want to use a dynamic URL for my report. I created a URL parameter.

the hardcoded version works fine and looks like this:

=Json.Document(Web.Contents("https://<organization name>.crm4.dynamics.com/api/data/v9.1/opportunities?$select=name"))

I changed it to this:

= Json.Document(
Web.Contents(strURL,
[RelativePath = "opportunities",
Query=
[$select="name"]
]
)
)

Issue is that the syntax does not allow $ in the query parameters but is required to use in the web api for D365 CE.

Without the $ sign the syntax is ok, but then the API is not working properly (see error below)

Any suggestions are welcome

[artemus · Accepted solution]

Change:

[$select="name"]

to

[#"$select"="name"]

[mclaasen]

Thanks Artemus !

it works