How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Baserow Database tables API

The Database tables API from Baserow — 13 operation(s) for database tables.

Baserow Database tables API is one of 58 APIs that Baserow publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 1 JSON Schema definition.

Tagged areas include Database tables. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, authentication docs, and 1 JSON Schema.

This API exposes 18 operations across 13 paths, and defines 52 schemas. It is described by OpenAPI 3.0.3, at version 2.2.2.

Requests are made against the base URL https://api.baserow.io.

18 operations 13 paths 52 schemas 1 DELETE6 GET3 PATCH8 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.0.3
API Version
2.2.2
Base URL
https://api.baserow.io
Authentication
HTTP Bearer, HTTP Bearer, HTTP Bearer
License
Resource Areas
1

Authentication & Security 3

Baserow Database tables API declares 3 security schemes for authenticating requests. It accepts HTTP bearer tokens (Token your_token) (Database token). It accepts HTTP bearer tokens (JWT your_token) (JWT). It accepts HTTP bearer tokens (JWT your_token) (UserSource JWT).

Paths & Operations 18

Across 13 paths, the API surfaces 18 operations — 1 DELETE, 6 GET, 3 PATCH, 8 POST. Each is listed below with its method, path, parameters, and response codes.

Database tables 18
GET
/api/data-sync/{data_sync_id}/periodic-interval/
Responds with the periodic data sync interval data, if the user has the right permissions. This is an enterprise feature.
get_periodic_data_sync_interval 1 param → 200400404
PATCH
/api/data-sync/{data_sync_id}/periodic-interval/
Updates the periodic data sync interval, if the user has the right permissions. This is an enterprise feature.
update_periodic_data_sync_interval 1 param body → 200400404
GET
/api/database/data-sync/{data_sync_id}/
Responds with the data sync, including the data sync type specific properties, if the user has the right permissions.
get_table_data_sync 1 param → 200400404
PATCH
/api/database/data-sync/{data_sync_id}/
Updates the properties of the provided data sync, if the user has the right permissions. Note that if the syncedproperties is not provided, the available properties change, then the unavailable ones…
update_table_data_sync 1 param body → 200400404
GET
/api/database/data-sync/{data_sync_id}/properties/
Lists all the available properties of the provided data sync.
get_table_data_sync_properties 2 params → 200400404
POST
/api/database/data-sync/{data_sync_id}/sync/async/
Start a job to sync the data sync table with the provided datasyncid parameter if the authorized user has access to the database's workspace.
sync_data_sync_table_async 1 param → 202400404
POST
/api/database/data-sync/database/{database_id}/
Creates a new data sync table with the given data sync type. This will technically create a table, but it's synchronized with the provided data sync information. This means that some fields related t…
create_database_data_sync_table 3 params body → 200400404
POST
/api/database/data-sync/properties/
Lists all the properties of the provided data sync type given the request data. This can be used to choose which properties should be included when creating the data sync.
get_table_data_sync_type_properties body → 200400
GET
/api/database/tables/{table_id}/
Returns the requested table if the authorized user has access to the related database's workspace.
get_database_table 1 param → 200400404
PATCH
/api/database/tables/{table_id}/
Updates the existing table if the authorized user has access to the related database's workspace.
update_database_table 3 params body → 200400404
DELETE
/api/database/tables/{table_id}/
Deletes the existing table if the authorized user has access to the related database's workspace.
delete_database_table 3 params → 204400404
POST
/api/database/tables/{table_id}/duplicate/async/
Start a job to duplicate the table with the provided tableid parameter if the authorized user has access to the database's workspace.
duplicate_database_table_async 3 params → 202400404
POST
/api/database/tables/{table_id}/import/async/
Import data in the specified table if the authorized user has access to the related database's workspace. This endpoint is asynchronous and return the created job to track the progress of the task.
import_data_database_table_async 1 param body → 202400404
GET
/api/database/tables/all-tables/
This endpoint only works in combination with the token authentication. It lists all the tables that the token has either create, read, update or delete access to.
list_all_token_tables → 200
GET
/api/database/tables/database/{database_id}/
Lists all the tables that are in the database related to the databaseid parameter if the user has access to the database's workspace. A table is exactly as the name suggests. It can hold multiple fie…
list_database_tables 1 param → 200400404
POST
/api/database/tables/database/{database_id}/
Creates synchronously a new table for the database related to the provided databaseid parameter if the authorized user has access to the database's workspace. As an alternative you can use the create…
create_database_table 3 params body → 200400404
POST
/api/database/tables/database/{database_id}/async/
Creates a job that creates a new table for the database related to the provided databaseid parameter if the authorized user has access to the database's workspace. This endpoint is asynchronous and r…
create_database_table_async 2 params body → 202400404
POST
/api/database/tables/database/{database_id}/order/
Changes the order of the provided table ids to the matching position that the id has in the list. If the authorized user does not belong to the workspace it will be ignored. The order of the not prov…
order_database_tables 3 params body → 204400404

