with WisePops and Neon Postgres?
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
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 WisePops API unlocks potent possibilities for automating pop-up and banners management on your website. By integrating WisePops with Pipedream, you can streamline workflows such as syncing lead data to CRM platforms, personalizing visitor engagement based on real-time analytics, and dynamically updating marketing campaigns. The API's ability to fetch, update, create, and delete pop-ups enables developers to orchestrate sophisticated marketing automation that reacts to customer behavior and data-driven insights.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
wisepops: {
type: "app",
app: "wisepops",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://app.wisepops.com/api2/contacts`,
headers: {
"Authorization": `WISEPOPS-API key="${this.wisepops.$auth.api_key}"`,
},
})
},
})
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
},
})