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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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
    2 years ago

    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?