with Intercom and Neon Postgres?
Finds a row in a table via a lookup column. See the documentation
Finds a row in a table via a custom query. See the documentation
The Intercom API offers rich capabilities for enhancing customer communication and support workflows. By leveraging this API on Pipedream, you can automate tasks, sync customer data across platforms, and create personalized interactions. Whether you are managing user segments, sending targeted messages, or updating customer profiles, the Intercom API's robust set of endpoints allows for intricate and useful automations within your business processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
intercom: {
type: "app",
app: "intercom",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.intercom.io/me`,
headers: {
Authorization: `Bearer ${this.intercom.$auth.oauth_access_token}`,
"accept": `application/json`,
},
})
},
})
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
},
})