You will need to implement pagination. Basically, you will store the value from each next x results and run the api again to get the next X and so on untill there is no "next" page to go. After that, you can merge all the objects in a single one and converts the json to any desired variable.
I tried to use Per_page with a higher value and did not worked untill i implemented the pagination on my lti (not these googlesheet one).
Many thanks for your quick response. After seeing your post, I did some querying and it looks like pagination will require some programming skills. I'll pass this project off to our developers with the information you provided. I was hoping to relieve them of some busy work by handling some of the less complex reporting tasks. Oh, well. 🙂
Well, this was a major breakthrough for me. I opened the URL part of the formula in Firefox and was able to find the link headers under the Headers tab. This gave me the argument I needed to cycle through the pages of data in Google Sheets. Thanks again for pointing me to pagination.