Schemas 52

The contract defines 52 schemas that model the data the API accepts and returns. The most detailed are PostgreSQLDataSyncDataSync (16 properties), FileImportJobTypeResponse (14 properties), JiraIssuesDataSyncDataSync (13 properties), PostgreSQLDataSyncCreateDataSync (12 properties). Each schema is shown below with its type and property counts.

PatchedTableUpdate
object
1 property
PeriodicDataSyncInterval
object
3 properties 2 required
GitHubIssuesDataSyncListDataSyncPropertiesRequest
object
3 properties 3 required
Data_SyncListDataSyncPropertiesRequest
JiraIssuesDataSyncListDataSyncPropertiesRequest
object
5 properties 2 required
GitLabIssuesDataSyncDataSync
object
11 properties 6 required
GitLabIssuesDataSyncCreateDataSync
object
7 properties 4 required
HubSpotContactsDataSyncUpdateDataSync
object
3 properties
TableWithoutDataSync
object
4 properties 4 required
Type098Enum
string
icalcalendar - icalcalendar localbaserowtable - localbaserowtable jiraissues - jiraissues githubissues - githubissues gitlabissues - gitlabissues hubspotcontac…
FileImportJobTypeResponse
object
14 properties 8 required
HubSpotContactsDataSyncListDataSyncPropertiesRequest
object
1 property 1 required
Data_SyncCreateDataSync
OrderTables
object
1 property 1 required
ICalCalendarDataSyncCreateDataSync
object
6 properties 4 required
GitHubIssuesDataSyncDataSync
object
11 properties 7 required
TableCreate
object
5 properties 1 required
GitHubIssuesDataSyncCreateDataSync
object
7 properties 5 required
GitHubIssuesDataSyncUpdateDataSync
object
5 properties 2 required
DuplicateTableJobTypeResponse
object
9 properties 8 required
LocalBaserowTableDataSyncListDataSyncPropertiesRequest
object
3 properties 2 required
TableImport
object
4 properties 1 required
ICalCalendarDataSyncDataSync
object
10 properties 6 required
LocalBaserowTableDataSyncDataSync
object
11 properties 6 required
ICalCalendarDataSyncUpdateDataSync
object
4 properties 1 required
PatchedData_SyncUpdateDataSync
PostgreSQLDataSyncDataSync
object
16 properties 9 required
LocalBaserowTableDataSyncCreateDataSync
object
7 properties 4 required
Table
object
5 properties 5 required
GitLabIssuesDataSyncListDataSyncPropertiesRequest
object
3 properties 2 required
HubSpotContactsDataSyncCreateDataSync
object
5 properties 3 required
SyncDataSyncTableJobTypeResponse
object
8 properties 7 required
Report
object
1 property 1 required
DataSync
object
9 properties 5 required
PostgreSQLDataSyncCreateDataSync
object
12 properties 7 required
JiraAuthenticationEnum
string
APITOKEN - APITOKEN PERSONALACCESSTOKEN - PERSONALACCESSTOKEN
ICalCalendarDataSyncListDataSyncPropertiesRequest
object
2 properties 2 required
ListDataSyncProperty
object
5 properties 5 required
PatchedPeriodicDataSyncInterval
object
3 properties
TableImportConfiguration
object
Additional table import configuration.
3 properties
LocalBaserowTableDataSyncUpdateDataSync
object
5 properties 1 required
JiraIssuesDataSyncCreateDataSync
object
9 properties 4 required
DataSyncSyncedProperty
object
3 properties 2 required
GitLabIssuesDataSyncUpdateDataSync
object
5 properties 1 required
JiraIssuesDataSyncUpdateDataSync
object
7 properties 1 required
PostgreSQLDataSyncListDataSyncPropertiesRequest
object
8 properties 5 required
HubSpotContactsDataSyncDataSync
object
9 properties 5 required
PeriodicDataSyncIntervalIntervalEnum
string
MANUAL - MANUAL DAILY - DAILY HOURLY - HOURLY
JiraIssuesDataSyncDataSync
object
13 properties 6 required
PostgresqlSslmodeEnum
string
disable - disable allow - allow prefer - prefer require - require verify-ca - verify-ca verify-full - verify-full
PostgreSQLDataSyncUpdateDataSync
object
10 properties 4 required
Data_SyncDataSync

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

baserow-database-tables-api-openapi.yml Raw ↑

Other APIs Baserow publishes across the network.

Baserow Admin API
Baserow Admin data scanner API
Baserow AI Assistant API
Baserow Applications API
Baserow Audit log API
Baserow Auth API
Baserow Automation history API
Baserow Automation nodes API
Baserow Automation workflows API
Baserow Builder data sources API
Baserow Builder domains API
Baserow Builder elements API
Where this information came from

This is an independent, third-party profile of Baserow Database tables API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.