JWT Token Decoding Column

[Darko_Vukoje]

I am getting a response as JWT token that I need to convert to json to get the information.

Something like this:

How to decode a jwt token in JavaScript - QuickRef.ME

Tried with js column, using the sam js function like on the link, but never getting anything back. Is there any tested glide column that does this?

Thanks,
Darko

[Jeff_Hager]

Are you using a return to return the value? I can get it to work with this.

const decode = token => decodeURIComponent(atob(token.split('.')[1].replace('-', '+').replace('_', '/')).split('').map(c => `%${('00' + c.charCodeAt(0).toString(16)).slice(-2)}`).join(''));

return decode(p1);

[Darko_Vukoje]

I did. This is strange. You used exactly this code. Could you please send me sample data? Thx

[Jeff_Hager]

I used the same string of data that was include in the sample you linked to.

eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.
    eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0I
    joxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c

[Darko_Vukoje]

@Jeff_Hager

const decode = token => decodeURIComponent(atob(token.split('.')[1].replace('-', '+').replace('_', '/')).split('').map(c => `%${('00' + c.charCodeAt(0).toString(16)).slice(-2)}`).join(''));

return decode(p1);

Thanks, I recreated the column and pasted your code and it works fine now. Thanks!