I am building a web application for my students using Node.js/Express that displays information from an Airtable base. Instead of embedding a table of news stories, I want to pull several fields from the table and insert them into the DOM so I can design the display of information.
I've been able to send 3, 5, 10 stories to the console, but when I try to send a second story to display on a web page, I keep running into this error:
TypeError: Cannot read properties of undefined (reading 'offset')
which points to part of airtable.js that compares result.offset with params.offset.
I've tried to find an offset in the json but I don't see the key or values beginning with itr.
I tried to call record.offset but it is undefined.
Several community posts about offset explain how to find more than the maximum 100 records, but I'm getting stuck on the second record.
I found Offset property missing in API response as an open issue on Github from 2021, so maybe there's no way to do this, but I'm hopeful there is a way forward.
This is the relevant part of my Express script:
app.get('/api/stories', (req, res) => {
base(table).select({
maxRecords: 10,
view: view
}).eachPage(function page(records, fetchNextPage) {
records.forEach(function(record) {
console.log('Retrieved', record.get('Happened'), record.get('Created By').name);
// TODO: something is breaking here the second time through. Offset is undefined and it matters only the second time.
res.json({
'Happened': record.get('Happened'),
'Created By': record.get('Created By').name,
});
});
fetchNextPage();
}, function done(err) {
if (err) { console.error(err); return; }
});
});
Thanks for your help!
