Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://datastation.multiprocess.io/docs/tutorials/Query_Airtable_with_DataStation.html below:

Airtable + SQL: Querying Airtable with DataStation

Requires DataStation 0.8.0+.

If you want to follow along with this tutorial verbatim, create a new base in Airtable and enter some basic data.

If you don't already have an Airtable API token, go to airtable.com/account, generate and save it.

Now inside DataStation create a new data source in the left sidebar.

Give it a nice name so you can easily find it later. And select Airtable in the Vendor dropdown.

Then enter your Airtable API token.

Now create a new panel and select the Database type. You can fill in Base ID, Table ID, and View ID manually or you can just paste your Airtable URL into the Base ID column and it will fill out the rest.

When querying Airtable you can leave the filter blank to select all rows or you can use Airtable's filter language to fetch only a subset of rows in a table.

Now that the data is loaded in DataStation we can use DataStation's scripting abilities to run a program using the Airtable data. We'll run a SQL program that counts the number of applied applicants.

Create a new Code panel, select SQL as the language, enter this query and hit run.

SELECT "Notes", COUNT(1) n FROM DM_getPanel(0) GROUP BY "NOTES"

From here you can generate graphs, do more analysis, or export results to a file or HTTP server.

See an error or want to add a clarification? This page is generated from this file on Github.

Last edited Jun 03, 2022.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4