with Neon Postgres and Zoho CRM?
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
Emit new event when a new row is added to a table. See the documentation
Emits an event each time a new contact is created in Zoho CRM
Emit new event when new rows are returned from a custom query that you provide. See the documentation
Converts a Lead into a Contact or an Account. 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
},
})
The Zoho CRM API enables the manipulation and retrieval of data within Zoho CRM, a platform for managing your sales, marketing, support, and inventory in a single system. Leveraging this on Pipedream, you can automate tasks like syncing contacts, updating lead statuses, or creating custom CRM operations that trigger actions in other apps. Pipedream's serverless platform allows for real-time data processing, transforming, and orchestrating workflows that respond to events in Zoho CRM with minimal latency.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoho_crm: {
type: "app",
app: "zoho_crm",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.zoho_crm.$auth.api_domain}/crm/v2/users?type=CurrentUser`,
headers: {
"Authorization": `Zoho-oauthtoken ${this.zoho_crm.$auth.oauth_access_token}`,
},
})
},
})