Browse sources$ls -a sources
Logo of faire
Faire
Unlock new retail opportunities with Faire integration
Sync your customers' dataFiber pulls data from your customers' Faire accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Logo of faire
Fiber
postgres-prod
faire_orders
faire_products
Your customers' Faire accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Faire API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Orders belonging to the Faire
-- account of a particular user.

SELECT *
FROM fiber.faire_order
WHERE account_id = '{user.faire_id}'
-- Fetch all the Orders belonging to the Faire
-- account of a particular user.

SELECT *
FROM fiber.faire_order
WHERE account_id = '{user.faire_id}'
Code
CREATE TABLE fiber.faire_order (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
display_id TEXT,
state TEXT,
address JSONB,
ship_after TEXT,
payout_costs JSONB,
payment_initiated_at TEXT,
retailer_id TEXT,
source TEXT,
expected_ship_date TEXT,
customer JSONB,
processing_at TEXT,
items JSONB,
shipments JSONB,
brand_discounts JSONB
)
CREATE TABLE fiber.faire_order (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
display_id TEXT,
state TEXT,
address JSONB,
ship_after TEXT,
payout_costs JSONB,
payment_initiated_at TEXT,
retailer_id TEXT,
source TEXT,
expected_ship_date TEXT,
customer JSONB,
processing_at TEXT,
items JSONB,
shipments JSONB,
brand_discounts JSONB
)
Model definition
About this source
Logo of Faire
FaireWholesale marketplace connecting retailers and brands.faire.com  ↗
Available resources
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Faire?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Faire and over 200 other APIs. Setup and deploy within minutes.
Logo of faireIntegrate Faire using Fiber Fiber makes it easy to access third-party data from Faire accounts. Get started in just a few minutes.