Browse sources$ls -a sources
Logo of intercom
Intercom
Enhance user engagement with data from Intercom
Sync your customers' dataFiber pulls data from your customers' Intercom accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Logo of intercom
Fiber
postgres-prod
intercom_users
intercom_segments
intercom_tickets
Your customers' Intercom accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Intercom API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Conversations belonging to the
-- Intercom account of a particular user.

SELECT *
FROM fiber.intercom_conversation
WHERE account_id = '{user.intercom_id}'
-- Fetch all the Conversations belonging to the
-- Intercom account of a particular user.

SELECT *
FROM fiber.intercom_conversation
WHERE account_id = '{user.intercom_id}'
Code
CREATE TABLE fiber.intercom_conversation (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
type TEXT,
title TEXT,
waiting_since INT,
snoozed_until INT,
open BOOLEAN,
state TEXT,
read BOOLEAN,
priority TEXT,
admin_assignee_id TEXT,
team_assignee_id TEXT,
tags JSONB,
conversation_rating JSONB,
source JSONB,
contacts JSONB,
teammates JSONB,
custom_attributes JSONB,
first_contact_reply JSONB,
sla_applied JSONB,
statistics JSONB,
conversation_parts JSONB,
linked_objects JSONB
)
CREATE TABLE fiber.intercom_conversation (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
type TEXT,
title TEXT,
waiting_since INT,
snoozed_until INT,
open BOOLEAN,
state TEXT,
read BOOLEAN,
priority TEXT,
admin_assignee_id TEXT,
team_assignee_id TEXT,
tags JSONB,
conversation_rating JSONB,
source JSONB,
contacts JSONB,
teammates JSONB,
custom_attributes JSONB,
first_contact_reply JSONB,
sla_applied JSONB,
statistics JSONB,
conversation_parts JSONB,
linked_objects JSONB
)
Model definition
About this source
Logo of Intercom
IntercomMessaging platform that helps businesses connect with customers.intercom.com  ↗
Available resources
    Users
    Segments
    Tickets
    Messages
    Articles
    Tags
    Companies
    Contacts
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Intercom?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Intercom and over 200 other APIs. Setup and deploy within minutes.
Logo of intercomIntegrate Intercom using Fiber Fiber makes it easy to access third-party data from Intercom accounts. Get started in just a few minutes.