GET /api/database/rows/table/{table_id}/{row_id}/adjacent/

Fetches the adjacent row to a given row_id in the table with the given table_id. If the previous flag is set it will return the previous row, otherwise it will return the next row. You can specifya view_id and it will apply the filters and sorts of the provided view.

Servers

Path parameters

Name Type Required Description
table_id Integer Yes

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

row_id Integer Yes

Returns the row adjacent the provided value.

Query parameters

Name Type Required Description
user_field_names Boolean No

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).

search String No

If provided, the adjacent row will be one that matchesthe search query.

search_mode String No

If provided, allows API consumers to determine what kind of search experience they wish to have. If the default SearchModes.MODE_FT_WITH_COUNT is used, then Postgres full-text search is used. If SearchModes.MODE_COMPAT is provided then the search term will be exactly searched for including whitespace on each cell. This is the Baserow legacy search behaviour.

view_id Integer No

Applies the filters and sorts of the provided view.

previous Boolean No

A flag query parameter which if provided returns theprevious row to the specified row_id. If it's not setit will return the next row.

How to start integrating

  1. Add HTTP Task to your workflow definition.
  2. Search for the API you want to integrate with and click on the name.
    • This loads the API reference documentation and prepares the Http request settings.
  3. Click Test request to test run your request to the API and see the API's response.