Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Decode JWT token in custom connector

Hi, How to decode JWT access_token in power query? GetMetadataTable= () as any => let currentCredential = Extension.CurrentCredential(), access_token_decoded=currentCredential[access_token], de...
Need Help
  • curth's avatar
    curth
    5 years ago
    let
    Token = "<snip>",
    Base64Url.Decode = (s) => Binary.FromText(Text.Replace(Text.Replace(s, "-", "+"), "_", "/") & {"", "", "==", "="}{Number.Mod(Text.Length(s), 4)}, BinaryEncoding.Base64),
    Parts = Json.Document(Base64Url.Decode(Text.Split(Token, "."){1}))
in
    Parts
curth's avatar
curth
Power BI Team
5 years ago
let
    Token = "<snip>",
    Base64Url.Decode = (s) => Binary.FromText(Text.Replace(Text.Replace(s, "-", "+"), "_", "/") & {"", "", "==", "="}{Number.Mod(Text.Length(s), 4)}, BinaryEncoding.Base64),
    Parts = Json.Document(Base64Url.Decode(Text.Split(Token, "."){1}))
in
    Parts