Notion's API Now Caps Pagination at 10,000 Results — Your 'Fetch All Rows' Sync Is Silently Truncating

Short summary

Notion's paginated API now silently caps results at 10,000 items without errors; sync integrations miss the new request_status field indicating truncation, causing incomplete datasets in warehouses and dashboards. Check request_status.type === 'incomplete' on every paginated response and either fail loudly or re-architect with more selective filters. Affects all database-to-warehouse syncs, exports, and integrations querying >10k rows.

• •Notion API enforces 10,000-result pagination cap with silent truncation (200 OK response)
• •Existing code ignores new request_status field, leading to quietly incomplete data
• •Fix: explicitly check for request_status.type === 'incomplete' and throw or re-partition queries

Generated with AI, which can make mistakes.