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

ActionWhat it does
Add rowAdd a row to a Big Table, with a value for each column you fill in.
Add rowsAdd many rows to a Big Table at once, from a list or a stash.
Create tableCreate a Big Table with the columns given, and optionally its first rows (or a stash of them).
Delete rowDelete one row of a Big Table.
Delete stashThrow away a stash and every chunk in it, without writing its rows.
Get rowGet one row of a Big Table by its row id, with its values by column ID.
Get rowsGet a page of a Big Table's rows, each with its row id and values by column ID.
Get table versionGet a Big Table's version, a number that goes up whenever its data changes.
List tablesList every Big Table in the team the API token belongs to, with its id.
Overwrite tableDelete every row of a Big Table and add the rows given instead (or none, to empty it), optionally with new columns.
Stash rowsPut a chunk of rows in a stash, Glide's holding area for large writes.
Update rowChange 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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
Valuesvaluesobject
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 columnsother_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 columnson_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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
Rowsrowslist
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 IDstash_idtext
Use every row put in this stash with 'Stash rows' instead of Rows, in one go.
If data doesn't fit the columnson_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

NamenametextRequired
The table's name, as Glide's Data Editor shows it.
Columnscolumnslist
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`).
Rowsrowslist
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 IDstash_idtext
Use every row put in this stash with 'Stash rows' instead of Rows, in one go.
Link to appsapps_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 columnson_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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
Row IDrow_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 IDstash_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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
Row IDrow_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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
Most rowslimitnumber
The most rows to get, 1 to 10,000. Glide may return fewer. Leave empty for Glide's default.From 1 to 10000.
Continuationcontinuationtext
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

Tabletable_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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
New rowsrowslist
The rows the table holds afterwards, each with column IDs and values. Leave empty to delete every row.
Stash IDstash_idtext
Use every row put in this stash with 'Stash rows' instead of Rows, in one go.
New columnscolumnslist
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 versionexpected_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 columnson_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 IDstash_idtextRequired
A name you choose for the stash: letters, digits, '-' and '_', such as 20240215-job32. It is made on first use.
Chunk numberserialtextRequired
This chunk's place in the stash, such as 1, 2, 3. Chunks are written in this order; the same number replaces a chunk.
RowsrowslistRequired
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

Tabletable_idtextRequired
The Big Table. Pick one, or give its id from an earlier step.
Row IDrow_idtextRequired
The row's id, from 'Get rows', 'Add row' or the 'New row' trigger.
Valuesvaluesobject
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 columnsother_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 versionexpected_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 columnson_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
}

On this page