Forum Discussion
Value cannot be null power bi query
Hi All, Need help I am running a simple query to extract the data from the rest API based on the date query variable. Below is my query let dtquery=Text.From(#date(2020,7,7)), Source=Json.Docu...
Anonymous's issue must be with:
Web.Contents("https://serviceinstance.xxxx.com/api/now/table/incident?&sysparm_display_value=true&sysparm_exclude_...", [Query=[dt=dtquery]])when it actually runs, it probably gets transformed to:
Web.Contents("https://serviceinstance.xxxx.com/api/now/table/incident?&dt=dtquery")try adding all queries in the [Query=[]] record
Smauro Thanks for the reply.
I have a query parameter in my rest API which filters data based on date which is like "sysparm_query=sys_created_on>%3Djavascript%3Ags.dateGenerate(%272020-07-07%27%2C%2700%3A00%3A00%27)"
as you can see its uses a java script for date format and also formats the operators like greater than or equal to for processing.
how can i pass this value in my web content as parameter?