Database
Query a SQL Database with a built-in SQL editor and Schema Explorer
Integrate the Database API with the HubSpot API
Setup the Database API trigger to run a workflow which integrates with the HubSpot API. Pipedream's integration platform allows you to integrate Database and HubSpot remarkably fast. Free for developers.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Database and HubSpot Actions#
Adds a contact to a specific static list. See the documentation
Create or update a batch of contacts by its ID or email. See the documentation
Create a WhatsApp, LinkedIn, or SMS message. See the documentation
Overview of Database#
The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.
Connect Database#
import postgresql from "@pipedream/postgresql";
export default {
props: {
postgresql,
sql: {
type: "sql",
auth: {
app: "postgresql",
},
label: "PostreSQL Query",
},
},
async run({ $ }) {
const args = this.postgresql.executeQueryAdapter(this.sql);
const data = await this.postgresql.executeQuery(args);
return data;
},
};
Overview of HubSpot#
The HubSpot API enables developers to integrate into HubSpots CRM, CMS, Conversations, and other features. It allows for automated management of contacts, companies, deals, and marketing campaigns, enabling custom workflows, data synchronization, and task automation. This streamlines operations and boosts customer engagement, with real-time updates for rapid response to market changes.
Connect HubSpot#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
hubspot: {
type: "app",
app: "hubspot",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.hubapi.com/integrations/v1/me`,
headers: {
Authorization: `Bearer ${this.hubspot.$auth.oauth_access_token}`,
},
})
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies