SQL-APIConsumer icon indicating copy to clipboard operation
SQL-APIConsumer copied to clipboard

TSQL: Sign an API request in TSQL with signature encrypted with HMAC-sha256 and encoded by base64

Open bierfust opened this issue 3 years ago • 1 comments

I would like to sign an API request in TSQL. The signature should be encrypted with HMAC-sha256 and be encoded by base64. The end result should be the signature stored in a variable. I hope you can help me out. Many thanks.

Key = 12aee25d-63d1-49ad-a83b-1fb9a0dc1334 String to sign = 1665925038934GET/api/v1/accounts

Desired output Output Base64: Zh45s4j9EmRoKZEmjWZ3wp46ROTIOK6DNt4ifQ1ZuX0=

https://www.devglan.com/online-tools/hmac-sha256-online

bierfust avatar Oct 17 '22 19:10 bierfust

Hello @bierfust ,

I'll be checking this. I'll let you know.

geral2 avatar Oct 28 '22 18:10 geral2