I’m using the Notion module in Make.com (formerly Integromat), specifically the “Get database item” module, but it only retrieves 25 items max per execution. I noticed there’s no pagination or start cursor field available in this module like in the Notion API, so I’m stuck when trying to process more than 25 records.
I’ve also tried workarounds such as iterators or text aggregators, but they don’t solve the root issue of fetching more than 25 items from a database in one go.
Is there a way to retrieve more than 25 items?
Should I be using the HTTP module instead to call the Notion API directly with pagination?
If so, can someone share a working setup or guidance for the HTTP request (including handling pagination)?
Any help or example scenarios would be greatly appreciated.
Hi Karim - normally the “Get database item” retrieves only 1 item (based on its ID). To retrieve more items, you can use the “Search objects” module, which doesn’t have any limit or pagination. Let me know if this helps or any other questions
Thanks Simo for your feedback but I just observed that the watch database items module is my concern because I observed that when a database table contains relation and as you know that relation property is similar like multi selection but you will select pages. As the number of selected pages exceeds 25 the output of the watch property stated 25. please see the photos. my automation is working fine below 25 selections.
Ah, I see - indeed, there is a 25-page limit in Relation properties when retrieving a page via the API. The solution is to use a different endpoint that allows paginating through the items. Below are resources that can help you:
