Decrypt / Decode the content from incoming message from AWS SNS to ultra pipeline

[deepak_shaw]

I have received the below message from AWS SNS to my ultra pipeline, I would like to know how I can Decrypt / Decode the content from the message. Thanks
[
{
“task_name”: “xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”,
“client_port”: 19549,
“x-amz-sns-topic-arn”: “arn:aws:sns:xxxxxxxxxxxxxxxxxxxxx”,
“connection”: “keep-alive”,
“user-agent”: “Amazon Simple Notification Service Agent”,
“x-amz-sns-message-type”: “SubscriptionConfirmation”,
“x-forwarded-for”: “xxxxxxxxxxxx”,
“host”: “partners-fm.snaplogic.io”,
“content-length”: “1606”,
“x-amz-sns-message-id”: “7dabe4e2-e211-415f-8972-eaeeb3bad1d9”,
“content-type”: “text/plain; charset=UTF-8”,
“path_info”: “”,
“method”: “POST”,
“query”: {
},
“server_ip”: “xxx.xxx.xxx.xxx”,
“client_ip”: “xxx.xxx.xxx.xxx”,
“server_port”: 8084,
“uri”: “xxxxxxxxxxxxxxxx/Deepak%20Shaw/SNSTestUTask”,
“content”: “ewogICJUeXBlIiA6ICJTdWJzY3JpcHRpb25Db25maXJtYXRpb24iLAogICJNZXNzYWdlSWQiIDogIjdkYWJlNGUyLWUyMTEtNDE1Zi04OTcyLWVhZWViM2JhZDFkOSIsCiAgIlRva2VuIiA6ICIyMzM2NDEyZjM3ZmI2ODdmNWQ1MWU2ZTI0MjVlOTBjY2Y2MjMxNTYwOWNlODhhN2FlMGRmMmFkZjFlZDQ4ZmEwN2MzMThlMGJmYjcyYzczYjlkNTQyMWMwNmM2OGQ4NTM2YTYzMzQ3ODUzNzRiODVlOTFjMzY2NWFjMzJlYTRmZWNiYWEwM2VhNjJjYTEwMjkzOGIwNTUwZmZiOWEwODNhMmU0NzdmNjI1ZmJmOTc2NjcwMjk3ZDg4Mzk3NzdjNjBjMGE5M2RlOGQ2YWFmNjRlZWMxZmRkZTIwNTJiYTVhOWM0OGU0ZWVlM2E2ZjNlZjg5YTZlZTEzNDgyNDg1MGMxIiwKICAiVG9waWNBcm4iIDogImFybjphd3M6c25zOmFwLXNvdXRoZWFzdC0yOjEwODY1MzYwNzQ1Nzpka3NxdWFyZXVwIiwKICAiTWVzc2FnZSIgOiAiWW91IGhhdmUgY2hvc2VuIHRvIHN1YnNjcmliZSB0byB0aGUgdG9waWMgYXJuOmF3czpzbnM6YXAtc291dGhlYXN0LTI6MTA4NjUzNjA3NDU3OmRrc3F1YXJldXAuXG5UbyBjb25maXJtIHRoZSBzdWJzY3JpcHRpb24sIHZpc2l0IHRoZSBTdWJzY3JpYmVVUkwgaW5jbHVkZWQgaW4gdGhpcyBtZXNzYWdlLiIsCiAgIlN1YnNjcmliZVVSTCIgOiAiaHR0cHM6Ly9zbnMuYXAtc291dGhlYXN0LTIuYW1hem9uYXdzLmNvbS8/QWN0aW9uPUNvbmZpcm1TdWJzY3JpcHRpb24mVG9waWNBcm49YXJuOmF3czpzbnM6YXAtc291dGhlYXN0LTI6MTA4NjUzNjA3NDU3OmRrc3F1YXJldXAmVG9rZW49MjMzNjQxMmYzN2ZiNjg3ZjVkNTFlNmUyNDI1ZTkwY2NmNjIzMTU2MDljZTg4YTdhZTBkZjJhZGYxZWQ0OGZhMDdjMzE4ZTBiZmI3MmM3M2I5ZDU0MjFjMDZjNjhkODUzNmE2MzM0Nzg1Mzc0Yjg1ZTkxYzM2NjVhYzMyZWE0ZmVjYmFhMDNlYTYyY2ExMDI5MzhiMDU1MGZmYjlhMDgzYTJlNDc3ZjYyNWZiZjk3NjY3MDI5N2Q4ODM5Nzc3YzYwYzBhOTNkZThkNmFhZjY0ZWVjMWZkZGUyMDUyYmE1YTljNDhlNGVlZTNhNmYzZWY4OWE2ZWUxMzQ4MjQ4NTBjMSIsCiAgIlRpbWVzdGFtcCIgOiAiMjAyMS0wNy0xNVQxMzo1ODoxOS4yODRaIiwKICAiU2lnbmF0dXJlVmVyc2lvbiIgOiAiMSIsCiAgIlNpZ25hdHVyZSIgOiAiTTc4OEVUbkJQU2VJUmVpMkpWa0FRRW1aU1g0Zm1OZkhadkhMcmtqb2FuN0YrRzFmVFFKeDFRb0VyZXFvQjBsYmltTGg0a292emw0MUFpUWFKVzdhOXlXRFNvKzhaRkUzL1RZT2N0U1plWWdvd1VZMUZvcmFOa1A1VTMxTHRRb2ZMK2FXOTBNQkNFUnl2SDN1MXM3c2NDayt2d3oxb2pEWlNoRVFuSUhhSTdRYWNzL0NBRHl5QWUzTDJjbEhZdll2WVdSMWsvUG9WY2ZqTER0VmNEVndsc0lWZXFrOU5EZDRsekx3QU9LTWhGUEdrQk9lRm1xYmhnMld6dUNSdVVoK2pSVlc2R2JSTWpBNjhHa3Mxd0tyV1oxYjd0NVFHUGJIWms3OWZMbHpuWU9RTmFaWWJCTGhZaGpMc0kybmx1SGx2YmhReHZuNG5qMkFsZEhOd0JpRFVRPT0iLAogICJTaWduaW5nQ2VydFVSTCIgOiAiaHR0cHM6Ly9zbnMuYXAtc291dGhlYXN0LTIuYW1hem9uYXdzLmNvbS9TaW1wbGVOb3RpZmljYXRpb25TZXJ2aWNlLTAxMGE1MDdjMTgzMzYzNmNkOTRiZGI5OGJkOTMwODNhLnBlbSIKfQ==”
}
]

