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

Hi All,

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?

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

1 Like

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

Did it work out @nandan ?

Nope no luck
get this error

“The operation failed with an error. [400] body failed validation. Fix one: should be defined, instead was undefined. 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.”