Tabulky
Exportovat tabulku
Export dat tabulky jako CSV, XLSX, JSON nebo ZIP archiv obrázků.
GET
/
v1
/
tables
/
{table_id}
/
export
// Export as JSON
const data = await client.export.json("tbl_abc123");
console.log(data); // [{ name: "...", price: 29.99 }, ...]
// Export specific columns as CSV
const csv = await client.export.csv("tbl_abc123", {
columns: "name,price,url",
});
// Export as XLSX
const xlsx = await client.export.xlsx("tbl_abc123");
// Export images as ZIP
const images = await client.export.images("tbl_abc123");
# Export as JSON
data = client.export.json("tbl_abc123")
print(data) # [{"name": "...", "price": 29.99}, ...]
# Export specific columns as CSV
csv_data = client.export.csv("tbl_abc123", columns="name,price,url")
# Export as XLSX and save to file
client.export.xlsx("tbl_abc123", path="export.xlsx")
# Export images and save to file
client.export.images("tbl_abc123", path="images.zip")
# Export as JSON
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=json" \
-H "Authorization: Bearer lasso_..."
# Export specific columns as CSV
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=csv&columns=name,price,url" \
-H "Authorization: Bearer lasso_..." \
-o export.csv
Parametry cesty
string
povinné
Jedinečný identifikátor tabulky.
Query parametry
string
povinné
Formát exportu. Jeden z:
csv, xlsx, json, images.string
Čárkou oddělený seznam klíčů sloupců k zahrnutí. Vynechte pro export všech sloupců.
Odpověď
Odpověď závisí na zvoleném formátu:| Formát | Content-Type | Popis |
|---|---|---|
csv | text/csv | CSV soubor oddělený středníkem. |
xlsx | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | Excelový sešit. |
json | application/json | JSON pole objektů řádků. |
images | application/zip | ZIP archiv všech obrázků ze sloupcových obrázků, organizovaný podle řádků. |
// Export as JSON
const data = await client.export.json("tbl_abc123");
console.log(data); // [{ name: "...", price: 29.99 }, ...]
// Export specific columns as CSV
const csv = await client.export.csv("tbl_abc123", {
columns: "name,price,url",
});
// Export as XLSX
const xlsx = await client.export.xlsx("tbl_abc123");
// Export images as ZIP
const images = await client.export.images("tbl_abc123");
# Export as JSON
data = client.export.json("tbl_abc123")
print(data) # [{"name": "...", "price": 29.99}, ...]
# Export specific columns as CSV
csv_data = client.export.csv("tbl_abc123", columns="name,price,url")
# Export as XLSX and save to file
client.export.xlsx("tbl_abc123", path="export.xlsx")
# Export images and save to file
client.export.images("tbl_abc123", path="images.zip")
# Export as JSON
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=json" \
-H "Authorization: Bearer lasso_..."
# Export specific columns as CSV
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=csv&columns=name,price,url" \
-H "Authorization: Bearer lasso_..." \
-o export.csv
⌘I
// Export as JSON
const data = await client.export.json("tbl_abc123");
console.log(data); // [{ name: "...", price: 29.99 }, ...]
// Export specific columns as CSV
const csv = await client.export.csv("tbl_abc123", {
columns: "name,price,url",
});
// Export as XLSX
const xlsx = await client.export.xlsx("tbl_abc123");
// Export images as ZIP
const images = await client.export.images("tbl_abc123");
# Export as JSON
data = client.export.json("tbl_abc123")
print(data) # [{"name": "...", "price": 29.99}, ...]
# Export specific columns as CSV
csv_data = client.export.csv("tbl_abc123", columns="name,price,url")
# Export as XLSX and save to file
client.export.xlsx("tbl_abc123", path="export.xlsx")
# Export images and save to file
client.export.images("tbl_abc123", path="images.zip")
# Export as JSON
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=json" \
-H "Authorization: Bearer lasso_..."
# Export specific columns as CSV
curl -X GET "https://hub.banditshq.com/api/v1/tables/tbl_abc123/export?format=csv&columns=name,price,url" \
-H "Authorization: Bearer lasso_..." \
-o export.csv