Integrate ActiveCampaign using Fiber

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

→

Fiber

→

postgres-prod

activecampaign_contacts

activecampaign_tickets

activecampaign_attachments

Your customers' ActiveCampaign accounts

Your production database

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

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

SELECT *
FROM fiber.activecampaign_contact
WHERE account_id = '{user.activecampaign_id}'

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

SELECT *
FROM fiber.activecampaign_contact
WHERE account_id = '{user.activecampaign_id}'

Code

CREATE TABLE fiber.activecampaign_contact (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  cdate TEXT,
  email TEXT,
  phone TEXT,
  first_name TEXT,
  last_name TEXT,
  orgid TEXT,
  segmentio_id TEXT,
  bounced_hard TEXT,
  bounced_soft TEXT,
  bounced_date TEXT,
  ip TEXT,
  ua TEXT,
  hash TEXT,
  socialdata_lastcheck TEXT,
  email_local TEXT,
  email_domain TEXT,
  sentcnt TEXT,
  rating_tstamp TEXT,
  gravatar TEXT,
  deleted TEXT,
  adate TEXT,
  udate TEXT,
  edate TEXT
)

CREATE TABLE fiber.activecampaign_contact (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  cdate TEXT,
  email TEXT,
  phone TEXT,
  first_name TEXT,
  last_name TEXT,
  orgid TEXT,
  segmentio_id TEXT,
  bounced_hard TEXT,
  bounced_soft TEXT,
  bounced_date TEXT,
  ip TEXT,
  ua TEXT,
  hash TEXT,
  socialdata_lastcheck TEXT,
  email_local TEXT,
  email_domain TEXT,
  sentcnt TEXT,
  rating_tstamp TEXT,
  gravatar TEXT,
  deleted TEXT,
  adate TEXT,
  udate TEXT,
  edate TEXT
)