Browse sources$ls -a sources
Logo of close
Close
Enhance sales strategies with Close CRM data integration
Sync your customers' dataFiber pulls data from your customers' Close accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of close
Logo of close
Logo of close
Logo of close
Logo of close
Logo of close
Logo of close
Logo of close
Logo of close
Logo of close
Fiber
postgres-prod
close_leads
close_subscriptions
close_discounts
Your customers' Close accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Close API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Leads belonging to the Close account
-- of a particular user.

SELECT *
FROM fiber.close_lead
WHERE account_id = '{user.close_id}'
-- Fetch all the Leads belonging to the Close account
-- of a particular user.

SELECT *
FROM fiber.close_lead
WHERE account_id = '{user.close_id}'
Code
CREATE TABLE fiber.close_lead (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
status_id TEXT,
status_label TEXT,
tasks JSONB,
display_name TEXT,
addresses JSONB,
name TEXT,
contacts JSONB,
custom JSONB,
date_updated TEXT,
html_url TEXT,
created_by JSONB,
organization_id TEXT,
url TEXT,
opportunities JSONB,
updated_by TEXT,
date_created TEXT,
id TEXT,
description TEXT
)
CREATE TABLE fiber.close_lead (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
status_id TEXT,
status_label TEXT,
tasks JSONB,
display_name TEXT,
addresses JSONB,
name TEXT,
contacts JSONB,
custom JSONB,
date_updated TEXT,
html_url TEXT,
created_by JSONB,
organization_id TEXT,
url TEXT,
opportunities JSONB,
updated_by TEXT,
date_created TEXT,
id TEXT,
description TEXT
)
Model definition
About this source
Logo of close
CloseCRM designed to increase sales productivity.close.com  ↗
Available resources
    Leads
    Subscriptions
    Discounts
    Purchases
    Customers
    Orders
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Close?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Close and over 200 other APIs. Setup and deploy within minutes.
Logo of closeIntegrate Close using Fiber Fiber makes it easy to access third-party data from Close accounts. Get started in just a few minutes.