Zoom REST API Data Extraction - JWT Authentication

[alando]

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

[rzenere_avvale · Accepted solution]

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:

1. you create the script necessary to retrieve automatically the new token
2. once you obtained the token, you move it to a variable
3. 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

[alando]

Hi @rzenere_avvale ,

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

Cheers

Alando

[Damien_V · Accepted solution]

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.

[alando]

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