Hi !
I’m trying to merge 2 databases into 1. The merge works perfectly fine but when I try to create the new one, I always have the same issue with empty value. The workflow runs until it finds an empty value.
" {
“id”:“123”,
“name”:“ABC”,
},
“property_item_category”:“New feature”,
“property_mailing”:false,"
“property_title”:“ABC”
}," → OK
" {
“id”:“345”,
“name”:“ABCDEF”,
},
“property_item_category”: null,
“property_mailing”:false,"
“property_title”:“ABCDEF”
}," **
** because of the “property_item_category” (in my opinion)
I tried to do add “{{$json[“property_item_category”] ? $json[“property_item_category”] :‘’}}” but I have the same issue.
Do you have any idea ?
“NodeApiError: UNKNOWN ERROR - check the detailed error for more information
at Object.notionApiRequest (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Notion/GenericFunctions.js:48:15)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Notion/v2/NotionV2.node.js:349:36)
at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:653:28)
at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:590:53”