The Google Cloud Platform, including BigQuery
Inserts rows into a BigQuery table. See the docs and for an example here.
Creates a scheduled query in Google Cloud. See the documentation
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)
// Creates a client from a Google service account key.
// See https://cloud.google.com/nodejs/docs/reference/storage/1.6.x/global#ClientConfig
const storage = new Storage({
projectId: key.project_id,
credentials: {
client_email: key.client_email,
private_key: key.private_key,
}
})
// Uncomment this section and rename for your bucket before running this code
// const bucketName = 'pipedream-test-bucket';
await storage.createBucket(bucketName)
console.log(`Bucket ${bucketName} created.`)
},
})
The Joomla! API provides a powerful way to interact with the Joomla! content management system programmatically. With this API, you can automate content creation, user management, and site maintenance tasks. Pipedream’s serverless platform enhances these capabilities, allowing you to create workflows that trigger on specific events, process data, and integrate with countless other services to extend the functionality of your Joomla! site.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
joomla: {
type: "app",
app: "joomla",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.joomla.$auth.joomla_host_domain}/api/index.php/v1/users`,
headers: {
"X-Joomla-Token": `${this.joomla.$auth.api_key}`,
},
})
},
})