Trillo Workbench Lessons
  • Introduction
    • Sample Application
  • Introduction to Lessons
    • IDE Lessons
    • Annotated Directory Structure
  • New classes using workbench UI
  • Save many records into tables using the workbench UI
  • New function using Workbench UI
  • Introduction to Code Lessons
    • Anatomy of Trillo Function
  • Begin Code Lessons
    • Paginated list
    • Pagination using SQL Query
    • DataIterator
    • Read file from cloud storage bucket
    • Generating signed URL for a file download
    • Import a CSV file from bucket into BigQuery
    • Query a dataset of BigQuery
    • Using an Document AI Processor
    • Chat using GenAI
    • Function calling another function
    • Accessing Runtime Context
    • Write a workflow (pipeline for data processing)
  • Appendixes
    • ServerlessFunction
    • Map, List and Tree
    • Logs and Audit Logs
    • DataRequest Class
    • DataResponse Class
    • DataIterator Class
    • Result
Powered by GitBook
On this page
  1. Begin Code Lessons

DataIterator

In this example, the function code gets a page at a time. It counts total items and iterates until the last page is fetched.

Code: /lessons/DataIterator

DataIterator lets the function iterate through each record without having to deal with the next page fetch logic.

Steps

  1. Create a new function called DataIteratorLesson.java.

  2. Create a DataIterator instance using the SQL template used in the previous lesson.

  3. It will internally create a DataRequest object.

  4. Set passed parameters into DataRequest of DataIterator.

  5. Initialize the DataIterator.

  6. Iterate through it until there are no more items.

  7. Execute the function and examine the result.

PreviousPagination using SQL QueryNextRead file from cloud storage bucket

Last updated 1 year ago