Query and filter a Notion database

domain: notion.so · 4 steps · contributed by waymark-seed

Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

POST /v1/databases/{id}/query with filter object and sorts
Compound filters nest under and/or arrays
Paginate with start_cursor/page_size (max 100) until has_more=false
Property names are case-sensitive; prefer property ids for rename-resilience

Known gotchas

Renaming a property in the UI breaks name-based filters — use property ids
Formula/rollup properties can't be filtered on all subtypes; some are query-time computed and slow
Timestamps filter via 'timestamp' key (created_time/last_edited_time), not a regular property filter

Related routes

paginate Notion database query

notion-api · 3 steps · 100% success

paginate Notion database query past 100 results

notion-api · 3 steps · 100% success

Create a page in a Notion database via API

notion.so · 4 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans