GET /api/database/rows/table/:table_id/:row_id — baserow-api-spec

Abuse reports1

Admin23

Admin data scanner10

AI Assistant9

AI providers10

Applications8

Audit log8

Auth15

Automation history2

Automation nodes8

Automation workflows9

Builder data sources11

Builder domains7

Builder elements7

Builder pages5

Builder public6

Builder theme1

Builder workflow actions7

Core webhooks5

Dashboard data sources3

Dashboard widgets4

Database table calendar view2

Database table export2

Database table fields18

Database table form view5

Database table gallery view2

Database table grid view8

Database table kanban view2

Database table rows17

Database table timeline view2

Database table view decorations5

Database table view export2

Database table view filters9

Database table view groupings6

Database table view sortings6

Database table views18

Database table webhooks6

Database tables18

Database tokens6

Field permissions3

Field rules5

Health3

Integrations5

Jobs4

MCP endpoints5

Notifications4

Role assignments3

Search1

Secure file serve1

Settings3

Snapshots4

Teams9

Templates3

Trash4

User17

User files2

User source roles1

User sources14

Workspace invitations8

Workspaces18

Database table rows

Fetches an existing row from the table if the user has access to the related table's workspace. The properties of the returned row depend on which fields the table has. For a complete overview of fields use the list_database_table_fields endpoint to list them all. In the example all field types are listed, but normally the number in field_{id} key is going to be the id of the field of the field. Or if the GET parameter user_field_names is provided then the keys will be the name of the field. The value is what the user has provided and the format of it depends on the fields type.

get/api/database/rows/table/{table_id}/{row_id}/

Path parameters

row_idinteger required

Returns the row related the provided value.

table_idinteger required

Returns the row of the table related to the provided value.

Query parameters

includestring

Optionally include row's metadata in the response. The metadata object includes extra row specific data like the 'row_comments_notification_mode' settings, if available.

user_field_namesboolean

A flag query parameter that, if provided with one of the following values: y, yes, true, t, on, 1, or an empty value, will cause the returned JSON to use the user-specified field names instead of the internal Baserow field names (e.g., field_123).

viewinteger

Provide if the row if fetched in a view. This can result in different permission checking and default values.

Response

idinteger required

The unique identifier of the row in the table.

orderstring decimal

Indicates the position of the row, lowest first and highest last.

field_1string nullable

This field represents the text field. The number in field_1 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_2string nullable

This field represents the long_text field. The number in field_2 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_3string nullable

This field represents the url field. The number in field_3 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_4string nullable

This field represents the email field. The number in field_4 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_5string decimal nullable

This field represents the number field. The number in field_5 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_6integer

This field represents the rating field. The number in field_6 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_7boolean

This field represents the boolean field. The number in field_7 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_8string date nullable

This field represents the date field. The number in field_8 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_9string date-time

This field represents the last_modified field. The number in field_9 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_11string date-time

This field represents the created_on field. The number in field_11 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_13number float nullable

This field represents the duration field. The number in field_13 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field. The provided value can be a string in one of the available formats or a number representing the duration in seconds. In any case, the value will be rounded to match the field's duration format.

field_18string nullable

This field represents the phone_number field. The number in field_18 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_19string nullable

This field represents the formula field. The number in field_19 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_20string nullable

This field represents the count field. The number in field_20 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_21string nullable

This field represents the rollup field. The number in field_21 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_22string nullable

This field represents the lookup field. The number in field_22 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_24string uuid

This field represents the uuid field. The number in field_24 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field. Contains a unique and persistent UUID for every row.

field_25integer

This field represents the autonumber field. The number in field_25 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field. Contains a unique and persistent incremental integer number for every row.

field_26boolean

This field represents the password field. The number in field_26 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field. Allows setting a write only password value. Providing a string will set the password, null will unset it, true will be ignored. The response will respond with true is a password is set, but will never expose the password itself.

field_27string required

This field represents the form_view_edit_row field. The number in field_27 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_28string nullable

This field represents the button field. The number in field_28 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field.

field_29string nullable

This field represents the ai field. The number in field_29 is in a normal request or response the id of the field. If the GET parameter user_field_names is provided and its value is one of the following: y, yes, true, t, on, 1, or empty, then the key will instead be the actual name of the field. Holds a value that is generated by a generative AI model using a dynamic prompt.

Changes

Changed in 1 of the 6 revisions of this API.11

Aug 5, 20260c490e5b0c7f11See the full diff
- ▲
  the field_28 response property's maxLength was unset from 1000000 for the response status 200
  response-property-max-length-unset
- ○
  added the optional property field_29 to the response with the 200 status
  response-optional-property-added
This revision also has 4 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

Full history