with Vtiger CRM and Google Cloud?
Inserts rows into a BigQuery table. See the docs and for an example here
Creates a scheduled query in Google Cloud. See the documentation
Gets Google Cloud Storage bucket metadata. See the docs
Downloads an object from a Google Cloud Storage bucket, See the docs
The Vtiger CRM API lets you tap into your customer relationship data to create, read, update, and delete records across various entities such as contacts, leads, and opportunities. In Pipedream, you can leverage this API to automate workflows, sync data across platforms, and react to events in real-time, all without the need for dedicated backend code. You can create dynamic workflows that respond to webhooks, schedule tasks, and integrate with 1000+ apps readily available on Pipedream.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
vtiger_crm: {
type: "app",
app: "vtiger_crm",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.vtiger_crm.$auth.instance}.vtiger.com/restapi/v1/vtiger/default/me`,
auth: {
username: `${this.vtiger_crm.$auth.username}`,
password: `${this.vtiger_crm.$auth.access_key}`,
},
})
},
})
The Google Cloud API opens a world of possibilities for enhancing cloud operations and automating tasks. It empowers you to manage, scale, and fine-tune various services within the Google Cloud Platform (GCP) programmatically. With Pipedream, you can harness this power to create intricate workflows, trigger cloud functions based on events from other apps, manage resources, and analyze data, all in a serverless environment. The ability to interconnect GCP services with numerous other apps enriches automation, making it easier to synchronize data, streamline development workflows, and deploy applications efficiently.
module.exports = defineComponent({
props: {
google_cloud: {
type: "app",
app: "google_cloud",
}
},
async run({steps, $}) {
// Required workaround to get the @google-cloud/storage package
// working correctly on Pipedream
require("@dylburger/umask")()
const { Storage } = require('@google-cloud/storage')
const key = JSON.parse(this.google_cloud.$auth.key_json)
const storage = new Storage({
projectId: key.project_id,
credentials: {
client_email: key.client_email,
private_key: key.private_key,
}
})
await storage.authClient.getCredentials()
return {
status: "success",
authenticated: true,
projectId: key.project_id,
serviceAccount: key.client_email
}
},
})