Help

Query a Linked Table

Topic Labels: API
1606 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Maiya_O1
5 - Automation Enthusiast
5 - Automation Enthusiast

I looked at the API docs and did not see anything about how to query a linked table. Does anyone know how to do that and/or where I can find out how to do that?

For example, in a situation like this:

var Airtable = require('airtable');
var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('apptDndoI6VkAx3Ko');

base('projects').find('recAurDC0RVIB2GFU', function(err, record) {
    if (err) { console.error(err); return; }
    console.log('Retrieved', record.id);
});

Say that projects were linked to another table called “tasks” - How would you find all of the tasks that belong to that project?

Is there a way to do it with curl? Where is there a list of more advanced query methods? Such as “base-url?limit=10&offset=3”
to do something like pagination, etc?

Thanks for any pointers!

2 Replies 2

@Maiya_O1 - as your tables are linked, the project record id will be in the tasks table (on each task record), so you will need to make another call to the tasks table and filter the result set by the project record id.

Thank you for this answer.