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?
+14
Hi
Please link to the Notion API endpoint documentation you used to create the Zap action step for us to have more context, thanks.
Hi
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
+14
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.
+14
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:
+14
Try removing the Notion-Version header but keeping the Content-Type header
Try removing the Notion-Version header but keeping the Content-Type header
Got the same output
+14
You could try using the Custom Action instead of the API Request for Notion.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
