Help

Airtable script fetch put

Topic Labels: Scripting extentions
3692 14
cancel
Showing results for 
Search instead for 
Did you mean: 
ALA_Staff
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

Is there such thing as a fetch put? I am needing to do a put on an external api with the airtable scripting app. I was wondering what the best way to do it is? The external api is expecting a put method. I have successful used fetch for get and post but can’t seem to figure out the put. Thanks in advance!

14 Replies 14

Hi @ALA_Staff, and welcome to the community!

Yes. Something like this…

let putURL = "https://...";

let putOptions = {
    method: "PUT",
    headers: {
        'Accept' : 'application/json',
    },
}
const putResults  = await remoteFetchAsync(putURL, putOptions);
const jsonObject    = await putResults.json();

output.inspect(jsonObject);
ALA_Staff
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for responding, Bill.

I’ve tried your suggestion. Here is my code.

        let putUrl = "https://...";
        let putOptions = (putBody) => {
            return {
            method: "PUT",
            headers : {
                "accountid":"...",
                "applicationkey": "...",
                "Accept": "application/json"
            },
            body:putBody
            }
        }
        console.log("pre put");
        let putResults = await remoteFetchAsync(putUrl, putOptions(JSON.stringify(prod)));
        let jsonObject = await putResults.json();
        output.inspect(jsonObject);

It runs up until the fetch call. the last thing that prints is “pre put”. I’ve tried this with postman and it works there. Just can’t seem to get it working with the script. Am I missing something? Thanks again

Yes. But I do not know what it might be.

There are three scripting environments in Airtable - where [exactly] are you trying to run this script?

I am using the Scripting App, downloaded from the Airtable apps Marketplace

I would post the exact postman request header here so we can see the pattern that workers with your api.

ALA_Staff
5 - Automation Enthusiast
5 - Automation Enthusiast

Screen Shot 2021-02-11 at 11.38.06 AM

ALA_Staff
5 - Automation Enthusiast
5 - Automation Enthusiast

here is the api documentation as well. DEAR Developer Portal · Apiary

From the docs, it says accountid, appkey, and content-type are the only required headers. it’s odd because i have the get and post calls working in the same script

And yet, that is missing from your code - I would try adding that to see what happens.

No luck, i’ve tried that in the past and just now. Still didn’t work. stops at the same spot