
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 11, 2021 05:13 AM
I am wrote code (below) inside a Twilio function which utilizes the Airtable API which first looks up a record in specific table (“clients”) in an Airtable base. It then pulls field data from that record (using record.get), and then using JSON in the “Callback”, enables me to utilize that field data later on in my Studio flow. It works perfectly.
What I’m trying to figure out now is how to reverse that procedure. I’d like, once again, to first find the Airtable record. But then, instead of using “record.get” to pull field data in; I would like to write/update fields back into that Airtable record.
In other words, after the line that reads:
“if (record.get(“Client_ID”) === clientnumber)”
instead of the two record.get commands that pull data from the fields, what would the code be to write data (say just a literal string) back to those two fields?
Thanks in advance for any help you might provide!
My Function Code to Fetch Airtable Data Into My Studio Flow
const airtable = require(“airtable”);
const twilio = require(“twilio”);
exports.handler = function (context, event, callback) {
const base = new airtable({
apiKey: context.AIRTABLE_API_KEY,
}).base(context.AIRTABLE_BASE_ID);
const clientnumber = event.clientphone;
return base(“Clients”)
.select()
.all()
.then((records) => {
records.forEach((record) => {
if (record.get(“Client_ID”) === clientnumber) {
const bussname = (record.get(“Business Name”));
const email1 = (record.get(“NEmail1”));
callback(null,{“business”:bussname,“remail1”:email1});
}
});
})
.catch((error) => {
callback(error);
});
};

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 14, 2021 10:37 AM
Don’t you just need to use the Update Record on the Airtable API?
Also - might help to use ``` to format your code when copying and pasting snippets. Just a suggestion hope that helps.
