Integrate the San Francisco Open Data - DataSF API with the HubSpot API

Setup the San Francisco Open Data - DataSF API trigger to run a workflow which integrates with the HubSpot API. Pipedream's integration platform allows you to integrate San Francisco Open Data - DataSF and HubSpot remarkably fast. Free for developers.

Popular San Francisco Open Data - DataSF and HubSpot 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 San Francisco Open Data - DataSF and HubSpot Actions#

Add Contact to List with the HubSpot API

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

Try it

Batch Create or Update Contact with the HubSpot API

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

Try it

Create Associations with the HubSpot API

Create associations between objects. See the documentation

Try it

Create Company with the HubSpot API

Create a company in Hubspot. See the documentation

Try it

Create Contact with the HubSpot API

Create a contact in Hubspot. See the documentation

Try it

Overview of San Francisco Open Data - DataSF#

The San Francisco Open Data - DataSF API unlocks a wealth of government data spanning multiple domains such as transportation, housing, and public health. It provides developers with access to rich datasets, which can be integrated into applications to derive insights, inform decision-making, and power data-driven solutions. Pipedream's serverless platform amplifies this potential by enabling users to create automated workflows that leverage this data in concert with other apps and services.

Connect San Francisco Open Data - DataSF#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    san_francisco_open_data_datasf: {
      type: "app",
      app: "san_francisco_open_data_datasf",
    }
  },
  async run({steps, $}) {
    // Below, we fetch a range of COVID-19 case data from DataSF. You can
    // run this to see how the results are displayed on Pipedream, or modify it 
    // in any way to fetch data from another dataset or modify the Socrata 
    // query. See the docs below for Socrata docs and examples.
    
    // COVID-19 Cases Summarized by Date, Transmission and Case Disposition
    // https://dev.socrata.com/foundry/data.sfgov.org/tvq9-ec9w
    
    return await axios($, {
      url: `https://data.sfgov.org/resource/tvq9-ec9w.json`,
      headers: {
        "X-App-Token": `${this.san_francisco_open_data_datasf.$auth.app_token}`,
      },
      params: {
        "$where": `date between '2020-05-18T00:00:00' and '2020-05-20T00:00:00'`,
      },
    })
  },
})

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