Customer-Facing Analytics
Emit an event for each new or modified record in a table
Emit an event for each new or modified record in a view
Emits an event each time a record is added, updated, or deleted in an Airtable table. Supports tables up to 10,000 records
Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs.
Retrieve records from a table with automatic pagination. Optionally sort and filter results.
Retrieve records in a view with automatic pagination. Optionally sort and filter results.
Datawaves is a powerful API that enables developers to easily and efficiently
access data from a variety of sources. With Datawaves, you can easily connect
to and query data from popular data sources such as Amazon Redshift, Google
BigQuery, and Microsoft SQL Server.
In addition, Datawaves provides a number of features that make it easy to work
with data, including:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
datawaves: {
type: "app",
app: "datawaves",
}
},
async run({steps, $}) {
const data = {
"id": `123`,
"product": `iPhone Charger`,
}
return await axios($, {
method: "post",
url: `https://datawaves.io/api/v1.0/projects/${this.datawaves.$auth.project_id}/events/test`,
headers: {
"Authorization": `${this.datawaves.$auth.secret_key}`,
},
data,
})
},
})
Using the Airtable API, you can build applications that can:
module.exports = defineComponent({
props: {
airtable: {
type: "app",
app: "airtable",
},
baseId: {
type: "$.airtable.baseId",
appProp: "airtable",
},
tableId: {
type: "$.airtable.tableId",
baseIdProp: "baseId",
},
},
async run({steps, $}) {
const Airtable = require('airtable');
const base = new Airtable({apiKey: this.airtable.$auth.api_key}).base(this.baseId);
const data = []
await base(this.tableId).select({
// pass optional config parameters here
}).eachPage(function page(records, fetchNextPage) {
// This function (`page`) will get called for each page of records.
records.forEach(function(record) {
data.push(record._rawJson)
});
// To fetch the next page of records, call `fetchNextPage`.
// If there are more records, `page` will get called again.
// If there are no more records, `done` will get called.
fetchNextPage();
})
return data
},
})