You can use CData Connect Cloud to query Airtable data through a MySQL interface. Follow the procedure below to create a virtual database for Airtable in Connect Cloud and start querying using Node.js.
Oct 09, 2018 Airtable is designed for people who want to organize their daily workflows in database form and is one of the best Work OS tools available. It's like a cross between Trello and Excel. Anyone who works in marketing, project management, ad agencies, and product experience teams will find the app useful. The difference here is that Airtable is designed with the database use case in mind. In Airtable, columns are 'fields' and rows are 'records.' When you click on a row, you can view the fields for the entire record. Each field is massively customizable, too. Airtable is more than a fancy spreadsheet. This app was made as a database tool as well. Whether you need to control your inventory, create a content calendar, or track your employee’s data, Airtable helps you visualize how your business is performing on one table.
CData Connect Cloud provides a pure MySQL, cloud-to-cloud interface for Airtable, allowing you to easily query live Airtable data in Node.js — without replicating the data to a natively supported database. As you query data in Node.js, CData Connect Cloud pushes all supported SQL operations (filters, JOINs, etc) directly to Airtable, leveraging server-side processing to quickly return Airtable data.
CData Connect Cloud uses a straightforward, point-and-click interface to connect to data sources and generate APIs.
APIKey, BaseId and TableNames parameters are required to connect to Airtable. ViewNames is an optional parameter where views of the tables may be specified.
With the virtual database created, you are ready to connect to Airtable data from any MySQL client.
The following example shows how to define a connection and execute queries to Airtable with the MySQL module. You will need the following information:
Connect to Airtable data and start executing queries with the code below: