Netlify Function and Airtable - 502 Gateway

Hello! Really excited to get some help here.

I’ve deployed a netlify function that successfully runs on my local server. However, once deployed, I’ve started receiving a 502 gateway error pretty much instantly (i don’t think its timing out).

The way my code works is that my app checks for certain parameters in the url. The url that I have been practicing with is . These parameters are sent to netlify via a POST request. Then, netlify parses the request and checks Airtable to see if these values exist within my database. These values do exist in my database and when ran locally will return the desired information. What I’ve found based on the function log is that the “await…” function is not being called or at least breaks down at that point.

Here is a snip of my netlify code:

const fetch = require("node-fetch")

const Airtable = require("airtable")

const handler = async (event , context, callback) => {
// Configure Airtable base connection
const base = new Airtable({ apiKey: process.env.AIRTABLE_API_KEY }).base(
// Configure table name
const table = base(process.env.AIRTABLE_TABLE_NAME)
  // this is where the function starts, the url paramters are parsed and saved as fields 
  try {
    const { httpMethod } = event
    let fields = JSON.parse(event.body)
    const { tagId, eCode, enc, cmac } = fields
   // the fields are posted correctly in the netlify function log
    // the date the function was ran is saved as an ISOString
    const triggeredDate = new Date()
    const triggeredTimestamp = triggeredDate.toISOString()
    // the triggered date is posted correctly in the netlify function log

    // Only allow POST methods
    if (httpMethod !== "POST") {
      return {
        statusCode: 405,
        body: JSON.stringify({ message: "Method Not Allowed" })
    } else if (!tagId || !eCode || !enc || !cmac) {
      return {
        statusCode: 400,
        body: JSON.stringify({ message: "Bad Request" })
    console.log("made it here netlify")
    // this console log is posted correctly in the netlify function log
    // each url parameter is saved as its own constant to be checked against Airtable
    const fieldTagId = 'tagId'
    const fieldECode = 'eCode'
    const fieldENC = 'enc'
    const fieldCMAC = 'cmac'
    // this function checks any record/row in Airtable has exactly all four values
    await table
        filterByFormula: `AND({${fieldTagId}} = ${tagId}, {${fieldECode}} = ${eCode}, {${fieldENC}} = ${enc}, {${fieldCMAC}} = ${cmac})`,
      .all(function(err, records) {
     if (err) { 
     // this console command does not appear and I believe this is where the code is breaking down
     // if there is a record with all four values, the timestamp of when the function was triggered is compared to the timestamp within Airtable
    if (records && records.length >= 1) {
        records.forEach(function(record) {
        const airtableTimestamp = record.get('createdTime')
        console.log('Retrieved', airtableTimestamp);
        const d1 = new Date(airtableTimestamp);
        const d2 = new Date(triggeredTimestamp);
        const timeDif = d2 - d1
        // if the time difference is greater than 30 minutes, then the "Rune Decayed" response is returned to App.js  
        if ((timeDif) > 30 * 60 * 1000) {
          console.log("old rune")
          return {
            statusCode: 202,
            body: JSON.stringify({ message: "Rune Decayed"})
        // if the time difference is less than 30 minutes, then the "Authentic" response is returned to App.js
        } else {
            return {
              statusCode: 202,
              body: JSON.stringify({ message: "Authentic" })

    // if there is not a record within Airtable that has all exactly all four paramters, then these parameters are sent to the ETRNL API - etrnlAuth() -- IGNORE THIS, NOT RELEVANT TO CURRENT ISSUE
    } else {
      console.log("No records of paramters found")
      console.log("Sending paramters to ETRNL API for authentication")
      etrnlAuth(tagId, eCode, enc , cmac, base, table);


  } catch (error) {
    return { 
      statusCode: 500, 
      body: "Oops! Something went wrong." }

Here is a snip of the error from my console log:
the rune-auth.js function seems to last only 680 ms?

My code operates normally on my local machine and will return the records information I request after the “await” function runs. I’m beginning to think its the await aspect not being triggered? Any help would be great! Please let me know if you need more information.

And here is the output from the function log in netlify:

Hi @wilkinson1bryan

Still trying to surface the issue, but one thing you could try out of the box is changing the AWS runtime + build node version to match whatever version you have locally:

Particularly the environment variables:




Hope this helps!