How to get all elements of a Notion database when there are more than 100 elements

I need to get all the elements of a Notion database (~2000) but the Notion API has a limit at 100 / call. Is it possible to go over this limit and fetch all the elements with one API call? If not, pagination seems to be the way but do to implement it with Make?

Welcome to the Make community!

Since the max limit is 100, you’ll need to repeat the query with the “next_cursor”
variable until the “has_more” property is false.

Screenshot_2024-08-14_120826

Hope this helps! Let me know if there are any further questions or issues.

— @samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

1 Like