07-28-2021 06:37 AM
Hello Experts,
i’m trying to encrypt one of the field of csv file using Encrypt Field snap.
i have selected transform type as auto and selected account of Passphrase-based Key type.
As a result of encrypt field snap ,field got encrypted.
in next snap i’m mapping encrypted field(column.ciphertext) and other columns and writing data to file.
In second pipeline reading encrypted file and trying to decrypt using same Passphrase-based Key based account.
but encrypted field is not getting decrypted .
Attaching pipeline for reference .
decFIle_2021_07_28.slp (10.8 KB)
Encrypt file_2021_07_28.slp (10.8 KB)
Regards,
Ajay
07-28-2021 07:35 AM
I think the issue is with the mapping of $Amount.ciphertext to $AmountType (in order to map that, the “Encapsulate output” option of the Encrypt Field snap needs to be unchecked). I built a test pipeline that looks like this:
The JSON Generator has simple JSON like this:
[{"msg":"Hello world!"}]
Similar to your setup I used a Passphrase-based Key account type with a simple passphrase.
Here is the Encrypt Field snap:
Here is the Decrypt Field snap:
After validating the pipeline here is the Encrypt Field output:
[
{
"msg": {
"transformation": "AES/GCM/NoPadding",
"iv": "yjvD0qXH0MuwVqKhaDnZbg==",
"type": "STRING",
"ciphertext": "6aJAEWHFctinn8pZUPPLsG+E1OsMH49gEy08xQ==",
"key_params": {
"passphrase": {
"key_gen_iterations": 10000,
"key_gen_algorithm": "PBKDF2WithHmacSHA1",
"key_algorithm": "AES",
"key_salt": "NB8NMQyEqeItdu0tyn8XTga+udA=",
"key_size": 128
}
}
}
}
]
If there is no Mapper snap between the Encrypt Field and Decrypt Field it works just fine, however, if you add a Mapper after validation you can see the Decrypt Field Snap is expecting more information than just the cipher text (look at the target schema on the right):
07-28-2021 06:40 PM
HI @rsramkoski ,
Thank you for reply.
So for decypt snap what are the other fields we need to pass?
we are planning to store only ciphertext filed from encrypted snap.
Regards,
Ajay
07-29-2021 04:36 AM
Hello @Ajay_Chawda, you’re welcome. You can view the required fields in the Target Schema section on the right-hand side of the Mapper screenshot.
08-26-2021 01:26 AM
When I tried this I got a string output from the encrypt snap.
Could you post the pipeline?