Create and Sign JWT in Airtable Scripting

[ruby_rails]

Hi everyone,

Is it possible to create and sign JWT inside Airtable Scripting?
It is an authorization step required for making API calls.

Thanks.

[ruby_rails]

Can someone help on this topic?

Best,
Sharjeel.

[Justin_Barrett]

Welcome to the community, @ruby_rails! :grinning_face_with_big_eyes: Before getting to your topic, I would recommend waiting more than a few hours before “bumping” a request for help. While this is a somewhat active forum, everyone reads and response on their own timeline, and such a short delay before a bump comment can come across as demanding. Patience is always key when engaging in online communities like this. :slightly_smiling_face:

To your question, I’m not familiar with JWTs, but a quick search gave me a rough idea of what a JWT is and how one is created. Based on that, I’m not certain that it’s possible to create a JWT with the specific “flavor” (couldn’t think of a better word) of JavaScript that Airtable’s scripting APIs provide. While most JavaScript features are available, a few have been blocked for various reasons (security probably being pretty high on the list).

What API are you trying to access? The image you attached refers to Google’s API, but I didn’t want to assume too much from the image.

[ruby_rails]

Thanks Justin, for reaching out,
My objective is to get data from the Gmail API using service account credentials.
Firstly, We need to use those service account credentials to create a JWT token and make a request to the google with that token, which will return us the Access_token. This Access token is valid for 30 mins and can be used to make an API calls to the Gmail API.
And the main hurdle here is to create JWT using the service account credentials from google.

Thanks.

[Justin_Barrett]

Thanks for the update. As I said above, I’ve got no personal experience with JWTs, and I don’t have the bandwidth right now to dive into it and see what’s doable (or not) from Airtable’s scripting environments. If anyone else can jump in and help, please do!

You might also consider posting to the #developers:work-offered category if you’d like to hire a consultant to help with this project. If you do this, I recommend linking to this thread so that you don’t have to repeat what you’ve already written, which lays out your goal pretty clearly.

[ChrisDrit]

ruby_rails:

Is it possible to create and sign JWT inside Airtable Scripting?
It is an authorization step required for making API calls.

Gosh, I don’t know if this can be done within Airtable.

I did something like this using Integromat (now Make) that calls an AWS serverless function to verify a signed JWT.

It’s a multipart video tutorial, here’s where I go over that step:

nocodequest.com

Secure File Downloads with Webflow and MemberStack

Why can't I prevent gated content from being downloaded? Welp, now you can, and here's exactly how...

Let me know if it’s helpful!