How can I do a basic lookup on Airtable using Node js?

Hi @J_Mai, and welcome to the community!

And yet, with an insight into what you’re trying, community helpers will be able to avoid wasting their own time starting from scratch. I recommend you share ALL your details if you want to get people to help you. If not, take a look at this.

Okay, great point @Bill.French. Here’s the code.

var carolNumber = "(454) 382-9029"

base('Table1').select(
    {
      maxRecords: 3,
      view: 'Grid view'
    }
  ).firstPage(function page(err, records)
    {
      if (err) { console.error(err); return;  }
      records.forEach(function(record) {
          if(record.get('Phone Number') = carolNumber)
          {
          console.log('Lookup is', record.get('Full Name'));
          }
        });
      });

var carolNumber = "(454) 382-9029"

base('Table1').select(
    {
      maxRecords: 3,
      view: 'Grid view'
    }
  ).firstPage(function page(err, records)
    {
      if (err) { console.error(err); return;  }
      records.forEach(function(record) {
          if(record.get('Phone Number') === carolNumber)
          {
          console.log('Lookup is', record.get('Full Name'));
          }
        });
      });

// Returns "Lookup is Carol Lerner"

Glad you got it working.

That’s like saying…

I wish Airtable documented every aspect of javascript.

That would be vast and it’s really not Airtable’s job to document the entirety of javascript. Working with script resources in every platform comes with a certain degree of knowledge and while this doesn’t lessen the anguish of learning (for the first time) that an “=” operator is how one assigns values, it’s one of those very essential concepts in software engineering that are best learned in class or in tutorials.

Thank you! Yeah, I agree. But beefing up the Airtable docs a bit would help.

Spent at least 6 hours between today and yesterday just trying to figure out how to call Airtable on a serverlerss cloud function. I still don’t totally know if I’m doing it right, but at least I was able to make a call and return a table. Didn’t realize I needed this require (‘request-promise’) thing to actually speak to the airtable API on a serverless set up.

I kept searching on Google for things like:

“how to call airtable functions when outside of local machine api”
“how to add airtable library to browser”
“import airtable library api”
“how to call airtable api in serverless”
“how to run new require(‘airtable’) on server”
“how do i communicate with airtable api using cloud functions”
“how to call airtable api using node js”
“how to initialize airtable in aws lambda”
“call an api using node js”

None of those really got to the answer. But I learned a bunch and it only took two days :laughing:

Figured out that I needed to use a library that’s built into node js called “request-promise” that I could call from my cloud functions service. This also explained why I could call the Airtable API fine on my computer, but could not call it on the cloud functions service I’m using.

Here’s the code for posterity in case others run into any of the same searches above to try to call the Airtable API from a serverless tool like Google Cloud Functions, AWS Lambda, IBM Cloud Functions, or Azure Functions.

let rp = require('request-promise')

function main(params) {
    const options = {
        url: "https://api.airtable.com/v0/appumWMhUzhgN8fFe/Table1?api_key=XXXXXXXXXX",
        json: true
    }
    return rp(options)
    .then(res => {
        return { response: res }
    })
}
///returns a JSON file with my table of data

I know there are other ways to do this, but I haven’t figured those out yet.

It has been about 15 years since my last formal class in computer science, I understand @Bill.French you’re a self-taught person as well, having read some other replies in this community. So thanks for the encouragement. I admit I did make the newbie mistake of = being different than == or ===.

let rp = require('request-promise')

function main(params) {
    const options = {
        url: "https://api.airtable.com/v0/appumWMhUzhgN8fFe/Table1?api_key=XXXXXXXXXX",
        json: true
    }
    return rp(options)
    .then(res => {
        return { response: res }
    })
}
///returns a JSON file with my table of data

Ha ha - welcome to the world of software integration.

No one does.

You’re an expert now (of sorts). :winking_face:

This all depends on the scripting engine. NodeJS is a non-blocking architecture as compared to Google Apps Script v8 engine which is capable of blocking and non-blocking execution. I prefer Google Apps Script because I can be lazy and simple and fast.

That’s 190 days fewer than most. Ask any golfer what the first two days were like.