Close menu
Explore Plans
Mobile menu Close menu
Back
Coda

Get row by ID

Pro plus icon This query returns the column values for a specific row in a Coda table.

Developer info

API endpoint slug
coda.row_by_id
Runtime method
performQuery("coda.row_by_id"}

Query fields

Doc table Nested dropdown list

Label
Which doc and table?
Helper text
Select the Coda doc and the table containing the row.
Slug
doc_table
Required
false
Can have default value
false

Row Text input > Other

Label
Row ID
Helper text
The ID of the row to look up (e.g. i-1234abcd56). You can get this from a Row created or Row updated trigger.
Slug
row_id
Required
false
Can have default value
true

Ingredients

Row The unique ID of the row.

Slug
row_id
Filter code
Coda.rowById.RowId
Type
String
Example
i-1234abcd56

Row name The display name of the row.

Slug
row_name
Filter code
Coda.rowById.RowName
Type
String
Example
Launch new landing page

Doc The ID of the doc the row belongs to.

Slug
doc_id
Filter code
Coda.rowById.DocId
Type
String
Example
AbCdEfGhIj

Table The ID of the table the row belongs to.

Slug
table_id
Filter code
Coda.rowById.TableId
Type
String
Example
grid-1A2B3C4D5E

Created at The date and time the row was created.

Slug
created_at
Filter code
Coda.rowById.CreatedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06+05:00

Updated at The date and time the row was most recently updated.

Slug
updated_at
Filter code
Coda.rowById.UpdatedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06+05:00

Browser link A link to the row in Coda.

Slug
browser_link
Filter code
Coda.rowById.BrowserLink
Type
Web URL
Example
https://coda.io/d/_dAbCdEfGhIj#_tugrid-1A2B3C4D5E/_rui-1234abcd56

Column values json All column values for the row, as a JSON object keyed by column name.

Slug
column_values_json
Filter code
Coda.rowById.ColumnValuesJson
Type
String
Example
{"Status":"Active"}

Column value1 Value of the 1st column in the table (display column order).

Slug
column_value_1
Filter code
Coda.rowById.ColumnValue1
Type
String
Example
Active

Column value2 Value of the 2nd column in the table.

Slug
column_value_2
Filter code
Coda.rowById.ColumnValue2
Type
String
Example
High

Column value3 Value of the 3rd column in the table.

Slug
column_value_3
Filter code
Coda.rowById.ColumnValue3
Type
String
Example
Jane Doe

Column value4 Value of the 4th column in the table.

Slug
column_value_4
Filter code
Coda.rowById.ColumnValue4
Type
String
Example
Hello World!

Column value5 Value of the 5th column in the table.

Slug
column_value_5
Filter code
Coda.rowById.ColumnValue5
Type
String
Example
Hello World!

Column value6 Value of the 6th column in the table.

Slug
column_value_6
Filter code
Coda.rowById.ColumnValue6
Type
String
Example
Hello World!

Column value7 Value of the 7th column in the table.

Slug
column_value_7
Filter code
Coda.rowById.ColumnValue7
Type
String
Example
Hello World!

Column value8 Value of the 8th column in the table.

Slug
column_value_8
Filter code
Coda.rowById.ColumnValue8
Type
String
Example
Hello World!

Column value9 Value of the 9th column in the table.

Slug
column_value_9
Filter code
Coda.rowById.ColumnValue9
Type
String
Example
Hello World!

Column value10 Value of the 10th column in the table.

Slug
column_value_10
Filter code
Coda.rowById.ColumnValue10
Type
String
Example
Hello World!

Column value11 Value of the 11th column in the table.

Slug
column_value_11
Filter code
Coda.rowById.ColumnValue11
Type
String
Example
Hello World!

Column value12 Value of the 12th column in the table.

Slug
column_value_12
Filter code
Coda.rowById.ColumnValue12
Type
String
Example
Hello World!

Column value13 Value of the 13th column in the table.

Slug
column_value_13
Filter code
Coda.rowById.ColumnValue13
Type
String
Example
Hello World!

Column value14 Value of the 14th column in the table.

Slug
column_value_14
Filter code
Coda.rowById.ColumnValue14
Type
String
Example
Hello World!

Column value15 Value of the 15th column in the table.

Slug
column_value_15
Filter code
Coda.rowById.ColumnValue15
Type
String
Example
Hello World!

Column value16 Value of the 16th column in the table.

Slug
column_value_16
Filter code
Coda.rowById.ColumnValue16
Type
String
Example
Hello World!

Column value17 Value of the 17th column in the table.

Slug
column_value_17
Filter code
Coda.rowById.ColumnValue17
Type
String
Example
Hello World!

Column value18 Value of the 18th column in the table.

Slug
column_value_18
Filter code
Coda.rowById.ColumnValue18
Type
String
Example
Hello World!

Column value19 Value of the 19th column in the table.

Slug
column_value_19
Filter code
Coda.rowById.ColumnValue19
Type
String
Example
Hello World!

Column value20 Value of the 20th column in the table.

Slug
column_value_20
Filter code
Coda.rowById.ColumnValue20
Type
String
Example
Hello World!

Column value21 Value of the 21st column in the table.

Slug
column_value_21
Filter code
Coda.rowById.ColumnValue21
Type
String
Example
Hello World!

Column value22 Value of the 22nd column in the table.

Slug
column_value_22
Filter code
Coda.rowById.ColumnValue22
Type
String
Example
Hello World!

Column value23 Value of the 23rd column in the table.

Slug
column_value_23
Filter code
Coda.rowById.ColumnValue23
Type
String
Example
Hello World!

Column value24 Value of the 24th column in the table.

Slug
column_value_24
Filter code
Coda.rowById.ColumnValue24
Type
String
Example
Hello World!

Column value25 Value of the 25th column in the table.

Slug
column_value_25
Filter code
Coda.rowById.ColumnValue25
Type
String
Example
Hello World!

Column value26 Value of the 26th column in the table. Use ColumnValuesJson for columns beyond this position.

Slug
column_value_26
Filter code
Coda.rowById.ColumnValue26
Type
String
Example
Hello World!