Referring to the notion API, the value needs to be set to null to clear a property. Of course you cannot simply enter ‘null’ as this will be taken as a literal string and the property value will then literally be null rather than nothing as needed.
I am sorry to say it but now n8n does NOT support clearing date property, what I can suggest is set some weird date like year 2599 and then tract this date same as empty in filters.
Read more here: Notion clear date - #2 by RicardoE105
You can clear properties by leaving them empty. I just tested it with dates, and it worked fine. Make sure you are using version 2. To do that, add the node from the nodes menu instead of copying the node from another workflow/
If, as shown in the image above, you pass an empty value into a relation, it causes an error.
Note that this is necessary - the workflow I am building will not know in advance which properties will be needed to be added to the Notion Database page.
I suspect (although I could be incorrect, and there could be a way of preventing this) that when you hit Add Item, this creates an object for this database field in the POST request, and therefore, no entry causes an issue. Hopefully, there is a workaround, but if not, perhaps the notion node could be updated so that if there is nothing in the relation field (as above), then no object is generated?
So you got that without having the Meetings field in there at all? I wouldn’t have expected Notion to complain unless it is set as a required field but I am not sure if that is possible.
I take it notion allows you to manually add a record without including the ID as well?
It does work fine if you delete that field, but I guess that the point is for it to be filled variably based on the input and if it’s deleted altogether no dice.
Does that make sense?
For now I’ve just built a custom function w js in an http node.
Also a note to @jan Notion date in the http headers is currently out of date (they have a newer release for 22-06-28) which allows the get requests to pull more information
I have have had a play and I can see the issue now, So if you don’t have an input that is a uuid you want to send nothing in that field.
It looks like when we handle the relation field we do a split and that looks to be failing so maybe we just need an “empty” option.
As a workaround what I would do is just pop an If before it and if the incoming field is empty go to a second notion node that doesn’t have that field set or add it to a list to be manually checked and if it set populate like normal.
With the version header I will add it to the internal request list and next time we change something in the node we can take a look at changing it.
