🗃️ Using Baserow via Voltask
To use Baserow with Voltask, you need to go through the Baserow API and the httpRequest block
An API (Application Programming Interface) is a set of functionalities made available to a client/user via a library (methods of a programming language) or a web service.
To set up Baserow’s API, you must first obtain an access token that identifies who is using what (in this case, the “what” may refer to a single table, the entire database, or only certain tables).
To generate this token, log into Baserow and, after creating at least one database, go to account settings (by clicking the workspace name in the top left, then selecting Account). In the account settings, choose Database tokens, then assign permissions to the token (by default, all permissions—read, create, update, and delete—are allowed on all tables in the selected database).
Now that the token has been created, several actions are possible: read one or more rows from a table, create a row, update a row, delete a row.
These are the main actions, but it’s also possible to retrieve column names or move rows.
More info in the API documentation: https://baserow.io/api-docs
To read multiple rows from a table, configure the httpRequest block as follows:
the Method is GET
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/?user_field_names=true&size=25
Make sure to replace {{ tableID }} with the actual ID of the table to read, or use other blocks to achieve the same result (in this case, the line is ready to use in the format block).
To find a table ID, hover over its name and click the three dots: the ID appears at the top of the popup.
The &size=25 at the end of the URL means the request will return a maximum of 25 rows.
Warning: if the table ID does not match a table linked to the token, the request will fail.
the Header looks like {"Authorization":"Token {{ APIkey }}"}
Replace {{ APIkey }} with the access token obtained earlier, or use other blocks if needed (in this case, the line is ready to use in the format block). You can copy the token value by clicking the three dots next to the token name.
The only difference from the multiple-row version is the URL. If you only want to retrieve a single row, use: https://api.baserow.io/api/database/rows/table/{{tableID}}/{{rowNumber}}/?user_field_names=true
Again, replace {{ tableID }}, and {{ rowNumber }}, which is the row ID in the table.
To create a row in a table, configure the httpRequest block as follows:
the Method is POST
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/?user_field_names=true
the Header looks like {"Authorization":"Token {{ APIkey }}","Content-Type":"application/json"}
the Body is a JSON object where the keys are column names and the values are the values to insert.
Example: if a table has two columns "fruits" and "vegetables", the JSON object would be: {"fruits": "apple", "vegetables": "carrot"}
JSON (JavaScript Object Notation) is a textual data format used for data transmission. A JSON object is a string (text) that contains the data to be transmitted. These objects are enclosed in braces, and associate a key with a value (text, list, number, boolean value, or another JSON object), separated by colons (for example: {"fruits": ["apple", "banana"], "number": 2, "likes": true})
To update a row in a table, configure the httpRequest block as follows:
the Method is PATCH
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/{{rowNumber}}/?user_field_names=true
the Header looks like {"Authorization":"Token {{ APIkey }}","Content-Type":"application/json"}
the Body is a JSON object where the keys are column names and the values are the new data to insert.
To delete a row from a table, configure the httpRequest block as follows:
the Method is DELETE
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/{{rowNumber}}/
the Header looks like {"Authorization":"Token {{ APIkey }}","Content-Type":"application/json"}
An API (Application Programming Interface) is a set of functionalities made available to a client/user via a library (methods of a programming language) or a web service.
API Key
To set up Baserow’s API, you must first obtain an access token that identifies who is using what (in this case, the “what” may refer to a single table, the entire database, or only certain tables).
To generate this token, log into Baserow and, after creating at least one database, go to account settings (by clicking the workspace name in the top left, then selecting Account). In the account settings, choose Database tokens, then assign permissions to the token (by default, all permissions—read, create, update, and delete—are allowed on all tables in the selected database).
Requests
Now that the token has been created, several actions are possible: read one or more rows from a table, create a row, update a row, delete a row.
These are the main actions, but it’s also possible to retrieve column names or move rows.
More info in the API documentation: https://baserow.io/api-docs
Reading
Multiple rows
To read multiple rows from a table, configure the httpRequest block as follows:
the Method is GET
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/?user_field_names=true&size=25
Make sure to replace {{ tableID }} with the actual ID of the table to read, or use other blocks to achieve the same result (in this case, the line is ready to use in the format block).
To find a table ID, hover over its name and click the three dots: the ID appears at the top of the popup.
The &size=25 at the end of the URL means the request will return a maximum of 25 rows.
Warning: if the table ID does not match a table linked to the token, the request will fail.
the Header looks like {"Authorization":"Token {{ APIkey }}"}
Replace {{ APIkey }} with the access token obtained earlier, or use other blocks if needed (in this case, the line is ready to use in the format block). You can copy the token value by clicking the three dots next to the token name.
Single row
The only difference from the multiple-row version is the URL. If you only want to retrieve a single row, use: https://api.baserow.io/api/database/rows/table/{{tableID}}/{{rowNumber}}/?user_field_names=true
Again, replace {{ tableID }}, and {{ rowNumber }}, which is the row ID in the table.
Creation
To create a row in a table, configure the httpRequest block as follows:
the Method is POST
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/?user_field_names=true
the Header looks like {"Authorization":"Token {{ APIkey }}","Content-Type":"application/json"}
the Body is a JSON object where the keys are column names and the values are the values to insert.
Example: if a table has two columns "fruits" and "vegetables", the JSON object would be: {"fruits": "apple", "vegetables": "carrot"}
JSON (JavaScript Object Notation) is a textual data format used for data transmission. A JSON object is a string (text) that contains the data to be transmitted. These objects are enclosed in braces, and associate a key with a value (text, list, number, boolean value, or another JSON object), separated by colons (for example: {"fruits": ["apple", "banana"], "number": 2, "likes": true})
Update
To update a row in a table, configure the httpRequest block as follows:
the Method is PATCH
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/{{rowNumber}}/?user_field_names=true
the Header looks like {"Authorization":"Token {{ APIkey }}","Content-Type":"application/json"}
the Body is a JSON object where the keys are column names and the values are the new data to insert.
Deletion
To delete a row from a table, configure the httpRequest block as follows:
the Method is DELETE
the URL is something like https://api.baserow.io/api/database/rows/table/{{tableID}}/{{rowNumber}}/
the Header looks like {"Authorization":"Token {{ APIkey }}","Content-Type":"application/json"}
Updated on: 16/05/2025
Thank you!