Integrate HubSpot using Fiber

Sync your customers' dataFiber pulls data from your customers' HubSpot accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

hubspot_calls

hubspot_contacts

hubspot_deals

Your customers' HubSpot accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the HubSpot API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the Contacts belonging to the HubSpot 
-- account of a particular user. 

SELECT *
FROM fiber.hubspot_contact
WHERE account_id = '{user.hubspot_id}'

-- Fetch all the Contacts belonging to the HubSpot 
-- account of a particular user. 

SELECT *
FROM fiber.hubspot_contact
WHERE account_id = '{user.hubspot_id}'

Code

CREATE TABLE fiber.hubspot_contact (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  email TEXT,
  firstname TEXT,
  lastname TEXT,
  phone TEXT,
  company TEXT,
  website TEXT,
  lifecyclestage TEXT
)

CREATE TABLE fiber.hubspot_contact (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  email TEXT,
  firstname TEXT,
  lastname TEXT,
  phone TEXT,
  company TEXT,
  website TEXT,
  lifecyclestage TEXT
)