Dynamic REST api query

[Anonymous]

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 :-

sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate('2020-05-01'%2C'00%3A00%3A00')

now I am getting the "Token Comma Expected" error just after sys_created_on in the query below

(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?

[Greg_Deckler]

@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"

[Anonymous]

@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"

[Greg_Deckler]

@Anonymous - Pretty sure your syntax for the Query parameter is way off. 

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/