Forum Discussion
HOW TO FIX ERROR IN INCREMENTAL UPDATE - API
Hi,
I need to filter my API for recently Dates, but when i try to put like the documentation says just display a error.
Under, the function that i use. The function works without the dates, but i need with this range of dates.
The dates need to stay in ISO 8601 like the documentation says.
(plimit as number, ppage as number ) =>
let
urlBase = "URL",
endPoint = "v1/evaluations?",
cabecalho =
[
Authorization = "Bearer "
],
parametros =
[
limit = Text.From(plimit),
page = Text.From(ppage),
status = "6",
startedAt = "[gte]=2021-01-01T00:00:00+00:00",
concludedAt = "[eq]=2022-01-09T00:00:00+00:00"
],
Fonte =
Web.Contents(
urlBase,
[
RelativePath = endPoint,
Headers = cabecalho,
Query = parametros
]
),
abrirJson = Json.Document(Fonte)[data]
in
abrirJson
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
According to your description and the code provided, The startedAt and concludedAt parameters are used to filter the data based on a range of dates. but it seems that these two parameters are not working, according to the related question I queried, the date parameters in the URL should be URL encoded. You can try to change the format after the startedAt and concludedAt parameters as belowstartedAt = "%5Bgte%5D=2021-01-01T00:00:00%2B00:00", concludedAt = "%5Beq%5D=2022-01-09T00:00:00%2B00:00"Best Regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- AnonymousNot applicable
Doesn't work.
Actually my problem is with the incremental update.As you see, is not valuable to click in the "View Native Query".
I saw here (Configuring Incremental Refresh in Power BI (youtube.com)) that this is import for my incremental update works in my workspace, but i dont know how to fix this.
can anyone help me with this?