with Quickbase and Google Cloud?
Emit new Pub/Sub topic in your GCP account. Messages published to this topic are emitted from the Pipedream source.
Emit new event each time a new record is created in a specified table in Quickbase.
Emit new events with the results of an arbitrary query
Creates a new record in a Quick Base table. See the documentation
Updates an existing record in a Quick Base table. See the documentation
Inserts rows into a BigQuery table. See the docs and for an example here
Quickbase is a low-code platform for building operational applications and automations that can manage data, workflows, and reporting. Using Pipedream's serverless platform, you can tap into the robust Quickbase API to weave complex workflows that respond to events, synchronize data across multiple systems, and streamline business processes. With Pipedream, you can trigger on events in Quickbase, or from hundreds of other apps, and write Node.js code to integrate with the Quickbase API directly, enabling a broad range of automation possibilities.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
quickbase: {
type: "app",
app: "quickbase",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.quickbase.com/v1/apps/brztjz2nz`,
headers: {
"QB-Realm-Hostname": `${this.quickbase.$auth.hostname}`,
"User-Agent": `@PipedreamHQ/pipedream v0.1`,
"Authorization": `QB-USER-TOKEN ${this.quickbase.$auth.user_token}`,
"Content-Type": `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
}
},
})