Description
We are a Zoom Authorized Reseller and we wanting to pull the Sub Accounts list into a Google Sheet so we can use the data and automate some of our sales process.
For now just getting authenticated with Google Sheet or visa versa via the Script Editor is a challenge.
My programming skills are very rusty and going to need some hand holding please…
Error
The full error message or issue you are running into.
Which App Type (OAuth / Chatbot / JWT / Webhook)?
Knowing the endpoint/s can help us to identify your issue faster. Please link the ones you need help/have a question with.
Which Endpoint/s?
Knowing the API endpoint/s can help us to identify your issue faster. Please link the ones you need help/have a question with.
How To Reproduce (If applicable)
Steps to reproduce the behavior:
Request URL / Headers (without credentials) / Body
See error
Screenshots (If applicable)
If applicable, add screenshots to help explain your problem.
Additional context
Add any other context about the problem here.
To authenticate your request, you’ll need to first create a JWT app under the Zoom account whose sub accounts you’ll want to query (if you haven’t already).
You can follow the steps outlined in this article to create a JWT app in the Zoom Marketplace, in order to get these credentials:
After you create the app, you can generate the API key and Secret by following the steps here:
You can then use these credentials to authenticate your request with a JWT token.
Andre is our “Dev guy” and helped me with the JWT, it works perfect, now difficult part is figuring out the for loops to populate the feedback/data into the Google sheet.
Glad that this got you going in the right direction!
In regards to populating your google sheet with the API response, I might recommend checking out StackOverflow or Google for some quick help. For instance: