Answered

Notion Integration Issue - invalid mulit select

  • 28 July 2021
  • 4 replies
  • 267 views
L

In webhooks, I’m getting:

status": 400,    "code": "validation_error",    "message": "iAjJ has an invalid multi_select value. VaGD has an invalid multi_select value. wyGe has an invalid multi_select value."

I can’t identify which value is invalid for whatever reason. The identifiers, like iAjJ don’t seem to correspond to anything in the Request code. (Btw, I reduced the max characters to under 100 for each answer, which sorted an earlier error, just in case someone runs into that error.) My answers do still have commas in some of them but will look terrible if I have to remove them. Oh wait… I wonder if the issue is that Notion doesn’t support commas? I just noticed that my pasted answers in Notion are missing the commas. Anyone?

Many thanks,

Lucien

icon

Best answer by LPS 29 July 2021, 07:25

View original

4 replies

john.desborough
Userlevel 7
Badge +6

@LPS - check out this thread where it talks about the comma error in Notion

 

 

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
L

@john.desborough Ah, cool, thanks. That kills off Notion as a CRM for me then. Will take a look at Pipedrive. Thanks again :)

L

And this just in from Notion:

Thanks for writing in. I just created a Typeform, and when I tested the multi-select values using a multiple choice question in the form, only the values that did not contain a comma made it through. I am not sure about how Typeform is parsing strings in their API. They would be best to address how they are processing the values in their integration. Based on the quick test, however, it looks like you are correct.

The Notion API does strip the commas from the multi-select value. For example, if you send the following to populate multi-select columns, the commas would be removed from the tags listed:

"multiselect_tags": {

"type": "multi_select",

"multi_select":[ {

"name": "Duc Loi Market,"

},

{

"name": "Rainbow Grocery,,,"

}

]

}

}

Ultimately, the values "Duc Loi Market" and "Rainbow Grocery" would populate into the database entry. It would not cause the record to fail.

I hope this helps.

Cheers!

Liz
Rank
Userlevel 7
Badge +5

Thanks for sharing this, @LPS ! Super helpful.

Life is a series of awkward moments separated by snacks.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs