In this section, we will learn how to connect Baserow with other software. We are API-first which means it can be integrated with every tool you need to build apps, automate processes and drive productivity.

API documentation

After you have created your database schema and API key in the settings, your Baserow database provides its own REST API endpoints to create, read, update and delete rows.

The database documentation is generated automatically based on the tables and fields that are in your database.

In order to get the API documentation, click on the vertical ellipsis ⋮ beside the selected group and select ‘View API Docs’ from the group menu.

enter image description here

If you make changes to your database, table or fields it could be that the API interface has also changed. Therefore, make sure that you update your API implementation accordingly.

Simple token-based authentication

Baserow uses a simple token-based authentication. You need to generate at least one API token in your settings to use the endpoints. It is possible to give create, read, update and delete permissions up until table level per token. You can authenticate to the API by providing your API token in the HTTP authorization bearer token header. All API requests must be authenticated and made over HTTPS.

API token permissions

You can use API tokens to authenticate with the REST API endpoints where you can create, read, update and delete rows and configure permissions.

A message is broadcast to all users connected to the web socket in the linked group when a user makes a modification, such as when creating a new database application. When the data has changed, the previously fetched data is immediately updated. This makes sure the user is always working with the most recent data with no need to reload the website.

When sharing publicly, you must be cautious about setting the appropriate permissions. If you expose your token publicly, anyone with that token can create, read, update, and delete your data. If you accidentally expose your API Token to the public, visit the API token page as soon as possible to generate a new one.

Updating API permissions

It is possible to set permissions on the table level. The Database table rows endpoints can be used for these operations.

The permission toggles indicate per operation which permissions the API token has within the whole group. If the value of for example create is true, then the token can create rows in all tables related to the group.

If all tables in the group are checked, then the token creates permissions for all the tables in the database selected. The same applies if a database reference is provided.

enter image description here

View our OpenAPI specification.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!