How to Use Baserow’s Generate AI Field Feature in the Hosted Premium Version
This guide will walk you through the entire process of generating AI field values in Baserow using the API.
Obtain an Access Token
Baserow requires an access token to authenticate API requests. You can obtain it using the following command (in may case I’m using Windows command prompt):
curl -X POST “https://mybaserowdomain.com/api/user/token-auth/” -H “Content-Type: application/json” --data “{“email":"your@email.com”,“password”:“YourSecurePassword”}”
Example Response (JSON):
{
“token”: “eyJhbGciOiJIUz…”,
“access_token”: “eyJhbGciOiJIUz…”,
“refresh_token”: “eyJhbGciOiJIUz…”,
“user”: {
“first_name”: “John”,
“username”: “your@email.com”
}
}
Important:
The value you need is access_token
, not token
. Copy the access_token
and use it in the next steps.
Configure Generative AI Settings in Baserow
Before using AI field generation, ensure that Generative AI settings are configured in Baserow:
- Host:
http://192.168.0.99:11434
(or localhost, the Example for a local Ollama setup, in my case) - Enabled Models:
gemma2:27b
(Adjust based on your AI model)
To check or modify your settings:
- Go to Baserow Admin Panel → Settings.
- Find the Generative AI Settings section.
- Update the Host and Model as needed.
Generate AI Field Values for Specific Row IDs
Once you have your access token, you can run the following command to generate AI field values for specific rows in a given field.
curl -X POST “https://mybaserowdomain.com/api/database/fields/7283/generate-ai-field-values/” -H “Authorization: JWT YOUR_ACCESS_TOKEN_HERE” -H “Content-Type: application/json” --data “{“row_ids”:[46757,46759]}”
Example:
curl -X POST “https://mybaserowdomain.com/api/database/fields/7283/generate-ai-field-values/” -H “Authorization: JWT eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiZXhwIjoxNzM5MzU4ODk0LCJpYXQiOjE3MzkzNTgyOTQsImp0aSI6ImVmNzc3NzA4MTFhZjRmYjQ4MjY3ZmZkNDEwMWZiODUwIiwidXNlcl9pZCI6MX0.4ARlFX8nnhq-fLlYRiWsFLR5jCHVHy9CrxtHrvIA3C4” -H “Content-Type: application/json” --data “{“row_ids”:[46757,46759]}”
Breakdown of Parameters:
7283
→ Replace with the actual Field ID where the AI-generated values should be inserted.row_ids
→ List of rows where AI generation should be applied.
Expected Outcome:
- If everything is set correctly, Baserow will automatically generate AI responses for the specified field.
- The values will be populated based on the AI prompt you configured in Baserow.
Important Notes
Baserow AI Field Generation Works Automatically!
Once executed, the AI field will auto-populate in the row.
Access Token is Valid for ONE Execution Only!
Every new execution requires a new access token. You need to repeat Step 1 before every request.
Feature Request for Baserow Support Team
Request: Implement a feature allowing AI field generation using a Database Token instead of an Access Token.
Why? The current limitation requiring a new access token for each execution hinders automation and integrations.
Community Demand: This request has been raised since 2023, and with the rise of AI automation in 2025, this is a critical missing feature.
Message to the Baserow Team:
Baserow is absolutely sensational, and this feature would elevate its AI capabilities to the next level! Please prioritize this improvement.
Thank you and Baserow Team. Looking forward to hear more on this.
FoxME