Integrate the HubSpot API with the Database API

Setup the HubSpot API trigger to run a workflow which integrates with the Database API. Pipedream's integration platform allows you to integrate HubSpot and Database remarkably fast. Free for developers.

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Ways to Connect HubSpot with Database#

Query SQL Database with Database API on Company Updated from HubSpot API

HubSpot + Database

Try it

Query SQL Database with Database API on Contact Updated from HubSpot API

HubSpot + Database

Try it

Query SQL Database with Database API on Deleted Blog Posts from HubSpot API

HubSpot + Database

Try it

Query SQL Database with Database API on Line Item Updated from HubSpot API

HubSpot + Database

Try it

Query SQL Database with Database API on New Blog Posts from HubSpot API

HubSpot + Database

Try it

Popular HubSpot and Database Triggers#

Company Updated from the HubSpot API

Emit new event each time a company is updated.

Try it

Contact Updated from the HubSpot API

Emit new event each time a contact is updated.

Try it

Deleted Blog Posts from the HubSpot API

Emit new event for each deleted blog post.

Try it

Line Item Updated from the HubSpot API

Emit new event each time a line item is updated.

Try it

New Blog Posts from the HubSpot API

Emit new event for each new blog post.

Try it

Popular HubSpot and Database Actions#

Add Contact to List with the HubSpot API

Adds a contact to a specific static list. See the documentation

Try it

Query SQL Database with the Database API

Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.

Try it

Batch Create or Update Contact with the HubSpot API

Create or update a batch of contacts by its ID or email. See the documentation

Try it

Create Associations with the HubSpot API

Create associations between objects. See the documentation

Try it

Create Communication with the HubSpot API

Create a WhatsApp, LinkedIn, or SMS message. See the documentation

Try it

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}`,
      },
    })
  },
})

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;
  },
};

Start for free — no credit card required

Watch a demo