# Limit on Max Page Size : 30

**URL:** <https://devforum.zoom.us/t/limit-on-max-page-size-30/7510>\
**Category:** API and Webhooks\
**Created:** [January 14, 2020, 7:04pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510 "2020-01-14T19:04:07Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![thummalapriyanka](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/thummalapriyanka/32/2895_2.png) [@thummalapriyanka](https://devforum.zoom.us/u/thummalapriyanka)\
**Post date:** [January 14, 2020, 7:04pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/1 "2020-01-14T19:04:07Z")

</div>

**Description**  
Using the Zoom API, I want to retrieve the complete data of ListMeetings,Zoom Rooms etc.( Whatever I am seeing in the standard zoom dashboard)using Python coding and save the output file to local desktop in json format. But, I am not able to see the complete output because of the page size limit. How can I get the complete data?  
Will Zoom provide the data in any format ? My requirement is to extract the data using Zoom API’s in json format and create the Tableau dashboard. Please provide your inputs.

**Error**  
The full error message or issue you are running into.

**Which App Type (OAuth / Chatbot / JWT / Webhook)?**  
JWT

**Which Endpoint/s?**  
Example : [https://api.zoom.us/v2/users](https://api.zoom.us/v2/users)

Python Code I have used to extract the data.

import requests  
import json  
url = “[https://api.zoom.us/v2/users](https://api.zoom.us/v2/users)”

querystring = {“status”:“active”}

headers = {‘authorization’: ‘Bearer xxxxx’}

response = requests.request(“GET”, url, headers=headers, params=querystring)

with open(‘C:/Users/Priya/Documents/ActiveUsers.json’, ‘w’) as json\_file:  
json.dump(response.json(), json\_file,indent=4, sort\_keys=True)

---

<div class="post-metadata">

**Author:** ![tommy](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/tommy/32/72769_2.png) [@tommy](https://devforum.zoom.us/u/tommy)\
**Post date:** [January 14, 2020, 7:50pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/2 "2020-01-14T19:50:40Z")

</div>

Hey @thummalapriyanka, thanks for posting and using Zoom!

For the List Users API you can specify the `page_size` query param to return `300` users. For additional users, specify the `page_number` query param to get the next 300 users.

Thanks,  
Tommy

---

<div class="post-metadata">

**Author:** ![thummalapriyanka](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/thummalapriyanka/32/2895_2.png) [@thummalapriyanka](https://devforum.zoom.us/u/thummalapriyanka)\
**Post date:** [January 14, 2020, 9:35pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/3 "2020-01-14T21:35:15Z")

</div>

> [@tommy](#):
>
> `_number` query param to get the next 300 users.

Is there a way I can get the complete data when I hit the API without giving the page\_size & page\_number?

---

<div class="post-metadata">

**Author:** ![tommy](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/tommy/32/72769_2.png) [@tommy](https://devforum.zoom.us/u/tommy)\
**Post date:** [January 14, 2020, 10:04pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/4 "2020-01-14T22:04:36Z")

</div>

Hey @thummalapriyanka,

Unfortunately no. You must use the page\_size & page\_number params.

Thanks,  
Tommy

---

<div class="post-metadata">

**Author:** ![thummalapriyanka](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/thummalapriyanka/32/2895_2.png) [@thummalapriyanka](https://devforum.zoom.us/u/thummalapriyanka)\
**Post date:** [January 16, 2020, 7:11pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/5 "2020-01-16T19:11:24Z")

</div>

Do you have any python code to extract the complete data without providing the page\_size & page\_number ?

---

<div class="post-metadata">

**Author:** ![tommy](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/tommy/32/72769_2.png) [@tommy](https://devforum.zoom.us/u/tommy)\
**Post date:** [January 16, 2020, 7:41pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/6 "2020-01-16T19:41:31Z")

</div>

Hey @thummalapriyanka,

The way our API ([and most APIs](https://developer.atlassian.com/server/confluence/pagination-in-the-rest-api/)) work when returning large amounts of data is with pagination.

You must use the `page_size` and `page_number` to get all of the data.

Thanks,  
Tommy

---

<div class="post-metadata">

**Author:** ![baitha](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/baitha/32/6444_2.png) [@baitha](https://devforum.zoom.us/u/baitha)\
**Post date:** [April 18, 2020, 4:35pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/7 "2020-04-18T16:35:01Z")

</div>

@thummalapriyanka and @tommy, I bumped into this while searching for any thread that can point me to Zoom API/Snowflake/Tableau integration. I am looking for a Python code to use Zoom API and populate Zoom meetings details (user id, application id, meeting start time, end time, participant details etc.) into a Snowflake table. The final goal is to develop a Tableau dashboard using Snowflake table. Do you have any sample code to share for this?

Thanks  
-Bheem

---

<div class="post-metadata">

**Author:** ![bdeanindy](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/bdeanindy/32/154_2.png) [@bdeanindy](https://devforum.zoom.us/u/bdeanindy)\
**Post date:** [April 18, 2020, 7:28pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/8 "2020-04-18T19:28:12Z")

</div>

Hey @baitha!

I can’t speak for @tommy (he may know about some existing source code which I do not), but I’ve not heard of any available source code for piping data from: Zoom-\>Snowflake-\>Tableau (specifically).

The [Zoom API is RESTful](https://marketplace.zoom.us/docs/api-reference/introduction), and Python has native libraries and published modules available on `[pip](https://pypi.org/project/pip/)`, such as [requests](https://pypi.org/project/requests/2.7.0/), you can include as dependencies as part of your Python app, enabling your code interoperability with Zoom REST API. Using this, your app can:

- Obtain historical data about your Zoom account, within limits defined by [Zoom’s Data Retention, Privacy, and other legal Policies](https://zoom.us/privacy-and-legal).
- To retrieve additional object details, not exposed in the webhook event payload, where only IDs are provided in the event but your app requires more comprehensive data

[Zoom Webhooks](https://marketplace.zoom.us/docs/guides/tools-resources/webhooks) are encrypted HTTP POST requests sent to the Event Subscription URL you define for your Zoom Marketplace App -\> Features -\> Event Subscription (development/production). You just have to make available (either as part of your Python app, or SOA-style independent) publicly available web-server that supports TLSv1.2+ and can accept incoming HTTP POST requests (making sure to respond with an HTTP 200 when successfully received, in an async manner). Using this, your app can:

- Subscribe to a robust/growing, [near-real-time Zoom events](https://marketplace.zoom.us/docs/api-reference/webhook-reference) as they occur in your account
- Create dashboards from the data, or securely send to a dashboard service provider
- Eliminate your app’s need to long-poll Zoom’s REST API
- Conserve valuable API Rate Limit overhead for more critical needs

## For your specific automation workflow @baitha

Using a combination of [Zoom Webhooks](https://marketplace.zoom.us/docs/guides/tools-resources/webhooks) and [Zoom REST API](https://marketplace.zoom.us/docs/guides/tools-resources/zoom-apis), your Python app could:

1. Subscribe to desired Zoom Events (Webhooks) in your Marketplace app
2. Handle received events at your Zoom Marketplace app’s `Event Subscription URL`, then relay into [Snowflake Data Lifecycle](https://docs.snowflake.com/en/user-guide/data-lifecycle.html), making sure to [ETL JSON Data into Snowflake](https://docs.snowflake.com/en/user-guide/script-data-load-transform-json.html)
3. [Establish a secure connection between Tableau and Snowflake](https://www.tableau.com/solutions/snowflake)
4. Build/customize/share your Tableau dashboards!

## For a more drag-n-drop type automation…

Of course, there are some service providers available, such as Zapier, you can use to automate this workflow, and the list of service-automation providers is continually growing. Using these services, the trade off for reduced development time and off-loading of maintenance/support, is the cost of your usage of the service.

## Zoom Policy for 3rd Party Providers

We only recommend using official, approved third party service providers, these apps have been reviewed and published by Zoom on:

- [Zoom App Marketplace](https://marketplace.zoom.us)
- [Zoom Official Integrations](https://zoom.us/integrations)
- [Zoom Official Partners](https://zoom.us/partner-locator) (these are distinct from Marketplace apps)

## !! Protect your Zoom Data !!

**NEVE** R share or store your [Zoom JWT App’s API Keys](https://marketplace.zoom.us/docs/guides/getting-started/app-types/create-jwt-app) with **ANY** third-party!  
The only exception would be [Zoom Marketplace apps](https://marketplace.zoom.us) that are marked as “Built by: Zoom”.

* * *

Does this answer your question (I know it isn’t a turn-key solution, but this should point you in the right direction)?

---

<div class="post-metadata">

**Author:** ![baitha](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/baitha/32/6444_2.png) [@baitha](https://devforum.zoom.us/u/baitha)\
**Post date:** [April 18, 2020, 7:32pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/9 "2020-04-18T19:32:38Z")

</div>

@bdeanindy thanks for the quick reply. This should be get me started.  
-Bheem

---

<div class="post-metadata">

**Author:** ![tommy](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/tommy/32/72769_2.png) [@tommy](https://devforum.zoom.us/u/tommy)\
**Post date:** [April 20, 2020, 9:46pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/10 "2020-04-20T21:46:32Z")

</div>

Thanks Ben!

Let us know if you have additional questions @baitha! 🙂

-Tommy

---

<div class="post-metadata">

**Author:** ![DeveloperBot](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/developerbot/32/12632_2.png) [@DeveloperBot](https://devforum.zoom.us/u/DeveloperBot)\
**Post date:** [August 21, 2020, 8:15pm UTC](https://devforum.zoom.us/t/limit-on-max-page-size-30/7510/11 "2020-08-21T20:15:15Z")

</div>

Closed on August 21, 2020, 8:15pm UTC


