topic Re: Zoom REST API Data Extraction - JWT Authentication in Integration, Extension & APIs

Zoom REST API Data Extraction - JWT Authentication

alando — Wed, 28 Jul 2021 12:46:31 GMT

Hi all,

I have set up a REST API to extract Zoom meetings data. At the moment I am using JWT to manually create the authentication token. Then I paste the token into my Qlik REST API connection setting. The token will expire in a few days.

Does anyone know if there is a way to configure the JWT token to update automatically in Qlik? This will be useful when I want to set up my Zoom extraction to work in a scheduled ETL process, as it is not feasible to manually update the token every few days.

Thanks

Alando

Re: Zoom REST API Data Extraction - JWT Authentication

rzenere_avvale — Wed, 28 Jul 2021 12:53:18 GMT

Hey there @alando ,

from my knowledge it's not possible to update automatically the parameters you set on a data connection.

However, I suggest you to try this approach, using the WITH CONNECTION clause:

you create the script necessary to retrieve automatically the new token
once you obtained the token, you move it to a variable
you'll use the WITH CONNECTION clause in the subsequent calls, forcing an HTTPHEADER with the new token
Reference: link

I hope this helps,
Riccardo

Re: Zoom REST API Data Extraction - JWT Authentication

alando — Wed, 28 Jul 2021 13:04:28 GMT

Hi @rzenere_avvale ,

Thank you for the prompt response. I will give it a go.

Cheers

Alando

Re: Zoom REST API Data Extraction - JWT Authentication

Damien_V — Wed, 28 Jul 2021 13:18:57 GMT

Hello,
Otherwise, as an alternative, you can also use the QRS API to update the data connection string.

https://help.qlik.com/en-US/sense-developer/May2021/APIs/RepositoryServiceAPI/index.html?page=901

You would need to run an external script (PowerShell or else) that calls the API every few days and update the connection string with the new token.

@rzenere_avvale 's method might be easier though.

Re: Zoom REST API Data Extraction - JWT Authentication

alando — Wed, 28 Jul 2021 13:30:12 GMT

Hi @Damien_V ,

Thank you for the recommendation. I will keep your suggestion in mind if suggestion 1 does not work.

Regards

Alando

Regards,

Alando