Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Base64 Encoded SHA 256

brianvtran
7 - Meteor

Hello,

 

I have a request to encrypt some emails using base64 encoded SHA 256. I've used SHA 256 before but it's not giving me the same result as the example given. What is exactly base64 encoded sha256? My original thought process was that I would have to base64 encode the string first and then take sha256 so I attempted this by using the base64 encoder and then using a sha256, and also, by the suggestion of a different thread, blob converts to get base64 encoding and taking the SHA 256 of that. However, nothing I produced matches the hash of the example. 

 

example: 

janedoe@gmail.com --> 1hFzBkhe0OUK+rOshx6Y+BaZFR8wKBUn1j/18jNlbGk= (base64 encoded sha256)

 

Results: 

 

janedoe@gmail.com --> amFuZWRvZUBnbWFpbC5jb20= (b64 encoder)

--> d6117306485ed0e50afab3ac871e98f81699151f30281527d63ff5f233656c69 (SHA 256)

 

janedoe@gmail.com --> d6117306485ed0e50afab3ac871e98f81699151f30281527d63ff5f233656c69 (SHA 256)

--> ZDYxMTczMDY0ODVlZDBlNTBhZmFiM2FjODcxZTk4ZjgxNjk5MTUxZjMwMjgxNTI3ZDYzZmY1ZjIzMzY1NmM2OQ== (base64 encoder)

 

janedoe@gmail.com --> agBhAG4AZQBkAG8AZQBAAGcAbQBhAGkAbAAuAGMAbwBtAA== (Blob Convert base64)

--> 89eaf35d17ca3779596f4cc0f2a5696985fd482404fe0b1a8f66ea0eedee6b07 (SHA 256)

 

janedoe@gmail.com --> d6117306485ed0e50afab3ac871e98f81699151f30281527d63ff5f233656c69 (SHA 256)

--> 

ZAA2ADEAMQA3ADMAMAA2ADQAOAA1AGUAZAAwAGUANQAwAGEAZgBhAGIAMwBhAGMAOAA3ADEAZQA5ADgAZgA4ADEANgA5ADkAMQA1ADEAZgAzADAAMgA4ADEANQAyADcAZAA2ADMAZgBmADUAZgAyADMAMwA2ADUANgBjADYAOQA= (Blob Convert base64 but it has embedded newlines)

 

Any clarification and help would be much appreciated.

 

Brian

1 REPLY 1
brianvtran
7 - Meteor

Nevermind, I was able to figure out a solution using Python tool to do the base64 encoded sha256. 

 

Thanks anyway. 

Labels