Forum Discussion
PowerQuery Post API call to return complete data from all pages.
i could see Authorization: Bearer , kvAccessToken is same for all the pages.
when i click on the next page --
{"query":"((end_time ge '2023-01-18T05:28:31Z' and start_time le '2023-02-17T05:28:31Z') and (file_type_name eq 'datalog'))","fields":[],"count":true,"start":100,"limit":100,"sort":{"fieldname":"end_time","order":"desc"}}
Next page ----
{"query":"((end_time ge '2023-01-18T05:30:02Z' and start_time le '2023-02-17T05:30:02Z') and (file_type_name eq 'datalog'))","fields":[],"count":true,"start":200,"limit":100,"sort":{"fieldname":"end_time","order":"desc"}}
seems "start" is the changed every time, then "limit":100 every time.
these days are same for all page, because i choose last 30 days in application...
end_time ge '2023-01-18T05:28:31Z' and start_time le '2023-02-17T05:28:31Z'
Your help in sharing the code structure would be greatly appreciated.