Example Twilio function to query Firebase Firestore and return result

query_firebase.js

const axios = require('axios');

exports.handler = async (context, event, callback) => {

  // The event object should include any parameters from Twilio Studio
  // as event.<parameter>
  console.log(`Query_firebase function running. Event:`);
  console.log(event);
  
  try {
    const response = await axios.post(
      `https://firestore.googleapis.com/v1beta1/projects/georgia-courtbot/databases/(default)/documents:runQuery`,
      { structuredQuery:
        {
          from: [{ collectionId: 'users' }],
          where: { 
            fieldFilter: { 
              field: { 
                fieldPath: 'phone' 
              }, 
              op: 'EQUAL', 
              value: { 
                stringValue: event.phone.trim()
              } 
            }
          }, 
          limit: 1
        }
      });

    console.log(`Response data from firebase:`);
    console.log(response.data)

    // Assume we get at most one document back
    if (response.data[0].document) {
      return callback(null, {
        user_exists: true,
        user_fields: response.data[0].document.fields
      });
    } else {
      return callback(null, {user_exists: false})
    }
  } catch (error) {
    console.log(error);
    return callback(error);
  }
};