Notion node - get (many) database page - error if 'Status' property is not filled out

Questions
1

Describe the problem/error/question

When using the Notion ‘Get Many Database Pages’ (or single Page) node on a Database that contains the new(?) ‘Status property’ which is left empty in Notion, an error is returned. It immediately works once the respective page (or all pages in the Get Many scenario) have the Status column filled out. See pictures below. It seems there is an issue in parsing the null element within n8n?

What is the error message (if any)?

ERROR: Cannot read properties of null (reading ‘name’)

Please share your workflow

Information on your n8n setup

  • n8n version: 1.31.2.
  • Database (default: SQLite): Postgres (I think)
  • Running n8n via: Docker (via Coolify)
  • Operating system: Linux

status_not_selected
status_not_selected2545×1279 143 KB

status_selected2
status_selected22513×1215 109 KB

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @peter_brueck,

yes, handling null or empty values in Notion nodes can be a bit tricky. We have identified some work-arounds for this in the past.

Check out the following forum posts and see if they can solve your problem as well :slight_smile:

Do let us know how you get on!

2 Likes