Passing sys_created_on date parameter in REST api

[Raks]

Hi All,

Need help. I am trying to build a dynamic query where sys_created_on is passed to the table using the sysparam=sys_created_on attribute. Now my question here is how to build this query.

Source= Json.Document(Web.Contents("https://servicecentral.capgemini.com/api/now/table/prolem",
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate(dtquery)]))

where dtquery is the date variable holding the date value.

Just to add I am using this query to get data into power bi using power query.

Please guide

[Ankur Bawiskar · Accepted solution]

@Raks 

you should send it like this

Send the date as dynamic value which is highlighted in bold

sysparm_query=sys_created_onON2020-07-17@javascript:gs.dateGenerate('2020-07-17','start')@javascript:gs.dateGenerate('2020-07-17','end')

Regards
Ankur

[phanendra varma]

Hi Ankur

Can we pass any variables date in place of those bold dates? 

[Nolan4]

Hi Ankur,

How can we pass sysparm_query greater than some date ?

[Ankur Bawiskar]

you can manipulate the date