with Close and Neon Postgres?
Emit new event when the configured types of events are triggered. See all possibilities
Emit new event when a new column is added to a table. See the documentation
Makes an arbitrary call to the Close API. See the documentation for all options.
Finds a row in a table via a lookup column. See the documentation
The Close API provides access to a robust CRM platform, enabling users to automate sales processes, manage leads, and track communication history. Harnessing the Close API within Pipedream's ecosystem allows for the creation of custom, serverless workflows that can react in real-time to events, synchronize data across apps, and streamline sales operations. By leveraging Pipedream's capabilities, you can trigger actions based on Close events, manipulate Close data, and integrate with countless other services to amplify your CRM's functionality.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
close: {
type: "app",
app: "close",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.close.com/api/v1/me/`,
auth: {
username: `${this.close.$auth.api_key}`,
password: ``,
},
})
},
})
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
},
})