API-Limitations with Multiple Select Field in Self-Hosted Baserow

Technical Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

I am running Baserow version 1.30.1.

If you are self-hosting, which installation method do you use to run Baserow?

Docker from baserow/baserow:latest

What are the exact steps to reproduce this issue?

  1. I set up a Multiple Select field in Baserow to store keywords. Currently, this field contains about 8,500 entries.
  2. Using N8N, I attempt to add new rows with values for this Multiple Select field.
  3. In N8N, I receive an error indicating that the API does not allow adding new items to the Multiple Select field unless they already exist within the predefined selection.

Questions I’m trying to resolve:
Can I use the API to add new items to a Multiple Select field if they are not already present?
Is there a maximum limit to the number of items allowed in a Multiple Select field?

2

Hello @maik

You can create options for fields using api endpoints that require JWT token.
Here are steps for that:

  1. Get your auth token from api like:
curl -X POST -H "Content-Type: application/json" -d '{"username": "<YOUR_EMAIL>", "password": "<YOUR_PASSWORD>"}' http://<ENDPOINT>/api/user/token-auth/
  1. Once you get token use it to get data for your field:
curl -X GET -H "Authorization: JWT <TOKEN>" http://<ENDPOINT>/api/database/fields/<FIELD_ID>/
  1. Use endpoint to set values for multiple option field. Note that you need to pass all of them at once (those not listed in this request will be removed)
curl -X PATCH \
  -H "Authorization: JWT <TOKEN>" \
  -H "Content-Type: application/json" \
  -d '{
    "select_options": [
      {"id": 1, "value": "Existing Option 1", "color": "blue"},
      {"id": 2, "value": "Existing Option 2", "color": "green"},
      {"value": "New Option", "color": "red"}
    ]
  }' \
  http://<ENDPOINT>/api/database/fields/<FIELD_ID>/
3

Ah I understand, thank you, that worked right away