with Neon Postgres and Klaviyo?
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
Emit new event when new rows are returned from a custom query that you provide. See the documentation
Emit new event when a new table is added to the database. 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 Klaviyo API grants you the power to automate and personalize your email marketing efforts. With it, you can manage lists, profiles, and campaigns, track event-driven communications, and analyze the results. By leveraging this API on Pipedream, you can create intricate, automated workflows that respond in real-time to your users' behavior, sync data across multiple platforms, and tailor your marketing strategies to improve engagement and conversion rates.
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    klaviyo: {
      type: "app",
      app: "klaviyo",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: ` https://a.klaviyo.com/api/accounts/`,
      headers: {
        "Authorization": `Klaviyo-API-Key ${this.klaviyo.$auth.api_key}`,
        "revision": `2023-12-15`,
      },
    })
  },
})