Fetching Airtable data in Twilio Autopilot: How to display results to users?

Other Questions Airtable
1

I’m working on a Twilio Autopilot project where I need to grab info from Airtable and show it to users. Right now, I’m using Collect to get a date from the user (like Jan 31, 2019). I want to use this date to find the right row in my Airtable database. Then I need to tell the user what’s happening on that day (for example, ‘On Jan 31, the Main Theater is showing this movie, and the Other Theater is showing that movie’).

I’ve got some code to get data from Airtable, but I’m stuck on how to use the info it gives me. Here’s what I’ve got so far:

function handleAirtableData(context, event, callback) {
  const AirtableHelper = require('airtable-helper');
  const myBase = new AirtableHelper({ apiKey: 'secretkey' }).getBase('mybasekey');

  myBase.findRecord('MovieSchedule', 'rec123ABC', (error, data) => {
    if (error) {
      console.error('Oops:', error);
      return;
    }
    console.log('Got data:', data);
  });
}

Airtable sends back something like this:

{
  "recordId": "rec123ABC",
  "info": {
    "ShowDate": "2019-02-02",
    "BigScreen": "Space Adventure",
    "SmallScreen": "Superhero Saga"
  },
  "updatedAt": "2019-02-02T21:21:48.000Z"
}

How can I take this info and use it to tell the user what’s playing?

2

I’ve dealt with similar Airtable integration challenges before. One approach that worked well for me was using a Promise-based setup to handle the asynchronous nature of Airtable requests more smoothly. Here’s a snippet that might help:

function getMovieInfo(date) {
  return new Promise((resolve, reject) => {
    myBase.select({
      filterByFormula: `{ShowDate} = '${date}'`
    }).firstPage((err, records) => {
      if (err) {
        reject(err);
        return;
      }
      resolve(records[0].fields);
    });
  });
}

// In your main function:
getMovieInfo(userDate)
  .then(movieData => {
    const response = `On ${movieData.ShowDate}, catch '${movieData.BigScreen}' on the main screen and '${movieData.SmallScreen}' on the other screen.`;
    // Send this response to the user
  })
  .catch(error => {
    console.error('Error fetching movie data:', error);
    // Handle the error appropriately
  });

This approach gives you more flexibility in handling the data and potential errors. It also allows for easier integration with Twilio Autopilot’s response mechanisms.

3

hey jumpingrabbit, airtable data can be tricky. try using the data fields directly in ur response. like:

let msg = 'On ${data.info.ShowDate}, the Big Screen is showing ${data.info.BigScreen} and the Small Screen has ${data.info.SmallScreen}.'

then use msg in ur bot’s reply. hope this helps!

4

I’ve tackled a similar challenge in my Autopilot projects. The key is to structure your response within the callback function. Here’s a refined approach:

function handleAirtableData(context, event, callback) {
  const AirtableHelper = require('airtable-helper');
  const myBase = new AirtableHelper({ apiKey: 'secretkey' }).getBase('mybasekey');

  myBase.findRecord('MovieSchedule', 'rec123ABC', (error, data) => {
    if (error) {
      callback(null, 'Sorry, I couldn't fetch the movie information.');
      return;
    }
    
    const response = `On ${data.info.ShowDate}, you can watch '${data.info.BigScreen}' in the Main Theater and '${data.info.SmallScreen}' in the Other Theater.`;
    
    callback(null, response);
  });
}

This method ensures the bot responds with the formatted movie information once the data is retrieved from Airtable. Remember to adjust the record ID based on the user’s input date.