Skip to main content
Best answer

Error: Failed to create a database item in Notion, path failed validation

  • December 11, 2022
  • 4 replies
  • 539 views

I am trying to update a notion database entry to done based on marking a task in tick tick as complete. I use tick tick as a quick capture tool and the bulk of my tasks are managed in notion. I get a uuid error though.

 

 

 

Best answer by christina.d

Hey there, @Scarbz!

It looks like you were able to reach my friends in support and I wanted to share a bit of they shared in case it’s helpful to anyone following along.

Spoiler: Troy nailed it. 🙂 

...it seems the issue comes from the value mapped in the Item field of the Update Database in Notion step. The Item field requires an ID. However, a human-readable text is being sent instead.



To add more context, whenever you see fields with a double-headed arrow on the right in the Zap editor, the connected app requires a specific ID value. When you click on each field, we will make a call to that app to ask them what values they expect. This will be shown in the drop-down menu that appears.


 

This ID value is required for the app to correctly parse the data. However, this dropdown field is static. If you'd like to dynamically update an item within Notion's database, you'd want to add 1 more step in your Zap, the Find Database Item in Notion, before the Update Database Item step.
 
The result of the Find step will return an ID that you can map in the Item field, so it dynamically updates every time the Zap runs.

Hope this helps!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34001 replies
  • December 11, 2022

Hi @Scarbz 

Good question.

The Page field expects the internal Notion Page ID, not the Notion Page Name.

Similar to the Database value shown in the screenshot.

 

You can use this Zap action: Notion - Find Page (By Title)

 


  • Author
  • New
  • 1 reply
  • December 12, 2022

Thanks Troy. I tried adding a search step but still got blocked. What do I add for Title here? I tried the task name and I tried using a taskID that Tick Tick generates (which I included in the notion database from my previous add to notion zap)

 

If I were to use say TaskName in the Title input box, I get this error when I do a test. I can see the notion database item added from my previous zap so the data is in notion.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34001 replies
  • December 12, 2022

@Scarbz 

If you are using the action Notion Find Page (by Title), then it expects the title of the page.

 

If you are searching for a Notion Item on a page, then you can use this action: Notion - Find Database Item

 


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • Answer
  • December 16, 2022

Hey there, @Scarbz!

It looks like you were able to reach my friends in support and I wanted to share a bit of they shared in case it’s helpful to anyone following along.

Spoiler: Troy nailed it. 🙂 

...it seems the issue comes from the value mapped in the Item field of the Update Database in Notion step. The Item field requires an ID. However, a human-readable text is being sent instead.



To add more context, whenever you see fields with a double-headed arrow on the right in the Zap editor, the connected app requires a specific ID value. When you click on each field, we will make a call to that app to ask them what values they expect. This will be shown in the drop-down menu that appears.


 

This ID value is required for the app to correctly parse the data. However, this dropdown field is static. If you'd like to dynamically update an item within Notion's database, you'd want to add 1 more step in your Zap, the Find Database Item in Notion, before the Update Database Item step.
 
The result of the Find step will return an ID that you can map in the Item field, so it dynamically updates every time the Zap runs.

Hope this helps!