SQL-APIConsumer
SQL-APIConsumer copied to clipboard
TSQL: Sign an API request in TSQL with signature encrypted with HMAC-sha256 and encoded by base64
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
Hello @bierfust ,
I'll be checking this. I'll let you know.