Integrate Yotpo using Fiber

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

→

Fiber

→

postgres-prod

yotpo_reviews

yotpo_products

yotpo_emails

Your customers' Yotpo accounts

Your production database

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

-- Fetch all the Reviews belonging to the Yotpo 
-- account of a particular user. 

SELECT *
FROM fiber.yotpo_review
WHERE account_id = '{user.yotpo_id}'

-- Fetch all the Reviews belonging to the Yotpo 
-- account of a particular user. 

SELECT *
FROM fiber.yotpo_review
WHERE account_id = '{user.yotpo_id}'

Code

CREATE TABLE fiber.yotpo_review (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  title TEXT,
  content TEXT,
  score INT,
  votes_up INT,
  votes_down INT,
  sentiment DOUBLE PRECISION,
  sku TEXT,
  name TEXT,
  email TEXT,
  reviewer_type TEXT,
  deleted BOOLEAN,
  user_reference TEXT,
  is_incentivized BOOLEAN,
  incentive_type TEXT
)

CREATE TABLE fiber.yotpo_review (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  title TEXT,
  content TEXT,
  score INT,
  votes_up INT,
  votes_down INT,
  sentiment DOUBLE PRECISION,
  sku TEXT,
  name TEXT,
  email TEXT,
  reviewer_type TEXT,
  deleted BOOLEAN,
  user_reference TEXT,
  is_incentivized BOOLEAN,
  incentive_type TEXT
)