With Airplane, you can build high-quality internal tools fast. Airplane’s development environment includes two fundamental building blocks: with tasks, you can execute SQL queries, query APIs, or run code. And with views, you can write React components that interact with tasks, like pulling data from SQL queries or using form data as input to a workflow.
.task.yaml
) and the SQL query associated with the task (ending in .sql
).
Step 3: Write your SQL query. For example, here’s a Salesforce query that finds all the Salesforce Contacts belonging to a given account:
:account_id
. You can bind a task parameter to :account_id
in the task definition:
account_id
as the argument. As a test, you can run a task at any time by selecting it in the file browser (tasks have the lightning bolt icon).
Once your tasks are ready, you can create React components that interface with them. You can create a new view from scratch by clicking the ”+” button in the file browser. Or you can start with one of Airplane’s many templates.
For example, to populate Airplane’s Table
React component with the results of a task, you set the table’s task
property to the slug of the task:
insert
query by populating values
with various input fields in your application. Assuming the task binds parameters such as :first_name
and :last_name
, here’s what inserting to a Salesforce Contact table would look like:
Form
component:
mutate
when the user clicks “Submit.” You can define your mutate
function at the top of the component:
mutate
function, you can add an onError
callback like this: