Node API: Multiselect new option

I have a need to insert new select option into field but when i try to do it with node api i get.

Class {
  error: 'INVALID_MULTIPLE_CHOICE_OPTIONS',
  message: 'Insufficient permissions to create new select options',
  statusCode: 422 }

I have admin permissions. Is there a way to insert array of new options into Multi select field ?

1 Like

Hi Uros, I see this is your first post so welcome.
The API does not currently support creation of tables and fields.
These will have to be set up via the UI interface and the API is for retrieving and updating the information that is already there.

Also as a side note any questions related to API you can put in the API category of the forum.

Chinara,

How is it possible that, when creating a new record with Zapier, the creation of a new option in a single select is done?

1 Like

We have this need as well. We have an automated process to sync records to Airtable from our database via the API. We have to track down the new value when an error occurs during a sync then have to manually add it to the multi-select field. It would be super nice if it could be done via the API automatically instead.

Edit: It’s also made worse by the fact that the error message is generic, thus we don’t know the offending column either.

2 Likes

Ok, I thought the original person was asking to create a new multiselect field but you want to add options to an existing multiselect field. Theoretically I think this should be possible by supplying the array of options via the API but I have not tested this myself.

Also in what way are you adding the option? During the create record operation or update record operation?

I’m trying during the create record. I want to add a new option to an existing single select field. It throws an error but somehow this can be done with zapier.

Ok I have tested your use case and you can’t add the option on either the create or update methods. I have never used Zapier integrations with airtable but perhaps they have a relationship with Airtable that allows them to do this. You will probably have to reach out to the Airtable team to ask what’s up.

A possible workaround, I don’t know you how your database is designed, is to have the options in a separate table and link that record. That way you can use the create and update methods on that table.

For example think about a users table and roles table. A user can have roles of Admin, Editor, Subscriber. These can be store in a separate table.