cURL
curl --request POST \
--url https://api.glideapps.com/tables \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"name": "Invoices",
"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"
}
]
},
"appsToLink": [
"<string>"
]
}
'import requests
url = "https://api.glideapps.com/tables"
payload = {
"name": "Invoices",
"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"
}
] },
"appsToLink": ["<string>"]
}
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({
name: 'Invoices',
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'}
]
},
appsToLink: ['<string>']
})
};
fetch('https://api.glideapps.com/tables', 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",
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([
'name' => 'Invoices',
'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'
]
]
],
'appsToLink' => [
'<string>'
]
]),
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"
payload := strings.NewReader("{\n \"name\": \"Invoices\",\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 \"appsToLink\": [\n \"<string>\"\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")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"Invoices\",\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 \"appsToLink\": [\n \"<string>\"\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.glideapps.com/tables")
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 \"name\": \"Invoices\",\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 \"appsToLink\": [\n \"<string>\"\n ]\n}"
response = http.request(request)
puts response.read_body{
"data": {
"tableID": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
],
"linkedAppIDs": [
"<string>"
]
}
}{
"data": {
"tableID": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"jobID": "<string>"
}
}{
"error": {
"type": "<string>",
"message": "<string>"
}
}{
"error": {
"type": "payment_required",
"message": "<string>"
}
}{
"error": {
"type": "column_id_reserved",
"message": "<string>"
}
}Tables
Create Table
Creates a new Big Table
POST
/
tables
cURL
curl --request POST \
--url https://api.glideapps.com/tables \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"name": "Invoices",
"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"
}
]
},
"appsToLink": [
"<string>"
]
}
'import requests
url = "https://api.glideapps.com/tables"
payload = {
"name": "Invoices",
"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"
}
] },
"appsToLink": ["<string>"]
}
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({
name: 'Invoices',
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'}
]
},
appsToLink: ['<string>']
})
};
fetch('https://api.glideapps.com/tables', 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",
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([
'name' => 'Invoices',
'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'
]
]
],
'appsToLink' => [
'<string>'
]
]),
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"
payload := strings.NewReader("{\n \"name\": \"Invoices\",\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 \"appsToLink\": [\n \"<string>\"\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")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"name\": \"Invoices\",\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 \"appsToLink\": [\n \"<string>\"\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.glideapps.com/tables")
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 \"name\": \"Invoices\",\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 \"appsToLink\": [\n \"<string>\"\n ]\n}"
response = http.request(request)
puts response.read_body{
"data": {
"tableID": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
],
"linkedAppIDs": [
"<string>"
]
}
}{
"data": {
"tableID": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"jobID": "<string>"
}
}{
"error": {
"type": "<string>",
"message": "<string>"
}
}{
"error": {
"type": "payment_required",
"message": "<string>"
}
}{
"error": {
"type": "column_id_reserved",
"message": "<string>"
}
}Create a new Big Table, define its structure, and (optionally) populate it with 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.
When using a CSV or TSV request body, the name of the table must be passed as a query parameter and the schema of the table is always inferred from the content. Alternatively, the CSV/TSV content may be stashed, and then the schema and name may be passed in the regular JSON payload.
If a schema is passed in the payload, any passed row data must match that schema. 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 schema, or with a value that does not match the column’s type, the default behavior is for the table to not be created and the API call to return an error. However, you can control this behavior with the
onSchemaError query parameter.
Examples
Create Table w/ Row Data
Create Table w/ Row Data
If you want to create a table and populate it with an initial dataset, 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):{
"name": "Employees",
"schema": { ... },
"rows": [
{
"fullName": "Alex Bard",
"ageInYears": 30,
"hiredOn": "2021-07-03"
}
]
}
Create Table from Stash
Create Table 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 create a table from a stash, you can use the
$stashID reference in the rows field instead of providing the data inline:{
"name": "Employees",
"schema": { ... },
"rows": {
"$stashID": "20240215-job32"
}
}
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 Query Parameters
Name of the table. Required when the name is not passed in the request body. It is an error to pass a name in both this query parameter and the request body.
Example:
"Invoices"
An array of app IDs to link the new table to.
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[]
Name of the table, e.g., Invoices
Example:
"Invoices"
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. If this is not provided, the schema will be inferred from the data.
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"
}
]
}
An array of app IDs to link the new table to.
Response
Show child attributes
Show child attributes
Was this page helpful?