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],
decoded_token= ???
in
 decoded_token;

Something like this: https://jwt.io/ 

 

Thanks 

artemus 

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

2 Replies

  • curth's avatar
    curth
    Icon for Power BI Team rankPower 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