SmartRowArray

SmartRowArray is a specialized array of SmartRow objects returned by methods like findRows() and table.filter().

It extends the native Array, so you can use all standard array methods (map, filter, forEach, etc.), but adds a convenient toJSON() method to resolve data from all rows at once.

Methods

toJSON()

Resolves all rows in the array to a JSON representation. This is an async operation that calls toJSON() on each individual SmartRow.

toJSON(options?: { columns?: string[] }): Promise<Record<string, any>[]>

Parameters

• options - (Optional) Configuration options
  • columns - specific columns to include in the output

Returns

Promise<Record<string, any>[]> - A promise that resolves to an array of objects representing the row data.

Example

const rows = await table.findRows({ Role: 'Admin' });

// Get all data
const allData = await rows.toJSON();
console.log(allData);
// [
//   { Name: 'John', Role: 'Admin' },
//   { Name: 'Jane', Role: 'User' }
// ]

// Get specific columns
const partialData = await rows.toJSON({ columns: ['Name'] });
console.log(partialData);
// [ { Name: 'John' }, { Name: 'Jane' } ]

Usage with Array Methods

Since SmartRowArray extends Array, you can chain standard methods with toJSON().

const rows = await table.findRows({});

// Filter rows locally (note: this filters SmartRow objects, but it's usually better to use table.filter())
const adminRows = await Promise.all(
  rows.filter(async row => await row.getCell('Role').innerText() === 'Admin')
);

// Map to specific promises (or use table.map())
const names = await Promise.all(
  rows.map(row => row.getCell('Name').innerText())
);