Integrate Customer.io using Fiber

Customer.io

Tap into your customers' marketing data inside Customer.io

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

→

Fiber

→

postgres-prod

customerio_customers

customerio_broadcasts

customerio_campaigns

Your customers' Customer.io accounts

Your production database

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

-- Fetch all the Customers belonging to the 
-- Customer.io account of a particular user. 

SELECT *
FROM fiber.customerio_customer
WHERE account_id = '{user.customerio_id}'

-- Fetch all the Customers belonging to the 
-- Customer.io account of a particular user. 

SELECT *
FROM fiber.customerio_customer
WHERE account_id = '{user.customerio_id}'

Code

CREATE TABLE fiber.customerio_customer (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  attributes JSONB
)

CREATE TABLE fiber.customerio_customer (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  attributes JSONB
)