Integrate Square using Fiber

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

→

Fiber

→

postgres-prod

square_categories

square_discounts

square_taxes

Your customers' Square accounts

Your production database

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

-- Fetch all the Categories belonging to the Square 
-- account of a particular user. 

SELECT *
FROM fiber.square_category
WHERE account_id = '{user.square_id}'

-- Fetch all the Categories belonging to the Square 
-- account of a particular user. 

SELECT *
FROM fiber.square_category
WHERE account_id = '{user.square_id}'

Code

CREATE TABLE fiber.square_category (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  type TEXT,
  id TEXT,
  updated_at TEXT,
  version DOUBLE PRECISION,
  is_deleted BOOLEAN,
  present_at_all_locations BOOLEAN,
  category_data JSONB
)

CREATE TABLE fiber.square_category (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  type TEXT,
  id TEXT,
  updated_at TEXT,
  version DOUBLE PRECISION,
  is_deleted BOOLEAN,
  present_at_all_locations BOOLEAN,
  category_data JSONB
)

Model definition

About this source

SquarePayment processing and point-of-sale solutions.squareup.com ↗

Billing

Available resources