Encrypting sensitive information on ecc_queue

[Community Alums]

Hi,

I'm running commands on the MID server and I'm using the AutomationAPI.encrypt function to encrypt sensitive information in the payload field:

This is great, apart from the fact that when the input record is generated with the results, it contains the command with the sensitive data in its un-encrypted form:

Is there a way to suppress this? Or will I have to write some code to update the input record's payload?

Thanks,

Tim.

[Ankur Bawiskar]

@Community Alums 

Did you try to use column level encryption on ecc_queue table and that payload field?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Community Alums]

@Ankur Bawiskar No, I can't use that approach, this is part of a store application, we can't assume customers will want to implement field encryption, so I need to make sure our app treats sensitive information correctly.

[Ankur Bawiskar]

@Community Alums 

see if you can try to use Sensitive Data handler feature

Sensitive Data Handler 

If my response helped please mark it correct and close the thread so that it benefits future readers.