Zoho Analytics
Self-service BI & Analytics Software
Integrate the Zoho Analytics API with the MongoDB API
Setup the Zoho Analytics API trigger to run a workflow which integrates with the MongoDB API. Pipedream's integration platform allows you to integrate Zoho Analytics and MongoDB remarkably fast. Free for developers.
Popular Zoho Analytics and MongoDB Actions#
Create a new document in a collection of your choice. See the docs here
Execute an aggregation pipeline on a MongoDB collection. See the documentation
Overview of Zoho Analytics#
The Zoho Analytics API lets you harness the power of your data by automating complex analytics tasks. With this API, you can create, access, and manage reports, dashboards, and KPI widgets programmatically. Integrate with Pipedream's serverless platform to trigger actions based on events, sync data across apps, and automate workflows without managing servers. Whether it's updating datasets in real-time or sending reports to your team, the possibilities stretch as wide as your data does.
Connect Zoho Analytics#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoho_analytics: {
type: "app",
app: "zoho_analytics",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.zoho_analytics.$auth.base_api_uri}/restapi/v2/orgs`,
headers: {
"Authorization": `Zoho-oauthtoken ${this.zoho_analytics.$auth.oauth_access_token}`,
"ZANALYTICS-ORGID": `${this.zoho_analytics.$auth.organization_id}`,
},
})
},
})
Overview of MongoDB#
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.
Connect MongoDB#
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()
},
})