Confection
Confection collects, stores, and distributes data in a way that's unaffected by client-side disruptions involving cookies, cross-domain scripts, and device IDs. It's also compliant with global privacy laws so it’s good for people too.
Integrate the Confection API with the Airtable API
Setup the Confection API trigger to run a workflow which integrates with the Airtable API. Pipedream's integration platform allows you to integrate Confection and Airtable remarkably fast. Free for developers.
Popular Ways to Connect Confection with Airtable#
Popular Confection and Airtable Triggers#
Emit new event when a UUID receives a value for the configured Event Name. The latest value as well a history of all values ever received for that Event Name will be returned.
Emit new event when the UUID is significant enough to be classified as a lead. You define the field of significance and if a UUID gets a value for this field, it will trigger.
Emit new event when any UUID is created or updated. To learn more about how Confection handles UUIDs, visit https://confection.io/main/demo/#uuid.
Emit an event for each new or modified record in a table
Emit an event for each new or modified record in a view
Popular Confection and Airtable Actions#
This action will retrieve the full details of a specified UUID.
This action will retrieve all UUIDs that have a likeness score of at least 50 (default) with the provided UUID. The likeness score can be customized in configuration.
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.
Overview of Confection#
Confection is an API that enables you to easily create and manage serverless
functions. Using Confection, you can deploy your functions to any number of
providers, including AWS Lambda, Google Cloud Functions, and Azure Functions.
Confection also provides a convenient command-line interface, making it easy to
manage your functions from your terminal.
Connect Confection#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
confection: {
type: "app",
app: "confection",
}
},
async run({steps, $}) {
const data = {
"key": `${this.confection.$auth.secret_key}`,
}
return await axios($, {
url: `https://transmission.confection.io/${this.confection.$auth.account_id}/account/`,
data,
})
},
})
Overview of Airtable#
Using the Airtable API, you can build applications that can:
- Create and manage databases
- Add, update, and delete records
- Search for records
- Sort and filter records
- Display records in a variety of ways
- Import and export data
Connect Airtable#
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
},
})
Community Posts#
