Help

Re: Where to add: "typecast": true (when column type is checkbox)?

3154 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dev_Local
6 - Interface Innovator
6 - Interface Innovator

I changed a column in Airtable from text to a checkbox (I am filling in with TRUE/FALSE (all caps)).

Now I get this when I try to insert:

  data: {
    error: {
      type: 'INVALID_VALUE_FOR_COLUMN',
      message: 'Field "Active" cannot accept the provided value'
    }
  }

I have seen articles saying to add:

"typecast": true

but this does not work. I’m not sure that I’m adding after the right curly bracket, as none of the articles I read are explicit on this, other than ‘add “typecase”: true’ somewhere.

I don’t know whether to add it after each fields entry like so, or somewhere else?

 {
   "fields": 
	{
		"key": "value",
		"key": "value"
	}, "typecast": true
 },

It is obviously being added in the wrong place, I am getting:

  data: {
    error: {
      type: 'INVALID_REQUEST_BODY',
      message: 'Could not parse request body'
    }

Is there an example JSON that anyone can share that has been successfully used here?

10 Replies 10
msafi04
5 - Automation Enthusiast
5 - Automation Enthusiast

“typecast”: true after the records worked for me!