cURL
curl --request POST \
--url https://api.glideapps.com/tables/{tableID}/rows \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
[
{
"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
}
]
'import requests
url = "https://api.glideapps.com/tables/{tableID}/rows"
payload = [
{
"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
}
]
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
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
}
])
};
fetch('https://api.glideapps.com/tables/{tableID}/rows', 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}/rows",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
[
'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
]
]),
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}/rows"
payload := strings.NewReader("[\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]")
req, _ := http.NewRequest("POST", 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.post("https://api.glideapps.com/tables/{tableID}/rows")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\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]")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.glideapps.com/tables/{tableID}/rows")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "[\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]"
response = http.request(request)
puts response.read_body{
"data": {
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
]
}
}{
"error": {
"type": "<string>",
"message": "<string>"
}
}{
"error": {
"type": "payment_required",
"message": "<string>"
}
}{
"error": {
"type": "table_not_found",
"message": "<string>"
}
}{
"error": {
"type": "column_has_invalid_value",
"message": "<string>"
}
}Tables
Add Rows to Table
Adds rows to a Big Table
POST
/
tables
/
{tableID}
/
rows
cURL
curl --request POST \
--url https://api.glideapps.com/tables/{tableID}/rows \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
[
{
"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
}
]
'import requests
url = "https://api.glideapps.com/tables/{tableID}/rows"
payload = [
{
"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
}
]
headers = {
"Authorization": "Bearer <token>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
body: JSON.stringify([
{
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
}
])
};
fetch('https://api.glideapps.com/tables/{tableID}/rows', 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}/rows",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
[
'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
]
]),
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}/rows"
payload := strings.NewReader("[\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]")
req, _ := http.NewRequest("POST", 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.post("https://api.glideapps.com/tables/{tableID}/rows")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("[\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]")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.glideapps.com/tables/{tableID}/rows")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "[\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]"
response = http.request(request)
puts response.read_body{
"data": {
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
]
}
}{
"error": {
"type": "<string>",
"message": "<string>"
}
}{
"error": {
"type": "payment_required",
"message": "<string>"
}
}{
"error": {
"type": "table_not_found",
"message": "<string>"
}
}{
"error": {
"type": "column_has_invalid_value",
"message": "<string>"
}
}Add one or more rows to an existing Big Table.
Row IDs for the 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 table schema, or with a value that does not match the column’s type, the default behavior is for no rows to be added and the API call to return an error. However, you can control this behavior with the
onSchemaError query parameter.
Examples
Add Rows Inline
Add Rows Inline
If you want to add a small number of rows to a table, you can do so by providing the data inline (being sure that row object structure matches the table schema):However, this is only appropriate for relatively small dataset (a few hundred rows or less, depending on schema complexity). If you need to work with a larger dataset you should utilize stashing.
[
{
"fullName": "Alex Bard",
"ageInYears": 30,
"hiredOn": "2021-07-03"
}, {
"fullName": "Alicia Hines",
"ageInYears": 34,
"hiredOn": "2023-01-015"
}
]
Add Rows from Stash
Add Rows 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 add all the row data in a stash to the table in a single atomic operation, use the
$stashID reference in the rows field instead of providing the data inline:{
"$stashID": "20240215-job32"
}
Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
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
}
Response
Show child attributes
Show child attributes
Was this page helpful?