API Reference

Changelog

This page lists changes made to the Web API and its documentation.

Listed below are all the changes to the SeaTable API. Each date corresponds to a new version of SeaTable Server Enterprise Edition. If youโ€™re looking for changes beyond the API, see the SeaTable Changelog or check out the SeaTable Blog for detailed release notes.

Version 5.0 (15.07.2024)

We recommend using the new /api-gateway/ endpoints. These endpoints are faster because they check if the base has remained unchanged since the last request, allowing for quicker responses.

๐Ÿšง

Breaking changes

  • Get Row and List Rows: Link now returns an array containing display_value and row_id instead of a string with only the display_value. This change harmonizes the output with Get Row and List Rows with SQL endpoints.
  • Get Row and List Rows: Link Formula now returns the right output type depending of the result. Single numbers are returned as integers, multiple values as arrays. This change harmonizes the output of the Get Row, List Rows and List Rows with SQL endpoints.

๐Ÿ‘

Other changes

  • Get Row: All column values are now consistently returned. If a value is not defined, null is returned instead of omitting the value.
  • List Rows: All column values are now consistently returned. If a value is not defined, null is returned instead of omitting the value.
  • Query SeaTable with SQL: Now supports parameters to protect against SQL injection.

For more details about the changes, please refer to this post on the SeaTable Forum.

Version 4.4 (15.05.2024)

๐Ÿ“˜

New requests

Base Operations (from 4.4)

Starting with version 4.4, SeaTable introduced a new component to SeaTable Server: the API Gateway. It introduces several new API endpoints and improvements to existing ones, creating a more streamlined experience for all base operations. You can identify the new endpoints by their URLs, which include /api-gateway/. The old API endpoints for dtable-server and dtable-db are still valid and could be used.

๐Ÿšง

Breaking changes

  • data collection table calls (user) were removed. This was done because data collection tables will be disabled in general with version 5.0. In SeaTable Cloud this feature was never available.
  • Get Row: _mtime and _ctime are not returned if these column types are defined in this base. This is to harmonize the output with List Rows and List Rows with SQL.

๐Ÿ‘

Other changes

  • List Rows: The options order_by and direction were removed to avoid conflict situations with a selected view.
  • API-Gateway calls now return the current api usage and limits via X-header.

Version 4.3 (08.02.2024)

The SeaTable API Reference for version 4.3 is no longer accessible here. However, you can find it on Github.

๐Ÿ“˜

New requests

Base Operations

Create Row Links in Big Data post /dtable-db/api/v1/base/{base_uuid}/links/ [Delete Row Links in Big Data](/reference/post_dtable-db-api-v1-base-base-uuid-links) <span class="APIMethod APIMethod_fixedWidth APIMethod_delete">delete</span> /dtable-db/api/v1/base/{base_uuid}/links/`

Account Operations - System Admin

Account Operations - Team Admin

Account Operations - User

๐Ÿ‘

Other changes

  • New option to export the base with or without assets in GET /api/v2.1/admin/dtables/{base_uuid}/synchronous-export/export-dtable/.

Version 4.2 (22.11.2023)

The SeaTable API Reference for version 4.2 is no longer accessible here. However, you can find it on Github.

๐Ÿ“˜

New requests

  • New Category: Python Scheduler
  • Export base: GET /api/v2.1/admin/dtables/{base_uuid}/synchronous-export/export-dtable/
  • Search base/apps of a user: GET /api/v2.1/dtable/items-search/
  • Activate/Deactivate app: PUT /api/v2.1/external-apps/{app_token}/status/

๐Ÿšง

Breaking changes

None

๐Ÿ‘

Other changes

  • Deprecated base export calls for sytem admins were removed from documentation.

Version 4.1 (23.08.2023)

The SeaTable API Reference for version 4.1 is no longer accessible here. However, you can find it on Github.

๐Ÿ“˜

New requests

  • Add user to multiple groups: POST /api/v2.1/admin/users/{username}/groups/

๐Ÿ‘

Other changes

  • Add Row and Update Row: unknown single select or multiple-select options will be created
  • Improved data type and structure checks for /rows/ endpoint
  • row_id cannot be changed anymore with Update Row
  • Fixed permission issue with endpoint /api/v2.1/org/<org_id>/admin/groups/<group_id>/members/
  • Filter validation for List Rows (with SQL)

๐Ÿšง

Breaking changes

None

Version 4.0 (27.06.2023)

The SeaTable API Reference for version 4.0 is no longer accessible here. However, you can find it on Github.

๐Ÿ“˜

New requests

  • Search User by Org-ID: GET api/v2.1/admin/search-user-by-org-id/
  • List Plugins Install Count: GET api/v2.1/admin/plugins-install-count/
  • List Org-Admin operations logs: GET api/v2.1/org/{org_id}/admin/admin-logs/
  • Update Team Logo: POST api/v2.1/org/{org_id}/admin/org-logo/
  • Get Team Logo: GET api/v2.1/org/{org_id}/admin/org-logo/
  • Delete Team Logo: DELETE api/v2.1/org/{org_id}/admin/org-logo/
  • Export Big Data View to Excel: GET api/v2.1/workspace/{workspace_id}/dtable/{base_name}/convert-big-data-view-to-excel/
  • Append Excel csv POST api/v2.1/workspace/{workspace_id}/synchronous-import/append-excel-csv-to-table/
  • List Universal Apps GET api/v2.1/universal-apps/
  • Batch import user to Universal App POST api/v2.1/universal-apps/{app_token}/app-users/batch/
  • List Universal App Users GET api/v2.1/universal-apps/{app_token}/app-users/
  • List Universal App Invite Links GET api/v2.1/universal-apps/{app_token}/invite-links/
  • Move Rows to Big Data POST /api/v1/dtables/{base_uuid}/archive-view/
  • Get Folder Content (Custom Folder)
  • Get File Metadata (Custom Folder)
  • Get Upload Link (Custom Folder)
  • Get Download Link (Custom Folder)

๐Ÿ‘

Other changes

  • Added support for bearer authentication

๐Ÿšง

Breaking changes

  • Get Base-Token with Invite-Link GET api/v2.1/dtable/share-link-access-token/ was removed

Version 3.5 (12.04.2023)

The SeaTable API Reference for version 3.5 is no longer available.

๐Ÿšง

Breaking changes

  • Import from CSV POST dtable-server/api/v1/dtables/{base_uuid}/import-csv/ was replaced with this new call
  • Append from CSV POST dtable-server/api/v1/dtables/{base_uuid}/append-csv/ was replaced with this new call
  • Create Row Comment POST dtable-server/api/v1/dtables/{base_uuid}/comments/ was removed
  • Update Row Comment PUT dtable-server/api/v1/dtables/{base_uuid}/comments/ was removed