The distributed serverless database combining the flexibility of NoSQL with the relational querying capabilities of SQL systems.
Emit new event each time you add or remove a document from a specific collection, with the details of the document.
Emit an event for each new or modified record in a table
Emit an event for each new or modified record in a view
Performs an arbitrary authorized GraphQL query. See docs here
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.
module.exports = defineComponent({
props: {
faunadb: {
type: "app",
app: "faunadb",
}
},
async run({steps, $}) {
const faunadb = require('faunadb')
const q = faunadb.query
const client = new faunadb.Client({ secret: this.faunadb.$auth.secret })
// Lists collections in the database tied to your secret key
const collectionsPaginator = await client.paginate(q.Collections())
this.collections = []
await collectionsPaginator.each(page => {
for (const collection of page) {
this.collections.push(collection.id)
}
})
},
})
Using the Airtable API, you can build applications that can:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
airtable: {
type: "app",
app: "airtable",
},
baseId: {
type: "$.airtable.baseId",
appProp: "airtable",
},
tableId: {
type: "$.airtable.tableId",
baseIdProp: "baseId",
},
},
async run({steps, $}) {
return await axios($, {
url: `https://api.airtable.com/v0/${this.baseId}/${this.tableId}`,
headers: {
Authorization: `Bearer ${this.airtable.$auth.api_key}`,
"accept": `application/json`,
},
})
}
})