cURL
curl --request PUT \
--url https://api.glideapps.com/tables/{tableID} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"rows": [
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"totalAmount": 34.5,
"amountPaid": 0
},
{
"fullName": "Alicia Hines",
"invoiceDate": "2023-06-15T10:30:00.000Z",
"totalAmount": 50.75,
"amountPaid": 20
}
],
"schema": {
"columns": [
{
"id": "fullName",
"displayName": "Full Name",
"type": "string"
},
{
"id": "invoiceDate",
"displayName": "Invoice Date",
"type": "dateTime"
},
{
"id": "totalAmount",
"displayName": "Total",
"type": "number"
},
{
"id": "amountPaid",
"displayName": "Paid",
"type": "number"
}
]
}
}
'import requests
url = "https://api.glideapps.com/tables/{tableID}"
payload = {
"rows": [
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"totalAmount": 34.5,
"amountPaid": 0
},
{
"fullName": "Alicia Hines",
"invoiceDate": "2023-06-15T10:30:00.000Z",
"totalAmount": 50.75,
"amountPaid": 20
}
],
"schema": { "columns": [
{
"id": "fullName",
"displayName": "Full Name",
"type": "string"
},
{
"id": "invoiceDate",
"displayName": "Invoice Date",
"type": "dateTime"
},
{
"id": "totalAmount",
"displayName": "Total",
"type": "number"
},
{
"id": "amountPaid",
"displayName": "Paid",
"type": "number"
}
] }
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PUT',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
rows: [
{
fullName: 'Alex Bard',
invoiceDate: '2024-07-29T14:04:15.561Z',
totalAmount: 34.5,
amountPaid: 0
},
{
fullName: 'Alicia Hines',
invoiceDate: '2023-06-15T10:30:00.000Z',
totalAmount: 50.75,
amountPaid: 20
}
],
schema: {
columns: [
{id: 'fullName', displayName: 'Full Name', type: 'string'},
{id: 'invoiceDate', displayName: 'Invoice Date', type: 'dateTime'},
{id: 'totalAmount', displayName: 'Total', type: 'number'},
{id: 'amountPaid', displayName: 'Paid', type: 'number'}
]
}
})
};
fetch('https://api.glideapps.com/tables/{tableID}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.glideapps.com/tables/{tableID}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_POSTFIELDS => json_encode([
'rows' => [
[
'fullName' => 'Alex Bard',
'invoiceDate' => '2024-07-29T14:04:15.561Z',
'totalAmount' => 34.5,
'amountPaid' => 0
],
[
'fullName' => 'Alicia Hines',
'invoiceDate' => '2023-06-15T10:30:00.000Z',
'totalAmount' => 50.75,
'amountPaid' => 20
]
],
'schema' => [
'columns' => [
[
'id' => 'fullName',
'displayName' => 'Full Name',
'type' => 'string'
],
[
'id' => 'invoiceDate',
'displayName' => 'Invoice Date',
'type' => 'dateTime'
],
[
'id' => 'totalAmount',
'displayName' => 'Total',
'type' => 'number'
],
[
'id' => 'amountPaid',
'displayName' => 'Paid',
'type' => 'number'
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.glideapps.com/tables/{tableID}"
payload := strings.NewReader("{\n \"rows\": [\n {\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5,\n \"amountPaid\": 0\n },\n {\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75,\n \"amountPaid\": 20\n }\n ],\n \"schema\": {\n \"columns\": [\n {\n \"id\": \"fullName\",\n \"displayName\": \"Full Name\",\n \"type\": \"string\"\n },\n {\n \"id\": \"invoiceDate\",\n \"displayName\": \"Invoice Date\",\n \"type\": \"dateTime\"\n },\n {\n \"id\": \"totalAmount\",\n \"displayName\": \"Total\",\n \"type\": \"number\"\n },\n {\n \"id\": \"amountPaid\",\n \"displayName\": \"Paid\",\n \"type\": \"number\"\n }\n ]\n }\n}")
req, _ := http.NewRequest("PUT", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.put("https://api.glideapps.com/tables/{tableID}")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"rows\": [\n {\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5,\n \"amountPaid\": 0\n },\n {\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75,\n \"amountPaid\": 20\n }\n ],\n \"schema\": {\n \"columns\": [\n {\n \"id\": \"fullName\",\n \"displayName\": \"Full Name\",\n \"type\": \"string\"\n },\n {\n \"id\": \"invoiceDate\",\n \"displayName\": \"Invoice Date\",\n \"type\": \"dateTime\"\n },\n {\n \"id\": \"totalAmount\",\n \"displayName\": \"Total\",\n \"type\": \"number\"\n },\n {\n \"id\": \"amountPaid\",\n \"displayName\": \"Paid\",\n \"type\": \"number\"\n }\n ]\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.glideapps.com/tables/{tableID}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"rows\": [\n {\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5,\n \"amountPaid\": 0\n },\n {\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75,\n \"amountPaid\": 20\n }\n ],\n \"schema\": {\n \"columns\": [\n {\n \"id\": \"fullName\",\n \"displayName\": \"Full Name\",\n \"type\": \"string\"\n },\n {\n \"id\": \"invoiceDate\",\n \"displayName\": \"Invoice Date\",\n \"type\": \"dateTime\"\n },\n {\n \"id\": \"totalAmount\",\n \"displayName\": \"Total\",\n \"type\": \"number\"\n },\n {\n \"id\": \"amountPaid\",\n \"displayName\": \"Paid\",\n \"type\": \"number\"\n }\n ]\n }\n}"
response = http.request(request)
puts response.read_body{
"data": {
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
]
}
}{
"data": {
"jobID": "<string>"
}
}{
"error": {
"type": "<string>",
"message": "<string>"
}
}{
"error": {
"type": "payment_required",
"message": "<string>"
}
}{
"error": {
"type": "table_not_found",
"message": "<string>"
}
}{
"error": {
"type": "precondition_failed",
"message": "<string>"
}
}{
"error": {
"type": "column_id_reserved",
"message": "<string>"
}
}Tables
Overwrite Table
Replaces the schema and/or data of a Big Table
PUT
/
tables
/
{tableID}
cURL
curl --request PUT \
--url https://api.glideapps.com/tables/{tableID} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"rows": [
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"totalAmount": 34.5,
"amountPaid": 0
},
{
"fullName": "Alicia Hines",
"invoiceDate": "2023-06-15T10:30:00.000Z",
"totalAmount": 50.75,
"amountPaid": 20
}
],
"schema": {
"columns": [
{
"id": "fullName",
"displayName": "Full Name",
"type": "string"
},
{
"id": "invoiceDate",
"displayName": "Invoice Date",
"type": "dateTime"
},
{
"id": "totalAmount",
"displayName": "Total",
"type": "number"
},
{
"id": "amountPaid",
"displayName": "Paid",
"type": "number"
}
]
}
}
'import requests
url = "https://api.glideapps.com/tables/{tableID}"
payload = {
"rows": [
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"totalAmount": 34.5,
"amountPaid": 0
},
{
"fullName": "Alicia Hines",
"invoiceDate": "2023-06-15T10:30:00.000Z",
"totalAmount": 50.75,
"amountPaid": 20
}
],
"schema": { "columns": [
{
"id": "fullName",
"displayName": "Full Name",
"type": "string"
},
{
"id": "invoiceDate",
"displayName": "Invoice Date",
"type": "dateTime"
},
{
"id": "totalAmount",
"displayName": "Total",
"type": "number"
},
{
"id": "amountPaid",
"displayName": "Paid",
"type": "number"
}
] }
}
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.put(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'PUT',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify({
rows: [
{
fullName: 'Alex Bard',
invoiceDate: '2024-07-29T14:04:15.561Z',
totalAmount: 34.5,
amountPaid: 0
},
{
fullName: 'Alicia Hines',
invoiceDate: '2023-06-15T10:30:00.000Z',
totalAmount: 50.75,
amountPaid: 20
}
],
schema: {
columns: [
{id: 'fullName', displayName: 'Full Name', type: 'string'},
{id: 'invoiceDate', displayName: 'Invoice Date', type: 'dateTime'},
{id: 'totalAmount', displayName: 'Total', type: 'number'},
{id: 'amountPaid', displayName: 'Paid', type: 'number'}
]
}
})
};
fetch('https://api.glideapps.com/tables/{tableID}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.glideapps.com/tables/{tableID}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "PUT",
CURLOPT_POSTFIELDS => json_encode([
'rows' => [
[
'fullName' => 'Alex Bard',
'invoiceDate' => '2024-07-29T14:04:15.561Z',
'totalAmount' => 34.5,
'amountPaid' => 0
],
[
'fullName' => 'Alicia Hines',
'invoiceDate' => '2023-06-15T10:30:00.000Z',
'totalAmount' => 50.75,
'amountPaid' => 20
]
],
'schema' => [
'columns' => [
[
'id' => 'fullName',
'displayName' => 'Full Name',
'type' => 'string'
],
[
'id' => 'invoiceDate',
'displayName' => 'Invoice Date',
'type' => 'dateTime'
],
[
'id' => 'totalAmount',
'displayName' => 'Total',
'type' => 'number'
],
[
'id' => 'amountPaid',
'displayName' => 'Paid',
'type' => 'number'
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>",
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.glideapps.com/tables/{tableID}"
payload := strings.NewReader("{\n \"rows\": [\n {\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5,\n \"amountPaid\": 0\n },\n {\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75,\n \"amountPaid\": 20\n }\n ],\n \"schema\": {\n \"columns\": [\n {\n \"id\": \"fullName\",\n \"displayName\": \"Full Name\",\n \"type\": \"string\"\n },\n {\n \"id\": \"invoiceDate\",\n \"displayName\": \"Invoice Date\",\n \"type\": \"dateTime\"\n },\n {\n \"id\": \"totalAmount\",\n \"displayName\": \"Total\",\n \"type\": \"number\"\n },\n {\n \"id\": \"amountPaid\",\n \"displayName\": \"Paid\",\n \"type\": \"number\"\n }\n ]\n }\n}")
req, _ := http.NewRequest("PUT", url, payload)
req.Header.Add("Authorization", "Bearer <token>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.put("https://api.glideapps.com/tables/{tableID}")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"rows\": [\n {\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5,\n \"amountPaid\": 0\n },\n {\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75,\n \"amountPaid\": 20\n }\n ],\n \"schema\": {\n \"columns\": [\n {\n \"id\": \"fullName\",\n \"displayName\": \"Full Name\",\n \"type\": \"string\"\n },\n {\n \"id\": \"invoiceDate\",\n \"displayName\": \"Invoice Date\",\n \"type\": \"dateTime\"\n },\n {\n \"id\": \"totalAmount\",\n \"displayName\": \"Total\",\n \"type\": \"number\"\n },\n {\n \"id\": \"amountPaid\",\n \"displayName\": \"Paid\",\n \"type\": \"number\"\n }\n ]\n }\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.glideapps.com/tables/{tableID}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Put.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"rows\": [\n {\n \"fullName\": \"Alex Bard\",\n \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n \"totalAmount\": 34.5,\n \"amountPaid\": 0\n },\n {\n \"fullName\": \"Alicia Hines\",\n \"invoiceDate\": \"2023-06-15T10:30:00.000Z\",\n \"totalAmount\": 50.75,\n \"amountPaid\": 20\n }\n ],\n \"schema\": {\n \"columns\": [\n {\n \"id\": \"fullName\",\n \"displayName\": \"Full Name\",\n \"type\": \"string\"\n },\n {\n \"id\": \"invoiceDate\",\n \"displayName\": \"Invoice Date\",\n \"type\": \"dateTime\"\n },\n {\n \"id\": \"totalAmount\",\n \"displayName\": \"Total\",\n \"type\": \"number\"\n },\n {\n \"id\": \"amountPaid\",\n \"displayName\": \"Paid\",\n \"type\": \"number\"\n }\n ]\n }\n}"
response = http.request(request)
puts response.read_body{
"data": {
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
]
}
}{
"data": {
"jobID": "<string>"
}
}{
"error": {
"type": "<string>",
"message": "<string>"
}
}{
"error": {
"type": "payment_required",
"message": "<string>"
}
}{
"error": {
"type": "table_not_found",
"message": "<string>"
}
}{
"error": {
"type": "precondition_failed",
"message": "<string>"
}
}{
"error": {
"type": "column_id_reserved",
"message": "<string>"
}
}Overwrite an existing Big Table by clearing all rows and (optionally) adding new data.
Row IDs for any added rows are returned in the response in the same order as the input row data is passed in the request. Row data may be passed in JSON, CSV, or TSV format.
If a column is not included in the passed row data, it will be empty in the added row. If a column is passed that does not exist in the updated table schema, or with a value that does not match the column’s type, the default behavior is for no action to be taken and the API call to return an error. However, you can control this behavior with the
onSchemaError query parameter.
There is currently no way to supply values for user-specific columns in the API. Those columns will be cleared when using this endpoint.
Updating the Schema
You can optionally update the table schema at the same time by providing a new schema in the JSON request body. If you do not provide a schema, the existing schema will be used. When using a CSV or TSV request body, you cannot pass a schema. If you need to update the schema, use theonSchemaError=updateSchema query parameter, or stash the CSV/TSV data and pass a JSON request body referencing the stash ID.
Examples
Clear table data
Clear table data
To clear all rows from a table, send a PUT request with an empty array in the
rows field:{
"rows": []
}
Reset table data
Reset table data
If you want to reset a table’s data with a small number of rows, you can do so by providing the data inline in the However, this is only appropriate for relatively small initial datasets (around a few hundred rows or less, depending on schema complexity). If you need to work with a larger dataset you should utilize stashing.
rows field (being sure that row object structure matches the table schema):[
{
"fullName": "Alex Bard",
"ageInYears": 30,
"hiredOn": "2021-07-03"
}
]
Reset table data from Stash
Reset table data from Stash
Stashing is our process for handling the upload of large datasets. Break down your dataset into smaller, more manageable, pieces and upload them to a single stash ID.Then, to reset a table’s data from the stash, use the
$stashID reference in the rows field instead of providing the data inline:{
"rows": { "$stashID": "20240215-job32" }
}
Batch update table rows
Batch update table rows
This endpoint can be combined with the Get Rows endpoint and stashing to fetch the current table data, modify it, and then overwrite the table with the updated data:
- Call the Get Rows endpoint to fetch the current table data. Pass a reasonably high
limitquery parameter because you want to fetch all rows in as few requests as possible. - Modify the data as desired, and then stash the modified rows using the Stash Data endpoint.
- If a
continuationwas returned in step 1, repeat steps 1-3, passing thecontinuationquery parameter to Get Rows until all rows have been fetched, modified, and stashed. - Finally, call this endpoint with same stash ID used in step 2. This will overwrite the table with the updated data:
{
"rows": { "$stashID": "20240215-job32" }
}
Risk of Data LossWe strongly recommend you use the
If-Match header to ensure the table is not modified between steps 1 and 4. See the Data Versioning guide for more information.Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Headers
Allow asynchronous processing, which will return a job ID. Note that this does not force asynchronouys processing. The caller must handle both synchronous and asynchronous responses.
Available options:
true, false ETag of the current table version. If provided, the request will fail if the table has been updated since the given version. See Data Versioning.
Pattern:
^"[0-9]+"$Path Parameters
ID of the table, e.g., 2a1bad8b-cf7c-44437-b8c1-e3782df6
Example:
"2a1bad8b-cf7c-44437-b8c1-e3782df6"
Query Parameters
The action to take when the passed data does not match the table schema:
abort: Abort the entire operation and return an error.dropColumns: Ignore the data that caused the error, and do not import those columns in the affected rows.updateSchema: Update the schema as needed to add any missing columns or widen the data types of existing columns, and then import the data from them.
Available options:
abort, dropColumns, updateSchema Example:
"updateSchema"
Body
application/jsontext/csvtext/tab-separated-values
- object
- object[]
A row object conforming to the schema of the table, where keys are the column IDs and values are the column values:
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"totalAmount": 34.50,
"amountPaid": 0
}
- object[]
- object
Show child attributes
Show child attributes
Example:
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"totalAmount": 34.5,
"amountPaid": 0
}
The schema of the table as a collection of column definitions.
Show child attributes
Show child attributes
Example:
{
"columns": [
{
"id": "fullName",
"displayName": "Full Name",
"type": "string"
},
{
"id": "invoiceDate",
"displayName": "Invoice Date",
"type": "dateTime"
},
{
"id": "totalAmount",
"displayName": "Total",
"type": "number"
},
{
"id": "amountPaid",
"displayName": "Paid",
"type": "number"
}
]
}
Response
Show child attributes
Show child attributes
Was this page helpful?