Paginated list

This lesson demonstrates how to access a large table using a paginated list

Code: /lessons/Paginated_list

Steps

1. This lesson uses the Customer table created above.

2. Select Customer table > API tab > /api/v1.1/data/page API.

3. Exercise API with default parameters.

4. See the list of customers in the result section

5. Next steps are using the Trillo Function. Since you will be writing code using Java, you may want to keep the Trillo Workbench Java SDK open.

6. Create a function using IDE or WB UI.

7. Write code using DSApi.getPage api.

• DSApi.getPage takes DataRequest as a parameter.

• Initialize DataRequest. (see appendix for its definition).

• Iterate through pages until all records (or N number of records) are read.

• Add a few log statements to print results. (see appendix for info on logs).

8. Execute function

9. Review response

Similar Concepts

Concept	Description
Several retrieve APIs of DSApi	There are APIs to retrieve a single or collection of records. The collection of records may also have nested related objects making it a tree data structure.