Data Decryption in Qlik Sense.

[Maveer]

Hello Qlik Experts,

We fetch the data using REST API connector. The fetched data is in encrypted format. We need to decrypt the data when imported to Qlik Dashboard.

I like to know , is there any way to decrypt(decryption mechanism) data in Qlik sense ?

Please advise if this is a possibility, if yes, advise the procedure, if No, kindly suggest an Alternative as the Objective is to ensure to the Data displayed on Qlik dashboard is Decrypted.

Below is the sample data which created for reference.

Machine	Id	Country	Role
b56JyaLk1PVhLa6OZx/CExaAQUrs4zXAlbpkZZNXU/w=	JksE16IQ23BG0UTmH872kU9azILdf2ldC82kkvROru4=	jtdil30P/ZmKJsMrSgMYHfHDxLcAjq0Z4z53uZWF3Ps=	UgXMXcx31WzakwG5nSCKVmXgGdPfQfbTkiBbcUutFQg=

[Francisco_Fernandez · Accepted solution]

Hello @Maveer ,

It's possible to achieve that by using SSE (Server side extensions)

Here you will find some documentation about SSE:

https://help.qlik.com/en-US/sense-developer/May2021/Content/Sense_Helpsites/SSE-open-source.htm
https://community.qlik.com/t5/Knowledge/Qlik-Server-Side-Extension-SSE-with-Analytic-Connections/ta-...

and here is an example:

https://github.com/flautrup/SecSSE

Hope this helps.

Best regards,

Francisco