with Neon Postgres and Attio?
Emit new event when a new column is added to a table. See the documentation
Emit new event when a list entry is deleted (i.e. when a record is removed from a list).
Emit new event when a row is added or modified. See the documentation
Emit new event when an existing list entry is updated (i.e. when a list attribute is changed for a specific list entry, e.g. when setting "Owner")
Emit new event when a new row is added to a table. See the documentation
Creates a new note for a given record. The note will be linked to the specified record. See the documentation
Creates or updates a specific record such as a person or a deal. If the record already exists, it's updated. Otherwise, a new record is created. See the documentation
Finds a row in a table via a lookup column. See the documentation
import { axios } from "@pipedream/platform";
import { neon } from "@neondatabase/serverless";
export default defineComponent({
props: {
neon_postgres: {
type: "app",
app: "neon_postgres",
}
},
async run({ steps, $ }) {
const { host, port, user, password, database } = this.neon_postgres.$auth
const connectionString = `postgresql://${user}:${password}@${host}:${port}/${database}`
const sql = neon(connectionString)
const result = await sql`SELECT version()`
const { version } = result[0]
return version
},
})
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
attio: {
type: "app",
app: "attio",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.attio.com/v2/self`,
headers: {
Authorization: `Bearer ${this.attio.$auth.oauth_access_token}`,
},
})
},
})