nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

API

Accepted answers

BenMoss

The JWT script will always return a encoded string regardless of what credentials you put in there.

And I appreciate the endpoint does indeed say that, but it's not true, I have just authenticated against it with a JWT auth token.

The only thing I can think of is that it expects the time in UTC, whereas you are passing a time relevant to your local which of course is way in the past.

Try adjusting the datetimeadd function to adjust for this, something like (this is in the seconds formula tool)...

datetimediff(datetimeadd(datetimeadd(datetimenow(),2,'minutes'),YOURUTCOFFSET,'hours'),"1970-01-01 00:00:00","seconds")

Ben

All comments

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.