Jul 28, 2022 02:58 AM
Is it possible to create and sign JWT inside Airtable Scripting?
It is an authorization step required for making API calls.
Jul 28, 2022 09:21 AM
Can someone help on this topic?
Jul 28, 2022 07:40 PM
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:
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.
Jul 30, 2022 04:23 AM
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.
Jul 30, 2022 08:33 AM
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.
Aug 01, 2022 11:11 PM
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:
Let me know if it’s helpful!