Retrieve records from different tables

[Savio_Sousa]

Hi all,
I´m trying to integrate Airtable with Appgyver using the Airtable API.

I need to retrieve some fields from different tables based on an unique value (the company id) which is not the record id.

Is it possible? Can I retrieve different fields from different tables based on the company id instead of the record id ? How can I do that?

[Bill_French]

Savio_Sousa:

Can I retrieve different fields from different tables based on the company id instead of the record id ?

Yes. The filterByFormula method will do that. You can also create views in Airtable to provide your integration with pre-filtered collections of records or even a single record.

Airtable Support

How do I sort, filter, or retrieve ordered records in the API?

To retrieve records in the same order as they appear in a specific table view, you can pass in the "view" parameter in the list records request (see the API docs). Additionally, you can filter and ...