with Cloze and Neon Postgres?
Emit new event when significant changes regarding a company are detected. See the documentation
Emit new event when significant changes happen to a person. See the documentation
Emit new event when a significant change occurs in a project. See the documentation
Emit new event when a new column is added to a table. See the documentation
Emit new event when a row is added or modified. See the documentation
Create a new company or enhance an existing company within Cloze. Companies can be created with just a domain name or both a name and another unique identifier such as a phone number and email address. See the documentation
Finds a row in a table via a lookup column. See the documentation
The Cloze API enables you to access and manage your Cloze CRM data programmatically. In Pipedream, you can create powerful, serverless workflows that react to events or run on schedules to automate tasks involving Cloze data. You could synchronize contacts, track communication history, or trigger actions based on updates in Cloze. By leveraging Pipedream's capacity to connect to a myriad of services, you can create multi-step workflows that involve other apps to streamline your business processes and harness the full potential of CRM automation.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
cloze: {
type: "app",
app: "cloze",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.cloze.com/v1/profile`,
headers: {
Authorization: `Bearer ${this.cloze.$auth.oauth_access_token}`,
},
})
},
})
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
},
})