Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi,

i’m trying to run a zap step that allows me to retrieve from a database only items that match a condition (specifically, have been modifyed within this week).

Here’s the screenshot of my setup:

 

The problem is that my request retrieves the whole database. I tried with every type of filter it still returns the whole thing.

What’s wrong?

Hi @mc_vento 

Please link to the Notion API endpoint documentation you used to create the Zap action step for us to have more context, thanks.

Hi @mc_vento 

Please link to the Notion API endpoint documentation you used to create the Zap action step for us to have more context, thanks.

Database Query Endpoint: https://developers.notion.com/reference/post-database-query

Filters Database Entries: https://developers.notion.com/reference/post-database-query-filter

@mc_vento

Make sure you have the correct Headers set.

 

If “past_week” is not working, then perhaps try using a different condition.

https://developers.notion.com/reference/post-database-query-filter#date

 

 

The integration allows to avoid filling the headers, they are filled automatically.

I discovered something though, trying to insert the headers. 

This was the outcome after inserting the Notion-Version header:

“Notion-Version header failed validation: Notion-Version header should be `"2021-05-11"`, `"2021-05-13"`, `"2021-08-16"`, `"2022-02-22"`, or `"2022-06-28"`, instead was `"2022-06-28, 2021-08-16"`.”

So, the version in use is the 2021-08-16. Could this be the problem why filters doesn’t goes through?

The integration allows to avoid filling the headers, they are filled automatically.

I discovered something though, trying to insert the headers. 

This was the outcome after inserting the Notion-Version header:

“Notion-Version header failed validation: Notion-Version header should be `"2021-05-11"`, `"2021-05-13"`, `"2021-08-16"`, `"2022-02-22"`, or `"2022-06-28"`, instead was `"2022-06-28, 2021-08-16"`.”

So, the version in use is the 2021-08-16. Could this be the problem why filters doesn’t goes through?

Also, i already tried most of the filters so i guess the problem doesn’t lie there.

@mc_vento 

Often, you may still need to set additional Headers, especially for non-GET requests.

Can you post screenshots with how your Headers are set?

 

What i was tell is that adding the headers blows the request up.

Here’s the screenshot:

 

@mc_vento 

Try removing the Notion-Version header but keeping the Content-Type header

 

@mc_vento

Try removing the Notion-Version header but keeping the Content-Type header

 

 

Got the same output

 

@mc_vento 

You could try using the Custom Action instead of the API Request for Notion.

 

Terms & Conditions