Forum Discussion
Dynamic REST api query
I am trying to replicate the below method to implementing query folding in using service now rest API in power bi desktop
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
Service now encodes the date parameter like this :-
(dtquery as text)=>
let
Source= Json.Document(Web.Contents("https://servicecentral.xxx.com/api/now/table/prolem",
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate(dtquery)]))
#"Converted to Table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
what is wrong here?
3 Replies
Anonymous - You are missing a comma after your first line (Source)
(dtquery as text)=>
let
Source= Json.Document(Web.Contents("https://servicecentral.xxx.com/api/now/table/prolem",
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate(dtquery)])),#"Converted to Table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"Greg_Deckler thanks for the reply, My query is returning the same error even after putting a comma as you mentioned.
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate('2020-05-01'%2C'00%3A00%3A00')])),
the red'%' value is where its showing as "Token Comma Expected"
Anonymous - Pretty sure your syntax for the Query parameter is way off.
