Creating a pagination variable

How To
,
1

CONTEXT
I’d like to create a make scenario where I’m pulling data from an API (CRM) and adding it to a google sheet. The pagination is page-based. (I pass the page variable as a parameter)

ISSUE
In the payload, there is no “total_pages” variable. All I have to work with is the following:
totalResults
resultsPerPage (capped at 25)

To get a “total_pages” variable I’d do something like “totalResults”/“resultsPerPage”

How do I get this to work? Is what I suggested the best approach?

Thanks!
Dimitri

2

Welcome to the Make community!

You got the right idea. You’ll just need to use the built-in function ceil to round up the number of pages.

e.g.:

{{ ceil( 1.totalResults / 1.resultsPerPage ) }}

For more information, see the function documentation in the Help Center and do the tutorials in the Make Academy.

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

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Hey @samliew Thanks for this! I ended up trying this out myself a few times before getting it work.
I didn’t realize that I had to specifically use make’s native functions to get it to work, but it did.

4

No problem, glad I could help!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

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

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.