Unable to Update Notion Database

Questions
1

Describe the problem/error/question

Hi guys. I’m new to n8n. I’m trying to automate the views field in my Notion database by querying Youtube based on the Youtube video ID. I am able to correctly identify the videos in my Notion database and also able to get the relevant stats per video from Youtube. I seem to be getting stuck updating the Notion database with the stats received from Youtube.

It seems it works when I manually input the data as fixed, but when I try and use an expression {{ $json.statistics.viewCount }} it gives that error.

What is the error message (if any)?

When I try and update the Notion database I get the following error:

ERROR: Bad request - please check your parameters

400 - {“object”:“error”,“status”:400,“code”:“validation_error”,“message”:"body failed validation. Fix one:\nbody.properties.Views.title should be defined, instead was undefined.\nbody.properties.Views.rich_text should be defined, instead was undefined.\nbody.properties.Views.number should be a number or null, instead was \"2470\".\nbody.properties.Views.url should be defined, instead was undefined.\nbody.properties.Views.select should be defined, instead was undefined.\nbody.properties.Views.multi_select should be defined, instead was undefined.\nbody.properties.Views.people should be defined, instead was undefined.\nbody.properties.Views.email should be defined, instead was undefined.\nbody.properties.Views.phone_number should be defined, instead was undefined.\nbody.properties.Views.date should be defined, instead was undefined.\nbody.properties.Views.checkbox should be defined, instead was undefined.\nbody.properties.Views.relation should be defined, instead was undefined.\nbody.properties.Views.files should be defined, instead was undefined.\nbody.properties.Views.status should be defined, instead was undefined.\nbody.properties.Views.id should be defined, instead was undefined.\nbody.properties.Views.name should be defined, instead was undefined.\nbody.properties.Views.start should be defined, instead was

Information on your n8n setup

  • **n8n version: 1.29.1
  • **Database (default: SQLite): SQLite
  • **n8n EXECUTIONS_PROCESS setting (default: own, main): Default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • **Operating system: Windows
2

I managed to find a workaround. I created an HTTP Request node to update Notion which is working. For some reason updating using the Notion node with an expression isn’t working.

2 Likes
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.