Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
I hope this helps,
Riccardo
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.
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:
I hope this helps,
Riccardo
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.
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