Načtení stránkovaného seznamu řádků z tabulky.
const result = await client.tables.rows("tbl_abc123", {
page: 1,
limit: 50,
sort_by: "name",
});
for (const row of result.data) {
console.log(row.data.name, row.data.price);
}
{
"data": [
{
"id": "row_abc123",
"row_index": 0,
"data": {
"product_name": "iPhone 15 Pro",
"price": 999,
"description": "Latest Apple smartphone"
},
"validation_status": null,
"validation_errors": null,
"enhancement_status": null,
"is_edited": false,
"created_at": "2025-03-10T14:30:00.000Z"
}
],
"pagination": {
"page": 1,
"limit": 50,
"total": 42
}
}
extracted_data pro daný sloupec.asc nebo desc.Zobrazit Objekt řádku
const result = await client.tables.rows("tbl_abc123", {
page: 1,
limit: 50,
sort_by: "name",
});
for (const row of result.data) {
console.log(row.data.name, row.data.price);
}
results_as_dataframe, který načte všechny řádky a vrátí pandas DataFrame:df = client.tables.results_as_dataframe("tbl_abc123")
print(df.head())
{
"data": [
{
"id": "row_abc123",
"row_index": 0,
"data": {
"product_name": "iPhone 15 Pro",
"price": 999,
"description": "Latest Apple smartphone"
},
"validation_status": null,
"validation_errors": null,
"enhancement_status": null,
"is_edited": false,
"created_at": "2025-03-10T14:30:00.000Z"
}
],
"pagination": {
"page": 1,
"limit": 50,
"total": 42
}
}
const result = await client.tables.rows("tbl_abc123", {
page: 1,
limit: 50,
sort_by: "name",
});
for (const row of result.data) {
console.log(row.data.name, row.data.price);
}
{
"data": [
{
"id": "row_abc123",
"row_index": 0,
"data": {
"product_name": "iPhone 15 Pro",
"price": 999,
"description": "Latest Apple smartphone"
},
"validation_status": null,
"validation_errors": null,
"enhancement_status": null,
"is_edited": false,
"created_at": "2025-03-10T14:30:00.000Z"
}
],
"pagination": {
"page": 1,
"limit": 50,
"total": 42
}
}