currently, API Bridget supports two ways of handling pages
1. Page Parameter
Page parameter pagination is the simplest one. You just have to specify the page parameter, starting and ending page. And the request will run through those pages and return all the results in the Looker Studio Report.
Note that the page parameter may differ for other APIs like page, count, etc,. so check the parameter used in your API and specify the same in the Page Parameter field.
2. Offset-Limit
The offset and limit pagination requires offset and a limit per request.
- Offset – It is simply the number of records you want to skip before selecting records.
- Limit – It the number of records to be fetched in each request.
For offset-limit pagination, you need to specify the offset parameter, offset value, limit parameter, limit value and the number of records you want to fetch.