Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help creating dynamic parameters for power query

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

Need Help

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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]))