with SupportBee 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
SupportBee's API hooks into its customer support ticketing system, allowing for programmatic ticket management, reporting, and collaboration. With Pipedream, you can leverage this API to automate responses, escalate issues based on keywords, or sync with other tools to streamline your support workflow.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
supportbee: {
type: "app",
app: "supportbee",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.supportbee.$auth.domain}.supportbee.com/users`,
headers: {
"Content-Type": `application/json`,
"Accept": `application/json`,
},
params: {
auth_token: `${this.supportbee.$auth.api_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
},
})