Has anyone ever worked with sending a JSON payload with date ranges but building a query to automate the values?
For example, the payload has:
{
"id":123456,
"filters": [{
"name":"dateCreated",
"values":["2016-07-01T00:00:00Z","2016-08-01T00:00:00Z"]
}]
}
If I do a monthly range, the data there is larger than the return as it limits it to 10,000 records. I need to chunk up the requests to gather pieces of the data but build the table for the entire range. I need to start with 2016-07-01 and pull up to current date. However, older data won't need to get pulled again on refreshes, only current data that hasn't been pulled anywhere. I've got the query working in advanced editor, it's just now getting this advanced part working. Here's the full query:
let
AuthKey = "XXXXXXXXXXXXXXXXXXXXXXXX",
url="XXXXXXXXXXXXXXXXXXXXXXXXXXXX",
body = "
{
"id":123456,
"filters": [{
"name":"dateCreated",
"values":["2016-07-01T00:00:00Z","2016-08-01T00:00:00Z"]
}]
}",
Source = Json.Document(Web.Contents(url,[
Headers = [#"Authorization"=AuthKey ,
#"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]
)),
in
Source
Any help would be greatly appreciated! Thank you!
