Glide
App · 12 actions
Read and write the Big Tables behind your Glide apps: list and create tables, get, add, update and delete rows, bulk-load rows through a stash, and start a workflow when a row is added.
Actions
| Action | What it does |
|---|---|
| Add row | Add a row to a Big Table, with a value for each column you fill in. |
| Add rows | Add many rows to a Big Table at once, from a list or a stash. |
| Create table | Create a Big Table with the columns given, and optionally its first rows (or a stash of them). |
| Delete row | Delete one row of a Big Table. |
| Delete stash | Throw away a stash and every chunk in it, without writing its rows. |
| Get row | Get one row of a Big Table by its row id, with its values by column ID. |
| Get rows | Get a page of a Big Table's rows, each with its row id and values by column ID. |
| Get table version | Get a Big Table's version, a number that goes up whenever its data changes. |
| List tables | List every Big Table in the team the API token belongs to, with its id. |
| Overwrite table | Delete every row of a Big Table and add the rows given instead (or none, to empty it), optionally with new columns. |
| Stash rows | Put a chunk of rows in a stash, Glide's holding area for large writes. |
| Update row | Change the columns you fill in on one row of a Big Table; the others keep their values. |
Add row
Add a row to a Big Table, with a value for each column you fill in.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- Values
valuesobject - A value for each column of the table. Leave a field empty to leave it out. Columns are read from the table's rows, so a new table's columns go in Other columns.
- Other columns
other_valuesobject - Values for columns not listed in Values, by column ID (as 'Get rows' shows it, such as fullName).
- If data doesn't fit the columns
on_schema_errortext - What Glide does with a column that doesn't exist or a value of the wrong type. Defaults to stopping and changing nothing.One of:
abort(Stop and change nothing (default)),dropColumns(Leave out the values that don't fit),updateSchema(Add missing columns and widen types). Default:abort.
Outputs
rowobject- The values sent, by column ID
row_idtext- The new row's id
table_idtext- The table's id
Example output
{
"row": {
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"paid": false,
"totalAmount": 34.5
},
"row_id": "zcJWnyI8Tbam21V34K8MNA",
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Add rows
Add many rows to a Big Table at once, from a list or a stash. If one row doesn't fit the columns, none are added unless you choose otherwise.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- Rows
rowslist - A list of rows from an earlier step, each with column IDs and values, such as [{"fullName": "Alex Bard", "age": 30}]. Up to 1,000; stash more.
- Stash ID
stash_idtext - Use every row put in this stash with 'Stash rows' instead of Rows, in one go.
- If data doesn't fit the columns
on_schema_errortext - What Glide does with a column that doesn't exist or a value of the wrong type. Defaults to stopping and changing nothing.One of:
abort(Stop and change nothing (default)),dropColumns(Leave out the values that don't fit),updateSchema(Add missing columns and widen types). Default:abort.
Outputs
row_countnumber- How many rows were added
row_idslist- The added rows' ids, in the order the rows were given
table_idtext- The table's id
Example output
{
"row_count": 2,
"row_ids": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19cf7c44437b8c1e9acb"
],
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Create table
Create a Big Table with the columns given, and optionally its first rows (or a stash of them). Without columns, Glide works them out from the rows.
Inputs
- Name
nametextRequired - The table's name, as Glide's Data Editor shows it.
- Columns
columnslist - The table's columns in order, each with an ID (fixed once made, such as fullName), a name people see, and a type: Text (`string`), Number (`number`), True/false (`boolean`), Date and time (`dateTime`), Date (`date`), Time (`time`), Duration (`duration`), Link (URL) (`uri`), Image link (`imageURI`), Audio link (`audioURI`), Email address (`emailAddress`), Phone number (`phoneNumber`), Markdown (`markdown`), Emoji (`emoji`).
- Rows
rowslist - A list of rows from an earlier step, each with column IDs and values, such as [{"fullName": "Alex Bard", "age": 30}]. Up to 1,000; stash more.
- Stash ID
stash_idtext - Use every row put in this stash with 'Stash rows' instead of Rows, in one go.
- Link to apps
apps_to_linktext - App IDs to make the table available in (the part after /app/ in the app's builder link), separated by commas.
- If data doesn't fit the columns
on_schema_errortext - What Glide does with a column that doesn't exist or a value of the wrong type. Defaults to stopping and changing nothing.One of:
abort(Stop and change nothing (default)),dropColumns(Leave out the values that don't fit),updateSchema(Add missing columns and widen types). Default:abort.
Outputs
linked_app_idslist- The apps the table was linked to
nametext- The table's name
row_countnumber- How many rows were added
row_idslist- The added rows' ids, in the order the rows were given
table_idtext- The table's id
Example output
{
"linked_app_ids": [],
"name": "Invoices",
"row_count": 1,
"row_ids": [
"zcJWnyI8Tbam21V34K8MNA"
],
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Delete row
Delete one row of a Big Table. This can't be undone.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- Row ID
row_idtextRequired - The row's id, from 'Get rows', 'Add row' or the 'New row' trigger.
Outputs
deletedtrue/false- Always true once deleted
row_idtext- The row's id
table_idtext- The table's id
Example output
{
"deleted": true,
"row_id": "zcJWnyI8Tbam21V34K8MNA",
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Delete stash
Throw away a stash and every chunk in it, without writing its rows.
Inputs
- Stash ID
stash_idtextRequired - The stash to delete, as given to 'Stash rows'.
Outputs
deletedtrue/false- Always true once deleted
stash_idtext- The stash deleted
Example output
{
"deleted": true,
"stash_id": "20240215-job32"
}Get row
Get one row of a Big Table by its row id, with its values by column ID.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- Row ID
row_idtextRequired - The row's id, from 'Get rows', 'Add row' or the 'New row' trigger.
Outputs
rowobject- The row's values, by column ID
row_idtext- The row's id
table_idtext- The table's id
Example output
{
"row": {
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"paid": false,
"totalAmount": 34.5
},
"row_id": "zcJWnyI8Tbam21V34K8MNA",
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Get rows
Get a page of a Big Table's rows, each with its row id and values by column ID. To see more, run it again with the continuation it gives.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- Most rows
limitnumber - The most rows to get, 1 to 10,000. Glide may return fewer. Leave empty for Glide's default.From 1 to 10000.
- Continuation
continuationtext - The continuation from an earlier page, for the next.
Outputs
continuationtext- Give this for the next page; empty on the last
countnumber- How many rows on this page
has_moretrue/false- Whether more rows remain
rowslist- The rows: row_id, then a value by column ID
table_idtext- The table's id
Example output
{
"continuation": "",
"count": 2,
"has_more": false,
"rows": [
{
"fullName": "Alex Bard",
"invoiceDate": "2024-07-29T14:04:15.561Z",
"paid": false,
"row_id": "zcJWnyI8Tbam21V34K8MNA",
"totalAmount": 34.5
},
{
"fullName": "Alicia Hines",
"invoiceDate": "2023-06-15T10:30:00.000Z",
"paid": true,
"row_id": "93a19cf7c44437b8c1e9acb",
"totalAmount": 50.75
}
],
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Get table version
Get a Big Table's version, a number that goes up whenever its data changes. Give it to 'Update row' or 'Overwrite table' so they change nothing if someone else changed the table first.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
Outputs
table_idtext- The table's id
versiontext- The table's version
Example output
{
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"version": "1042"
}List tables
List every Big Table in the team the API token belongs to, with its id.
Inputs
None.
Outputs
countnumber- How many tables
tableslist- The team's Big Tables
Example output
{
"count": 2,
"tables": [
{
"id": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"name": "Invoices"
},
{
"id": "93a19-cf7c-44437-b8c1-e9acbbb",
"name": "Customers"
}
]
}Overwrite table
Delete every row of a Big Table and add the rows given instead (or none, to empty it), optionally with new columns. User-specific columns are cleared too. This can't be undone.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- New rows
rowslist - The rows the table holds afterwards, each with column IDs and values. Leave empty to delete every row.
- Stash ID
stash_idtext - Use every row put in this stash with 'Stash rows' instead of Rows, in one go.
- New columns
columnslist - Replace the table's columns. Leave empty to keep them. Each has an ID, a name and a type: Text (`string`), Number (`number`), True/false (`boolean`), Date and time (`dateTime`), Date (`date`), Time (`time`), Duration (`duration`), Link (URL) (`uri`), Image link (`imageURI`), Audio link (`audioURI`), Email address (`emailAddress`), Phone number (`phoneNumber`), Markdown (`markdown`), Emoji (`emoji`).
- Only if the table is still at version
expected_versiontext - The version from 'Get table version'. If the data changed since, Glide changes nothing. Leave empty to write regardless.
- If data doesn't fit the columns
on_schema_errortext - What Glide does with a column that doesn't exist or a value of the wrong type. Defaults to stopping and changing nothing.One of:
abort(Stop and change nothing (default)),dropColumns(Leave out the values that don't fit),updateSchema(Add missing columns and widen types). Default:abort.
Outputs
row_countnumber- How many rows were added
row_idslist- The added rows' ids, in the order the rows were given
table_idtext- The table's id
Example output
{
"row_count": 2,
"row_ids": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19cf7c44437b8c1e9acb"
],
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6"
}Stash rows
Put a chunk of rows in a stash, Glide's holding area for large writes. Stash chunks one after another, then give the stash ID to 'Add rows', 'Create table' or 'Overwrite table' to write them all at once.
Inputs
- Stash ID
stash_idtextRequired - A name you choose for the stash: letters, digits, '-' and '_', such as 20240215-job32. It is made on first use.
- Chunk number
serialtextRequired - This chunk's place in the stash, such as 1, 2, 3. Chunks are written in this order; the same number replaces a chunk.
- Rows
rowslistRequired - The chunk's rows, each with column IDs and values, up to 1,000.
Outputs
row_countnumber- How many rows were stashed
serialtext- The chunk number
stash_idtext- The stash
Example output
{
"row_count": 2,
"serial": "1",
"stash_id": "20240215-job32"
}Update row
Change the columns you fill in on one row of a Big Table; the others keep their values.
Inputs
- Table
table_idtextRequired - The Big Table. Pick one, or give its id from an earlier step.
- Row ID
row_idtextRequired - The row's id, from 'Get rows', 'Add row' or the 'New row' trigger.
- Values
valuesobject - A value for each column of the table. Leave a field empty to leave it out. Columns are read from the table's rows, so a new table's columns go in Other columns.
- Other columns
other_valuesobject - Values for columns not listed in Values, by column ID (as 'Get rows' shows it, such as fullName).
- Only if the table is still at version
expected_versiontext - The version from 'Get table version'. If the data changed since, Glide changes nothing. Leave empty to write regardless.
- If data doesn't fit the columns
on_schema_errortext - What Glide does with a column that doesn't exist or a value of the wrong type. Defaults to stopping and changing nothing.One of:
abort(Stop and change nothing (default)),dropColumns(Leave out the values that don't fit),updateSchema(Add missing columns and widen types). Default:abort.
Outputs
changesobject- The values sent, by column ID
row_idtext- The row's id
table_idtext- The table's id
updatedtrue/false- Always true once updated
Example output
{
"changes": {
"paid": true
},
"row_id": "zcJWnyI8Tbam21V34K8MNA",
"table_id": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"updated": true
}