Analytics - Paginating Results with Direct Query Links
Since version 0.5.0
Direct Query Link Pagination
Direct query links created with SuperSync analytics can be filtered for ranges using several different styles of pagination. These methods are laid out below. In each case, filters are specified by adding additional URL parameters.
Limit / Offset Pagination
This method of paginating results uses a limit parameter to specify how many results should be returned per page and an offset parameter to tell the system how many results to skip over.
Note that the offset parameter represents a number of records and that the count starts at "0" and not "1" as it is a number of records "skipped" before returning results.
This method works for both queries and saved search data source types.
Example 1:
https://12345678.ssal.supersync.cloud?data=example-search&limit=5
https://12345678.ssal.supersync.cloud?data=example-search&limit=5&offset=0
Both of these searches would return the results indicated:
Example 2:
https://12345678.ssal.supersync.cloud?data=example-search&limit=5&offset=10
When the offset is set to the value of 10, the first 10 records are skipped and the next set of 5 is returned.
Limit / Page Pagination
This method of paginating results uses a limit parameter to specify how many results should be returned per page and an page parameter to tell the system which page of results to return.
This method works for both queries and saved search data source types.
When using this method with saved searches the limit or page size will be rounded down to the nearest thousand if it is greater than 1000. This is because search results are returned from NetSuite in chunks of up to 1000 records at a time so it is most efficient to break up page sizes by thousands. Page sizes specified under 1000 will return that exact number of records.
Example 1:
https://12345678.ssal.supersync.cloud?data=example-search&limit=10&page=1
This returns the first page of 10 results:
Example 2:
https://12345678.ssal.supersync.cloud?data=example-search&limit=10&page=2
This returns the 2nd page of 10 results:
