Question

Airtable / Zap — Manually Running Javascript Returns 0 Records

  • 28 July 2020
  • 1 reply
  • 40 views

I have the simple Javascript below which fetches a list of records from an Airtable view and it works just fine on my local environment. It also works fine when I am testing the Zap to fetch records. 

When I manually trigger this script however it shows the following message and says it couldn’t find any new items.

What I’m trying to do 
1. In airtable I have a “flag” and all records show up in a custom view
2. All the flagged records are synchronized with another platform
3. The flag is cleared in airtable and removed from the view. 

Thank you!
 

 

 

var settings = {

  'method': 'GET',

  'headers': {

    "Authorization": "Bearer XXXXXX",

  },

};

fetch('https://api.airtable.com/v0/XXXXXXXXXX/BASE/?view=VIEWNAME', settings)

.then(function(res) {

  return res.text();

})

.then(function(body) {

  body.toString();

  console.log();

  var jsonData = JSON.parse(body);

  var output = [];

      for (let i = 0; i < jsonData.records.length; i++)

      {

        if(jsonData.records[i])

          output.push(jsonData.records[i]);

      }

  callback(null, output);

})

.catch(callback);


1 reply

Userlevel 7
Badge +10

Hi @dan-ap! The ‘manual’ run for Zaps can be a little tricky as it depends on how the trigger app works, and the type of trigger. I’d recommend turning the Zap on and then making a change the relevant change in Airtable. If that triggers the Zap then you’re good to go!

 

If it doesn’t then you may need to reach out to the Support Team so that they can dig into your Zap with you, you can do that using the Get Help form. One thing to bear in mind is that the Support Team can’t help you with the specifics of the webhook, but they can take a look at our logs to see if it was sent and what message we may or may not have received from  Airtable in response, which should help you to debug things on your end. 

Reply