[deepak_shaw]

I got a solution:

JSON.parse(Base64.decode($content))

If there is any better way, please let me know. Thanks.

[SpiroTaleski]

Hi @deepak.shaw

Another way is by using the Document to Binary and Binary to Document snaps. But, my opinion is that using the Base64 encode/decode functions is better approach.

Regards,
Spiro Taleski

[deepak_shaw]

Thanks for your advice 😀

[deepak_shaw]

Hi,
I’m getting Error:
[
{
“failure”: “byte type does not have a method named: content, found in: $payload.content. Perhaps you meant: concat”,
“value”: “Please check expression syntax and data types.”,
“reason”: “Please check expression syntax and data types.”,
“sub-expression”: {
“0: $payload”: [
{
“_snaptype_binary_base64”: “ewogICJUeXBlIiA6ICJOb3RpZmljYXRpb24iLAogICJNZXNzYWdlSWQiIDogIjkxOTI2ZWEyLWE3ODgtNWIxZC1hNTNkLTM3Yzk4MzM0NTliZiIsCiAgIlRvcGljQXJuIiA6ICJhcm46YXdzOnNuczphcC1zb3V0aGVhc3QtMjoxMDg2NTM2MDc0NTc6ZGtzcXVhcmV1cCIsCiAgIlN1YmplY3QiIDogInRlc3QxNjA4IiwKICAiTWVzc2FnZSIgOiAiW3tcbiAgIFwic3RvcmVfaWRcIjogMjEyLFxuICAgIFwib3JkZXJcIjoge1xuICAgICAgICBcInJlZmVyZW5jZV9pZFwiOiBcIm15LW9yZGVyLTE2MDhcIixcbiAgICAgICAgXCJjdXN0b21lcl9pZFwiOiBcIkRJVlMwMVwiLFxuICAgICAgICBcImxpbmVfaXRlbXNcIjogW1xuICAgICAgICAgICAge1xuICAgICAgICAgICAgICAgIFwicXVhbnRpdHlcIjogXCIyXCIsXG4gICAgICAgICAgICAgICAgXCJiYXNlX3ByaWNlX21vbmV5XCI6IHtcbiAgICAgICAgICAgICAgICAgICAgXCJhbW91bnRcIjogMixcbiAgICAgICAgICAgICAgICAgICAgXCJjdXJyZW5jeVwiOiBcIkFVRFwiXG4gICAgICAgICAgICAgICAgfSxcbiAgICAgICAgICAgICAgICBcIm5hbWVcIjogXCJtaWxrXCIsXG4gICAgICAgICAgICAgICAgXCJub3RlXCI6IFwiaG90IG1pbGsgb25seVwiXG4gICAgICAgICAgICB9XG4gICAgICAgIF1cbiAgICB9XG59XSIsCiAgIlRpbWVzdGFtcCIgOiAiMjAyMS0wNy0xNlQwNjowOTowMC4zNThaIiwKICAiU2lnbmF0dXJlVmVyc2lvbiIgOiAiMSIsCiAgIlNpZ25hdHVyZSIgOiAiVjVpZFpjbGx1RVEzNE9EbFZPNHprZklXSER5MTJhQWdiUkZEQ21kNWsvSjZONVUzYUZRd0NzUllJUjREVlpnY29Mc3ZpS2ViS3dZWFZrUzloaEhEUHF4emlyQzFuODB1bDRTUXpKRVJnT3dZSnp6Y2JSaWNSY3hCeWhyUldmZHYwQmZHd2grTWIwdFh3YlpmRnZHc2VNUmU2NjdZRndRR01TMjhILzZlSHJVajlWellxTnRKQmdLTkRuMWd5SEhzbGRYQWtPaDZyZkpxSFYxZ0wvUlZRRGx3a0lCeG1WN0JEdzk5TDN4QWx4THFEY0pLMkVIQkFYRFR4empPTCt1Mk5KNHdvN0ZEK2YvR21xZ1lXbzNDZ09mL1V1RmlIcStwdWozRGhuSi91d3dGQnlmUFJLdlNpemFiS0R1SERiNHNsUlFGV1NrYjcrK0gyVkpJOGZiczdBPT0iLAogICJTaWduaW5nQ2VydFVSTCIgOiAiaHR0cHM6Ly9zbnMuYXAtc291dGhlYXN0LTIuYW1hem9uYXdzLmNvbS9TaW1wbGVOb3RpZmljYXRpb25TZXJ2aWNlLTAxMGE1MDdjMTgzMzYzNmNkOTRiZGI5OGJkOTMwODNhLnBlbSIsCiAgIlVuc3Vic2NyaWJlVVJMIiA6ICJodHRwczovL3Nucy5hcC1zb3V0aGVhc3QtMi5hbWF6b25hd3MuY29tLz9BY3Rpb249VW5zdWJzY3JpYmUmU3Vic2NyaXB0aW9uQXJuPWFybjphd3M6c25zOmFwLXNvdXRoZWFzdC0yOjEwODY1MzYwNzQ1Nzpka3NxdWFyZXVwOjVlZTkwMTcxLTUyMmUtNDNjNi1iZDNkLTQ2YmI2NjAxNjJmMCIKfQ==”
}
]
}
},
{
“failure”: “byte type does not have a method named: content, found in: $payload.content. Perhaps you meant: concat”,
…
Can you please suggest, what is going wrong here
I’m using Base64.decode($payload.content)