Zoom rest API into Alteryx

[calloni]

Hello all

I would like to know if someone already have some guide on how to use Alteryx to gather data from Zoom rest API.

Thanks in advance

Rodrigo

[BenMoss]

Hi,

We have a workflow that does this ourselves. The main problem we encountered was the JWT authentication process that Zoom requires. We did this by using the python tool.

I can't share the workflow right now (11pm where I am and I'm not at my laptop), but I should be able to send over tomorrow.

Ben

[BrandonB]

It looks like they have public API documentation available here: https://marketplace.zoom.us/docs/api-reference/using-zoom-apis 

You will need to use two download tools. The first will call the OAuth endpoint and pass the access token into a second download tool which will then call the API endpoint that you would like to pull data from. 

[BenMoss]

As promised, here is a workflow that showcases how we can use the JWT authentication route to create our bearer token which can then be used in subsequent requests.

The 'magic sauce' lies in the python tool where you will need to add your own API key and secret, as outlined in this post...

https://marketplace.zoom.us/docs/guides/auth/jwt

I hope this is useful.

Ben

[calloni]

Hey Ben

Thanks so much. Sorry I didnt reply earlier, I was stuck (still am) on getting the Zoom credentials 😕

I will jump on yours now.

Rodrigo

[calloni]

Hi Ben

I got the keys... I guess I need to download and install the predictive tools as this is using the python script you mentioned.

Let me know if that is indeed the case so I can update my version here.

Thanks

Rodrigo

[calloni]

Now I got the pyjwt package installed so I can pass the python script. But now I am getting that my token is expired.

I will try again later today... almost there 🙂

Rodrigo 

[calloni]

Hi Ben

I know this will sound stupid... but where can I get the user ID in Zoom?

The API for meetings is listed as following:

https://api.zoom.us/v2/users/{userId}/meetings

I see in your workflow you got a long string there. Do you happen to remember where you got it?

Thanks in advance

Rodrigo

[BenMoss]

I think you need to connect to this endpoint first which will return a list of users in your company and there IDs...

https://marketplace.zoom.us/docs/api-reference/zoom-api/users/users

Ben

[calloni]

I see in the documentation that these endpoints have oauth authentication instead of jwt.

All endpoints I try always return the same error that token is expired. When I look at the python script I see that I am getting a positive response (so I guess jwt authentication is working):

I wonder, does your workflow still works for you using jwt?

Thanks a lot Ben

Rodrigo