[Notion] Relation field only shows 20 options

[cfron]

Extension

https://www.raycast.com/notion/notion

Description

I'm using the Create Database Page command and my database (Watch Events) has a Relation field (Movies). The Movies database (also connected to Raycast) has several hundred entries, but only 20 of them (I think the most recently edited?) are appearing in the Watch Events page Relation dropdown menu.

Steps To Reproduce

1. Have a Notion database with more than 20 entries.
2. Use it as a Relation field for another database.
3. Run the Create Database Page command in Raycast for the second database.

Current Behaviour

No response

Expected Behaviour

No response

[raycastbot]

Thank you for opening this issue!

🔔 @HenriChabrand @mathieudutour @metakirby5 @thomaslombart @erics118 @bkeys818 @AlexIsMaking @Yakitrak @tleo19 you might want to have a look.

💡 Author and Contributors commands

The author and contributors of `notion/notion` can trigger bot actions by commenting: - `@raycastbot close this issue` Closes the issue. - `@raycastbot rename this issue to "Awesome new title"` Renames the issue. - `@raycastbot reopen this issue` Reopen the issue.

[dariuszpaluch]

Yup, it's limit of https://developers.notion.com/reference/retrieve-a-database which we used to fetch database properties. We need to add pagination fetch for relation field and get all of pages with https://developers.notion.com/reference/post-database-query

[raycastbot]

This issue has been automatically marked as stale because it did not have any recent activity.

It will be closed if no further activity occurs in the next 10 days to keep our backlog clean 😊

[raycastbot]

This issue has been automatically closed due to inactivity.

Feel free to comment in the thread when you're ready to continue working on it 🙂

You can also catch us in Slack if you want to discuss this.