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 · Accepted solution]

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

[calloni]

OMG OMG OMG!!! Thanks so much Ben!

It was the timezone. I've added 5 hours and got the data.

Whenever I meet you in person, you get a round of beers on me 🙂 (if you drink beers of course!)

Cheers!
Rodrigo

[BenMoss]

Pleasure! This was a useful exercise for myself too as I'm starting to write up a blog on the subject.

Ben

[satya9397]

Hi Ben,

Thank you for the workflow.

While trying to run the workflow encountered "decoding str is not supported error occurred ".

Please refer attached screenshot of error. Please advice on this.

Thank you

Regards

Satya

[calloni]

Hi Ben

I hope this finds you well...

Just checking, does this Zoom authentication still works for you?

I am getting an error in this line of the script you provided before:

TypeError Traceback (most recent call last)
<ipython-input-7-999faf2fc61d> in <module>
----> 1 s=str(encoded,'utf-8')
2
3 data = StringIO(s)
4
5 df=pandas.read_csv(data,header=None)

TypeError: decoding str is not supported

Just checking if yours is still working or if I need to do some update here.

Thanks in advance

Rodrigo

[calloni]

Hi Satya

I got the same today and I found a way to solve this (well a friend of mine found a way).

Just do this on that s = str line:

1 - Remove it

2 - On the next line change it to

data = StringIO(encoded)

Those 2 changes should make it work again

Rodrigo