AI Field Auto generation

Technical Help
1

I am trying to use Make to make an API call to automatically generate AI fields, and I am using this endpoint url: https://api.baserow.io/api/database/fields/{field_id}/generate-ai-field-values/

But I seem to be having issues with authentication. I’ve tried using both database token and JWT but I keep getting “authentication credential not provided”.

Please I need some guidance here.

1 Like
2

Hi @Steve223,

this endpoint expects a valid JWT to be passed in. Are you able to call other endpoints with JWT? How do you pass the token?

1 Like
3

Hello Baserow support Team,
Please, I have the same requirement? How to use API to generate the AI insights?
I’m getting same error as petrs {“detail”:“Authentication credentials were not provided.”}.

Could you let us know how to run it as its pratically impossible to click on generate button for each single record and not recommended for the full column as well. Therefore API is the best option and we can see API works. Could you share how to use it?

Thank you and Regards,
Marcio

4

Hi @FoxME,

You should use this endpoint: generate_table_ai_field_value.

It doesn’t seem to have properly documented the request, but it is just a list of row ids in a format like this: {"row_ids":[1,2]} where 1 and 2 would be the row ids to generate values for.

1 Like
5

Hello Petrs, Excellent, Thank you so much, and you are indeed correct. The use of generate ai via API for automation is not well documented, therefore follow the steps I have followed to support community and also request an enhanced feature here:

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.

:one: 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"}”

:pushpin: Example Response (JSON):

{
“token”: “eyJhbGciOiJIUz…”,
“access_token”: “eyJhbGciOiJIUz…”,
“refresh_token”: “eyJhbGciOiJIUz…”,
“user”: {
“first_name”: “John”,
“username”: “your@email.com”
}
}

:rocket: Important:
The value you need is access_token, not token. Copy the access_token and use it in the next steps.

:two: 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:

  1. Go to Baserow Admin Panel → Settings.
  2. Find the Generative AI Settings section.
  3. Update the Host and Model as needed.

:three: 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]}”

:pushpin: 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.

:rocket: 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.

:four: Important Notes

:white_check_mark: Baserow AI Field Generation Works Automatically!
Once executed, the AI field will auto-populate in the row.

:warning: 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.

:rocket: Feature Request for Baserow Support Team

:small_blue_diamond: Request: Implement a feature allowing AI field generation using a Database Token instead of an Access Token.
:small_blue_diamond: Why? The current limitation requiring a new access token for each execution hinders automation and integrations.
:small_blue_diamond: Community Demand: This request has been raised since 2023, and with the rise of AI automation in 2025, this is a critical missing feature.

:loudspeaker: 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. :raised_hands:

Thank you and Baserow Team. Looking forward to hear more on this.
FoxME

1 Like