# Pull License counts into Google Sheet **URL:** \ **Category:** API and Webhooks\ **Created:** [November 28, 2023, 9:15pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189 "2023-11-28T21:15:14Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [November 28, 2023, 9:15pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/1 "2023-11-28T21:15:14Z")
I am trying to pull our current used and available license counts into a Google Sheet and I am not sure what endpoint and scope/s I would need to do this. Any advice would be appreciated. ---
**Author:** ![elisa.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/elisa.zoom/32/47836_2.png) [@elisa.zoom](https://devforum.zoom.us/u/elisa.zoom)\ **Post date:** [November 30, 2023, 5:40pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/2 "2023-11-30T17:40:17Z")
Hi @Gary2 Thanks for reaching out and welcome to our community! Sure thing, you sould be able to get a list of your users with the List Users endpoint here: > **[Zoom Meeting API](https://developers.zoom.us/docs/api/rest/reference/zoom-api/methods/#operation/users)** > > API Reference for /docs/api/rest/reference/zoom-api/methods ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [December 1, 2023, 7:50pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/4 "2023-12-01T19:50:46Z")
Hi Elisa, I have used the documentation you linked me and I am not getting the following error. Invalid access token, does not contain scopes: [user:write:admin, user:write]. The documentation states that I need user:read:admin, do I actually need the write scopes as well? ---
**Author:** ![elisa.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/elisa.zoom/32/47836_2.png) [@elisa.zoom](https://devforum.zoom.us/u/elisa.zoom)\ **Post date:** [December 4, 2023, 5:31pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/5 "2023-12-04T17:31:44Z")
@Gary2 You should only need the user:read:admin scope ![Screenshot 2023-12-04 at 12.31.06 PM](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/4/3/43293fe5fa7c78e16e25d591bfd0db5f21f35601.png) Are you calling any. other endpoint? ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [December 5, 2023, 4:22pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/7 "2023-12-05T16:22:48Z")
I found the issue in my script, which returns all active users. I would now like to use the license query but I do not know what the licenses are called to query them. I have tested the included example, and it returns 0, which is correct. Is there a list of the license names for that query documented somewhere? Here is the example I am talking about. l ![Screenshot 2023-12-05 at 10.22.23 AM](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/8/a/8a7a10a7ca8da823d00e57f69534d36aa46e8231.png) Thanks for your help ---
**Author:** ![elisa.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/elisa.zoom/32/47836_2.png) [@elisa.zoom](https://devforum.zoom.us/u/elisa.zoom)\ **Post date:** [December 5, 2023, 5:42pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/8 "2023-12-05T17:42:32Z")
Yes, you will see the list of licenses in the response body > **[Zoom Meeting API](https://developers.zoom.us/docs/api/rest/reference/zoom-api/methods/#operation/users)** > > API Reference for /docs/api/rest/reference/zoom-api/methods ![Screenshot 2023-12-05 at 12.39.46 PM](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/8/4/84b80463b554033fb5ce552bf5ad113a642a47f5.png) ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [December 5, 2023, 6:00pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/9 "2023-12-05T18:00:25Z")
So, there is no way to query for Zoom One or Zoom Contact Center licenses? ---
**Author:** ![elisa.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/elisa.zoom/32/47836_2.png) [@elisa.zoom](https://devforum.zoom.us/u/elisa.zoom)\ **Post date:** [December 6, 2023, 4:04pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/10 "2023-12-06T16:04:03Z")
Yes, in that same endpoint there is a zoom\_one\_type field that will return zoom one options ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [February 2, 2024, 4:50pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/11 "2024-02-02T16:50:49Z")
Hi Elisa, I pulled this from a user that has a Zoom One license but it does not give the zoom\_one\_type. What am I missing? This is what it returns User Details: { “id”: “xxx”, “first\_name”: “xx”, “last\_name”: “xx”, “display\_name”: “xx”, “email”: “xxm”, “type”: 1, “pmi”: 0, “timezone”: “xx”, “verified”: 0, “dept”: “xx”, “created\_at”: “2022-01-25T17:18:08Z”, “last\_login\_time”: “2022-02-01T22:59:06Z”, “last\_client\_version”: “5.9.1.3506(mac)”, “language”: “en-US”, “phone\_number”: “xxxxx”, “status”: “active”, “role\_id”: “2”, “employee\_unique\_id”: “xxxxx”, “user\_created\_at”: “2022-01-25T17:18:08Z” } ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [February 2, 2024, 6:13pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/13 "2024-02-02T18:13:03Z")
Hi @Gary2 , There should be a a `zoom_one_type` field in the response body for Get a user. Do you see it? ![image](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/7/4/74c075cf81b77734b8454e11ca062c68c3fc4da4.png) > **[Zoom User API](https://developers.zoom.us/docs/api/rest/reference/user/methods/#operation/user)** > > API Reference for /docs/api/rest/reference/user/methods ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [February 2, 2024, 8:09pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/14 "2024-02-02T20:09:40Z")
I am pulling using the user API. Below is what I get when I pull for a user with a Zoom One license. There is no zoom\_one\_type like the documentation says. User Details: { “id”: “xxx”, “first\_name”: “xx”, “last\_name”: “xx”, “display\_name”: “xx”, “email”: “xxm”, “type”: 1, “pmi”: 0, “timezone”: “xx”, “verified”: 0, “dept”: “xx”, “created\_at”: “2022-01-25T17:18:08Z”, “last\_login\_time”: “2022-02-01T22:59:06Z”, “last\_client\_version”: “5.9.1.3506(mac)”, “language”: “en-US”, “phone\_number”: “xxxxx”, “status”: “active”, “role\_id”: “2”, “employee\_unique\_id”: “xxxxx”, “user\_created\_at”: “2022-01-25T17:18:08Z” } ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [February 5, 2024, 11:28pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/15 "2024-02-05T23:28:44Z")
Hi @Gary2 , I was able to reproduce similar results on my test account – let me check with our broader API team. ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [February 23, 2024, 8:53pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/16 "2024-02-23T20:53:38Z")
Any update from the API team? ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [February 29, 2024, 10:49pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/17 "2024-02-29T22:49:35Z")
Hi @Gary2 , Sorry for the delay. It is being reviewed (ZSEE-121029). ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [March 7, 2024, 5:04pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/18 "2024-03-07T17:04:47Z")
Is that a ticket number I can follow somewhere? ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [March 7, 2024, 10:30pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/19 "2024-03-07T22:30:13Z")
> [@gianni.zoom](#): > > ZSEE-121029 Hi @Gary2 , this is our internal reference system to help myself and other Zoomies track issues. I have my notifications set for updates to relay accordingly. If you’d like SLA and trackable support, our Premier Developer Support plans are your go to- [Zoom Developer Docs](https://developers.zoom.us/support/) ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [March 14, 2024, 4:22am UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/20 "2024-03-14T04:22:11Z")
> [@gianni.zoom](#): > > ZSEE-121029 Just followed up with them for an update. ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [March 18, 2024, 7:15pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/21 "2024-03-18T19:15:17Z")
Hi @Gary2 , Here’s what I’ve learned: The zoom\_one\_type column will be returned once the user license is a _bundle license_. When they checked my test account, they confirmed mine is a standard license user, so it does not return the zoom\_one\_type. My test account is Zoom one business plan (actually this is a standard meeting license\_, and was previously only named “meeting license” but, now changed to Zoom one business. To me it is still unclear. I’m waiting for what determines “bundle license”. Could you tell me how the licenses were acquired for the account/users where you received similar API response? ---
**Author:** ![Gary2](https://avatars.discourse-cdn.com/v4/letter/g/49beb7/32.png) [@Gary2](https://devforum.zoom.us/u/Gary2)\ **Post date:** [March 20, 2024, 4:58pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/22 "2024-03-20T16:58:01Z")
Hi Gianni, I am not sure how they were acquired. I believe we have a contract for X amount and then add as needed. ---
**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\ **Post date:** [March 22, 2024, 5:52pm UTC](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189/23 "2024-03-22T17:52:13Z")
Hi @Gary2 , I recommend reaching out to [Accounts/Billing team](https://support.zoom.com/hc/en/article?id=zm_kb&sysparm_article=KB0060580). Explain the API behavior, share my findings and ask for clarification about the license types for your account. [Next page](https://devforum.zoom.us/t/pull-license-counts-into-google-sheet/99189.md?page=2)