Forum Discussion
API calls with Pagination
I almost see the light at the end of the tunnel. I am able to make a connection through an API call to my data source (Okta in this case) and was very excite until I looked at the data and notice...
An easier way to do this might be to include a skip or skiptoken into your url. Please see this post for more details.
You can generate list of skiptoken values separated by the # of records returned (in your case 100), and then use that number column concatenated with your web call to get 100 records on each row, which you can then expand that column to get the combined results. You can also make a call up front to get the number of total records so you know where to stop your list of numbers/skiptokens.
Regards,
Pat