Notion Integration Issue - invalid mulit select | Community
Skip to main content
Answered

Notion Integration Issue - invalid mulit select

L
  • LPS
  • Explorer
  • 2 replies

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

Best answer by LPS

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!

View original

4 replies

john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5275 replies
  • July 29, 2021

@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
  • LPS
  • Author
  • Explorer
  • 2 replies
  • July 29, 2021

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

L
  • LPS
  • Author
  • Explorer
  • 2 replies
  • Answer
  • July 29, 2021

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!

john.desborough
1 person likes this
  • john.desborough
    john.desborough
Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14919 replies
  • August 2, 2021

Thanks for sharing this, @LPS ! Super helpful.

Life is a series of awkward moments separated by snacks.
john.desborough
1 person likes this
  • john.desborough
    john.desborough

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs