Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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 below

     startedAt = "%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



    • Anonymous's avatar
      Anonymous
      Not 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?