MongoDB is an open source NoSQL database management program.
Create a new document in a collection of your choice. See the docs here
Create a new contact in Microsoft 365 People. See the documentation
Create a new contact folder in Microsoft 365 People. See the documentation
Execute an aggregation pipeline on a MongoDB collection. See the documentation
The MongoDB API provides powerful capabilities to interact with a MongoDB database, allowing you to perform CRUD (Create, Read, Update, Delete) operations, manage databases, and execute sophisticated queries. With Pipedream, you can harness these abilities to automate tasks, sync data across various apps, and react to events in real-time. It’s a combo that’s particularly potent for managing data workflows, syncing application states, or triggering actions based on changes to your data.
import mongodb from 'mongodb'
export default defineComponent({
props: {
mongodb: {
type: "app",
app: "mongodb",
},
collection: {
type: "string"
},
filter: {
type: "object"
}
},
async run({steps, $}) {
const MongoClient = mongodb.MongoClient
const {
database,
hostname,
username,
password,
} = this.mongodb.$auth
const url = `mongodb+srv://${username}:${password}@${hostname}/test?retryWrites=true&w=majority`
const client = await MongoClient.connect(url, {
useNewUrlParser: true,
useUnifiedTopology: true
})
const db = client.db(database)
const results = await db.collection(this.collection).find(this.filter).toArray();
$.export('results', results);
await client.close()
},
})
The Microsoft 365 People API lets you tap into your organization's contact data, providing access to people's info within your Microsoft 365 domain. With this API, you can search for users and contacts, discover relationships, and construct rich profiles that include contact information, organizational hierarchies, and photo URLs. On Pipedream, you can harness this API to automate contact management tasks, enhance CRM data, or trigger actions based on changes in your organization's personnel.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
microsoft_365_people: {
type: "app",
app: "microsoft_365_people",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://graph.microsoft.com/v1.0/me`,
headers: {
Authorization: `Bearer ${this.microsoft_365_people.$auth.oauth_access_token}`,
},
})
},
})