Number field in notion database is throwing errors when creating an item from Salesforce

How To
1

Hi All,

Screenshot 2022-10-05 at 12.46.52
Screenshot 2022-10-05 at 12.46.523266×1132 371 KB

I’m having some trouble with a Salesforce to Notion integration.

Description of flow: Every time there’s an update to an account in Salesforce a notion database is updated. Whenever a new account is made in salesforce it is created in notion.

What’s going wrong: When the flow creates a new database item, I get this error * [400] Tier is expected to be number.. The tier property is a number in the notion database. Not sure how to fix this as Salesforce is returning a “number,” 3 in this case. I tried converting the string from Salesforce to a number but had no luck.

Anyone come across this and know how to fix it?

2

Try to use the parseNumber() function in your Notion module and see if that fixes it.

Screenshot 2022-10-06 at 14.23.25
Screenshot 2022-10-06 at 14.23.25854×575 63.3 KB

1 Like
3

Cool will give that a go. Is it weird that it throws this error only when creating an item and not when updating it

4

Did it work out @nandan ?

5

Hey
Nope no luck
get this error

“The operation failed with an error. [400] body failed validation. Fix one: body.properties.Tier.select.id should be defined, instead was undefined. body.properties.Tier.select.name should be a string, instead was 2.”

Pretty weird as when I set it to text using to string I get the error below:
“The operation failed with an error. [400] Tier is expected to be number.”