Help creating dynamic parameters for power query

[Anonymous]

Hi all, 

Need help in creating a dynamic parameter to my query in power bi query as below:

(dtquery as text) =>
let
url="https://<instance>.xxx.com/api/now/table/incident?sysparm_display_value=true&sysparm_exclude_reference_link=true&sysparm_limit=1&sysparm_query=sys_created_onSTARTSWITH2020-07-08",
Source = Json.Document(Web.Contents(url,[Query=sysparm_query&"="&sys_created_on&STARTSWITH&dtquery]))

But I am getting this error :

An error occurred in the ‘’ query. Expression.Error: The name 'sysparm_query' wasn't recognized. Make sure it's spelled correctly.

Not sure what am I doing wrong here

[Mariusz]

Hi @Anonymous 

So there is a clear indication that the below part is wrong.

[Query=sysparm_query&"="&sys_created_on&STARTSWITH&dtquery]
most probably you have not defined sysparm_query anywrer in power query.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

@Mariusz Thanks for your reply, But if you see my URL I am actually using the parameter in the query:

(dtquery as text) =>
let
url="https://<instance>.xxx.com/api/now/table/incident?sysparm_display_value=true&sysparm_exclude_reference_link=true&sysparm_limit=1&sysparm_query=sys_created_onSTARTSWITH2020-07-08",
Source = Json.Document(Web.Contents(url,[Query=sysparm_query&"="&sys_created_on&STARTSWITH&dtquery]))