How to get value from encrypted field in email script.

[kumaraj]

Hi All, 

Greetings,

I have the below requirement, so it would be great of you if you suggest me the solution for this,

I am getting some data on staging table from kafka connector and creating a case using kafka alert filed value using tranform map code. Once case is created then same transform map code triggers an event to send an email to user.

We need to map values of 3 fields from staging table in a encrypted field called "Secure Notes" on the case so that agent can not see it as security reason.

Then we need to create an email script where we need to get the 3 field's value from secure notes such a way so that we can use it in email template as variable while sending notification.

case table name is csm_kafka_case , staging table is u_staging_table

Secure notes field is secure_notes and the 3 fields are device, ip and model.

Q. how can we create email script so that we can get all 3 fields value as separate variables in email and then how to use it in email template body.

If you help me with code then it would be really helpful for me.

Thank you

[Community Alums]

Hi Kumaraj,

To get the encrypted value in notification first you needs to decrypt that field value then you can show that field value in notification.

So write one mail script to decrypt your field value and pass that mail script output in your notification.

For more info. how to decrypt the encrypted field value refer below thread it will helps you:

Re: Decrypting a value to set as password not working

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep