How to resolve "Create a Notion Database Item" errors?

How To
,
1

Hi Make Team/Community,

Would greatly appreciate some help with this Notion Module.

Goal: Send data from Airtable to Notion database

Issue: Works 70% of the time. 30% of the times i get one of the following errors.

  1. Missing value for required parameter
  2. Invalid email address in parameter Ueqn

Below are some snapshots of error message.
Also, a link to the module.

May 13, 2024 1:27 PM Recording
Watch Video

Screenshot 2024-05-13 at 1.21.22 PM
Screenshot 2024-05-13 at 1.21.00 PM

Screenshot 2024-05-13 at 1.32.43 PM
Screenshot 2024-05-13 at 1.32.43 PM1636×174 27.8 KB

2

Hello Dave,

  1. The error “Missing value of required parameter ‘title’” means that the “Company” Notion property doesn’t receive any value from the mapped Airtable field “Company Name”. Since the title is required, the API outputs this error.
    Could it be that sometimes the Airtable data processed by the scenario have empty Company names? If so, you may use the ifempty() function to use a different value from the Airtable module when the company name is empty.

  2. “Invalid email address in parameter Ueqn” means that an email address you are mapping from Airtable into a Notion property of email type is invalid (for example, it may contain commas or other characters that don’t make the value purely be an email address). Is this possible? If so and you can’t fix the issue at the source, one option is to implement an error handler for this case in your scenario

2 Likes