What do you want to automate
with Microsoft 365 and Neon Postgres?
Prompt, edit and deploy AI agents that connect to Microsoft 365, Neon Postgres and 3,000+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Microsoft 365 and Neon Postgres Triggers#
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
Popular Microsoft 365 and Neon Postgres Actions#
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
Overview of Microsoft 365#
The Microsoft 365 API taps into the productivity power of services like Outlook, OneDrive, Excel, and more. It's a treasure chest for those seeking to automate office tasks, streamline communications, and orchestrate data between applications. With Pipedream, you can create workflows that react to events in the Microsoft ecosystem, manipulate data, or automate repetitive tasks, freeing you to focus on the bigger picture.
Connect Microsoft 365#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
microsoft_365: {
type: "app",
app: "microsoft_365",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://graph.microsoft.com/v1.0/me`,
headers: {
Authorization: `Bearer ${this.microsoft_365.$auth.oauth_access_token}`,
},
})
},
})
Connect Neon Postgres#
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
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies