with Neon Postgres and Spotify?
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
Add one or more items to a user’s playlist. See the docs here
Create a playlist for a Spotify user. The playlist will be empty until you add tracks. See the docs here
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 Spotify API on Pipedream offers a creative playground for music lovers and developers alike. With it, you can manage playlists, search for music, get recently played tracks, and manipulate playback among other features. It's a gateway to a rich dataset of music and user information, enabling the creation of personalized and dynamic music experiences.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
spotify: {
type: "app",
app: "spotify",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.spotify.com/v1/me`,
headers: {
Authorization: `Bearer ${this.spotify.$auth.oauth_access_token}`,
},
})
},
})