I am using Fivetran’s connector for Notion and have encountered an issue where the blocks on a page are not maintained in the correct order as provided by Notion’s API. This order is essential for recreating content, as headings and paragraphs need to be in sequence.

Details:

• Notion API Reference : Notion’s API provides blocks in a specific order: Get Block Children.
• Issue : The current Fivetran connector does not preserve this order, resulting in headings being separate from paragraphs and other elements.
• Evidence :
  • Libraries creating markdown from Notion assume this inherent order (Example Code).
  • Documentation for the connector highlights a lack of order retention (Fivetran Notion Connector Docs).

Request:

To address this, I suggest adding an order column to the "block_page" table. This column would capture the order in which blocks are provided by the Notion API, ensuring the data reflects the true structure and sequence of the content.

Implementing this enhancement will significantly improve data usability by preserving the natural order of blocks as designed in Notion.