Encrypting the data in a row and Loading Each row as a single queue item to Queue

[Harsha_Vemula (Harsh1422)]

Hi Team,
I want to encrypt the data row in the below data table and want to load each row as a single queue item by taking the reference as Name column. Can you suggest me in doing this with the best approach.
Input Data Table :

Name	Bank Name	Account num	Balance	Total Bill Amount
ABC	aaaaa	123123123	2304.89	2211.11
EFG	bbbbb	234234234	1289.67	2332.45
HIJ	ccccc	345345345	1234.34	26.98
KLM	ddddd	456456456	6735.9	253.98
NOP	eeeee	567567567	7362.44	873.09

[bhavesh.choubey]

Loop through each DataTable row – Use a For Each Row activity then convert row to JSON – So the whole row becomes one string. Then encrypt JSON string – Use AES or another encryption method for security. Use Add Queue Item – Reference → row("Name").ToString (Name column) Specific Content → Encrypted JSON string

Cheers

[ashokkarale]

@Harsha_Vemula,

Just enable encryption at queue level and use bulk add queue items or add queue item activity as it is.

Orchestrator - Managing Queues in Orchestrator