Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 22, 2019 10:31 PM
When attempting to use the PATCH
method in Google Apps Script , I get an error INVALID_REQUEST_UNKNOWN
.
I’m able to do a POST
and GET
request. Tested my credentials using CURL and this worked. Tried the “HTTP Override” hack and that did not work.
function postToAirtable() {
var url = 'https://api.airtable.com/v0/appxs9P0mXsqcXs5R/Outreach';
var data = {
'fields': {
'Task': '<Task Name>',
'Outreacher': '<Person>',
'Month': 'May ',
'Status': 'In Progress',
'Go Live Date': '2016-03-01',
'Copy Card Link': [
'recONM5ul2oaG6yKi'
],
'Label': 'DET'
}
};
var headers = {'Authorization':'Bearer ' + '<API KEY>'};
var options = {
'contentType':'application/json',
'method' : 'PATCH',
'headers': headers,
// Convert the JavaScript object to a JSON string.
'payload' : JSON.stringify(data),
};
//Logger.log(options);
Logger.log(UrlFetchApp.fetch(url, options));
};
Solved! Go to Solution.
Aug 14, 2019 06:25 PM
I’m not entirely sure what you mean by this question. Care to expand your idea a little more?
Aug 14, 2019 10:02 PM
Google script use doGet function to load the htmlserver or the page. when the page was loaded, I want to load another page once i click the next button. Would it be possible?
Aug 15, 2019 08:06 AM
Yes - this is simply a matter of constructing the first (home) page to link to other pages. The “other” pages it links to either have to exist as separately rendered pages through the same doGet() method or they must exist on the web somewhere in a web server.
Another more elegant approach is to use javascript on the client (home page) to update that page dynamically using the DOM (document object model).
Aug 25, 2019 11:32 AM
Is it not possible to make a patch request using filterByFormula instead? I need to be able to make a patch request based on some other value in my table other than the record_ID…
Aug 26, 2019 06:53 AM
The API specifically states that record ID is required to update any Airtable record, so - no - this is not possible.
What is possible is how you implement the patch process. I believe this is exactly what the Airtable.js SDK does, although I do not use it myself. As I recall, the SDK has a method to leverage filter-like processes to narrow down the table items to be updated.
Doing this without the SDK is relatively simple -
To the best of my knowledge …
It’s unfortunate that the Airtable API requires us (all of us, even the SDK) to fetch all records from a table. Just because the SDK has a filterBy() method, it doesn’t mean the SDK is somehow more efficient than my described steps - it still needs to look at all the records before applying a patch.
I hope I am wholly misinformed about this and would rejoice in being wrong. :winking_face: