Share via

Incremental Refresh Using M Query and paginated API

Jon Maloney 1 Reputation point
2022-05-19T10:14:55.087+00:00

I'm trying to use an M Query to pull data from a paginated API. Currently the M Query works to pull all the paginated API data using
Json.Document(Web.Contents(Url))
The above line is run through a loop until there are no results returned.

When I try and use Incremental Refresh the service fails to refresh the data source. Is there a way to use Incremental Refresh to obtain Paginated API data via an M Query?

Community Center | Not monitored
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.