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.1 (08.11.2024)

📘

New requests

Account Operations - System Admin

Account Operations - User

Version 5.0 (15.07.2024)

View API Documentation for v5.0

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)

View API Documentation for v4.4

📘

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

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