I am experiencing difficulties when trying to fetch records from my Notion database in the same order as set by the drag-and-drop interface. I have reviewed the official documentation and scoured various online resources, but I still haven’t found a solution that preserves this custom order. I’m seeking advice on how to query the database in such a way that the returned data maintains the sequence arranged in the Notion UI.
i not figured this out yet. maybe try checking for a hidden sort property or fallback to custom reusable mapping for your entries order. might be a current api limiation
I encountered a similar issue when I began using the Notion API. It appears that the order seen in the UI is not something that the API automatically respects. From my experience, a practical workaround was to add an explicit property that holds a numeric order or timestamp which reflects the drag-and-drop position. This allows for a client-side sort after retrieval. Although it isn’t an ideal solution, it is the only way to ensure that the sequence aligns with the one you see in Notion’s interface currently.