Records: Pagination

This script demonstrates how to load and display records from a selected table in NocoDB, with pagination support for large datasets.

// Ask user to select a table
const table = await input.tableAsync('Select a table to load records from');

// Initial query with small page size
const result = await table.selectRecordsAsync({ pageSize: 50 });

// Initial log
output.text(`Loading records from "${table.name}"...`);

// Track total loaded so far
let previouslyLoaded = result.records.length;
output.text(`Loaded ${previouslyLoaded} records so far...`);

// Load all records using pagination, with progress updates
while (result.hasMoreRecords) {
  await result.loadMoreRecords();
  const newlyLoaded = result.records.length;
  const batchSize = newlyLoaded - previouslyLoaded;
  previouslyLoaded = newlyLoaded;
  output.text(`→ Loaded ${batchSize} more. Total so far: ${newlyLoaded}`);
}

// Final count
output.text(`✅ Done. Total records loaded from "${table.name}": ${result.records.length}`);

Related pages

• Table Operations : Demonstrates how to check for table existence, create a table, and list all tables in the base.
• Fields: Text-Based : Learn how to create and manage text-based fields in NocoDB.
• Fields: Numerical : Learn how to create numerical fields for storing quantities, percentages, currency, and more.
• Fields: Date & Time : Create fields to capture dates, times, and durations.
• Fields: Select : Create single select and multi select fields for categorizing data.
• Fields: System : Capture automatic audit information with system fields in NocoDB.
• Fields: User & Collaborator : Assign or reference users directly within records.
• Fields: Virtual & Formula : Add calculated or derivative data with virtual fields in NocoDB.