Web.Contents moving '?' clause to the end of the string

[prill2ta]

Hello, Can anyone help me figure out why Power Query is moving the clause of my api string to the end?  

Example: 

I type:  Web.Contents("https://api-domain.com/v1/active?licenseNumber=123",[RelativePath="&ID="&[Id]])

It returns and Error Data Path that is: Data Path = https://api-domain.com/v1/active&ID=abc?licenseNumber=123

[Icey]

Hi @prill2ta ,

Please try the method @mahoneypat provided.

In addition, some documents for reference:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...;

Chris Webb's BI Blog: Web.Contents(), M Functions And Dataset Refresh Errors In Power BI Chris Webb'...;

Power BI Relative Path Fix for Web Contents Dataset Refresh Errors In Power BI Service - YouTube.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[mahoneypat · Accepted solution]

Please try using the Query term of Web.Contents instead as follows

Web.Contents("https://api-domain.com/v1/active",[RelativePath="&ID="&[Id], Query = [licenseNumber="123"]])

Pat