Forum Discussion
Solved
REST API Pagination - converting records to text?
I'm writing a report to pull ticket metrics from the Zendesk API. The API is paginated, with 100 records per page, so I need to iterate through all pages to return the metrics I need. The block of M ...
pdbenbow
Thanks for posting the final code. It is really helpful to see the final solution.
I was wondering whether Url could be combined with BaseUrl?
Also, are the Urls and Pages combined to create the Source in the TablesfromList?
Glembi
Thanks for posting the final code. It is really helpful to see the final solution.
I was wondering whether Url could be combined with BaseUrl?
Also, are the Urls and Pages combined to create the Source in the TablesfromList?
Glembi
Glembi,
Url and BaseUrl can be consolidated, yes. That's just some redundancy in my code.
And yes, my interpretation of how the M is operating is like you said: it's iterating through the page index, building each URL to retrieve each page, and then unioning all the pages together. The final step just takes the preceding operations (Source) and splits them.
Pete