with Retool 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
Retool is a platform that makes it faster to build internal tools with a drag-and-drop interface. The Retool API allows you to programmatically manage various aspects of your Retool applications, such as triggering queries, updating apps, or retrieving data from your custom tools. In Pipedream, you can utilize this API to automate workflows between Retool and other apps, creating powerful integrations that streamline your internal processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
retool: {
type: "app",
app: "retool",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.retool.com/api/v1/resources`,
headers: {
Authorization: `Bearer ${this.retool.$auth.access_token}`,
"Accept": `application/json`,
},
})
},
})
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
}
},
})