![]() These are the same names of the views as found in the UI.Ĭlick Privileges -> Add and add the new user (or an existing user) with the appropriate permissions. ViewNames : A comma separated list of views in the format of (table.view) names.These are the same names of tables as found in the UI. TableNames : A comma separated list of table names for the selected base.In the introduction section you can find "The ID of this base is appxxN2ftedc0nEG7." Click on Airtable API, or navigate to and select a base. To obtain this value, it is in the same section as the APIKey. To obtain this value, after logging in go to Account. ViewNames is an optional parameter where views of the tables may be specified. Select "Airtable" from Available Data Sources.Įnter the necessary authentication properties to connect to Airtable.ĪPIKey, BaseId and TableNames parameters are required to connect to Airtable. Login to Connect Server and click Connections. Leveraging server-side processing to quickly return the requested Airtable data.Ĭreate a Virtual SQL Server Database for Airtable DataĬData Connect Server uses a straightforward, point-and-click interface to connect to data sources and generate APIs. Using optimized data processing out of the box,ĬData Connect Server pushes all supported SQL operations (filters, JOINs, etc) directly to Airtable, ![]() Visualizations, PHP generates SQL queries to gather data. sqlsrv_connect.ĬData Connect Server provides a pure SQL Server interface for Airtable, allowing you to easily build reportsįrom live Airtable data in PHP - without replicating the data to a natively supported database. Follow the steps below to create a virtual SQL Server database for Airtable and connect toĪirtable data in real time through PHP's standard SQL Server interface, i.e. You can use CData Connect Server to access Airtable data from SQL Server clients, without needing to perform anĮTL or cache data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |