Body Failed Validation Error for date field — Not making any sense

[brienneot]

I suddenly started getting errors today for my workflow between Google Sheets and Notion.

The simple workflow works like this:

• When new row is added to Google Sheets → Add new row to Notion.

This workflow was built about two months ago, and while there have been various annoying problems, the field mapping between Google Sheets and Notion was fairly stable, until today, when suddenly my date field “Next Interview” is getting this annoying error.

"\"body failed validation: body.properties.Next Interview.date.start should be defined, instead was undefined.\""

I have never required this field to be filled in order for the workflow to run so I don’t understand why this is suddenly happening. Would appreciate any help I can get.

–
FYI, this field uses ISO 8601 formatting in both Google Sheets and Notion, in case it matters.

Update: I ended up removing the field mapping for “Next Interview” but I’m still getting the same error! Even though I’m not even asking them to transfer the data for this field, they are giving me this same error!

[GunnerJnr]

Hi @brienneot,

Check the format of your Date/Time being passed. It could be that Notion has perhaps updated the format expected in the database.

I just did a basic test. In a Google Sheet, I added today’s date.

Note: I manually selected the format to make sure the date was in the proper date format.

I then used a Format Date step in AP to covert the date to the required format Notion expected for the database:

Then, finally, send the result of the formatted date to the Notion database:

Extra Note: Please be mindful that the Notion database has some settings for date/time that you can refine. You may need to adjust these to match the format you are passing over.

Hope this helps.

P.S - Just remember, you can check your JSON payload and follow the error path to see what it is looking at currently:

Mine will look a little different from yours. As you can see, I named my Notion database 'date,' so yours will likely have 'Next Interview' instead. But this can be helpful for debugging when hitting errors in the testing steps.