Most API endoints that return a list of data split that data up into 'pages', and return one page at a time, rather than everything at once. This is known as pagination and can be handled within Data Fetcher.
Data Fetcher handles the most common types of pagination:
A page parameter is set to tell the API which page of data you want.
Page 1:http://example.com/?page=1
Page 2:https://www.example.com/?page=2
Offset and limit parameters are set to tell the API which slice of data you want.
Page 1:https://www.example.com/?offset=0&limit=50
Page 2:https://www.example.com/?offset=50&limit=100
After the first request, an entity id from the previous response is included to tell the API where to start.
Page 1:http://www.example.com
Page 2:https://www.example.com/?starting_after=cus_IOCwDqeBZGGsrF
After the first request, the API returns a field which contains the entire URL for the next page of data. This URL is used to make the next request, and so on.
Click to open the advanced options.
Under Pagination, select the pagination type you want from the dropdown. You can also set it to 'None' to turn off pagination.
After selecting a pagination type, these options will become visible:​
Turn on and the app will make requests for each page until no data is returned. This can sometimes cause infinite requests to be made if the API response always returns some data.
Alternatively, you can enter the number of pages you want to fetch:.
​Set the pagination type to 'Page'.
Enter the name of the page parameter. This is nearly always called 'page' but some endpoints may use a different name:
​
​Set the pagination type to 'Offset'.
Enter the name of the offset parameter. This is often called 'offset' but some endpoints may use a different name:
​
Enter the name of the limit parameter. This is often called 'limit' but some endpoints may use a different name:
​
Enter the numerical limit value. This is the number of entities that are fetched in each request. The offset value will start at 0 then be increased by this amount for each request.
​
You will need to have run the request at least once to have created the fields in the output table.
​Set the pagination type to 'Cursor'.
Enter the name of the cursor parameter:
​
Select the cursor field from the output table fields in the dropdown:
You will need to have run the request at least once to have created the fields in the output table.
​Set the pagination type to 'Next URL'.
Select the next URL field from the output table fields in the dropdown: