-- Fetch all the Calls belonging to the Gong account
-- of a particular user.
SELECT *
FROM fiber.gong_call
WHERE account_id = '{user.gong_id}'
-- Fetch all the Calls belonging to the Gong account
-- of a particular user.
SELECT *
FROM fiber.gong_call
WHERE account_id = '{user.gong_id}'
Code
CREATE TABLE fiber.gong_call (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
url TEXT,
title TEXT,
scheduled TIMESTAMP WITH TIME ZONE,
started TIMESTAMP WITH TIME ZONE,
duration DOUBLE PRECISION,
primary_user_id TEXT,
direction TEXT,
system TEXT,
scope TEXT,
media TEXT,
language TEXT,
workspace_id TEXT,
sdr_disposition TEXT,
client_unique_id TEXT,
custom_data TEXT,
purpose TEXT,
meeting_url TEXT,
is_private BOOLEAN,
calendar_event_id TEXT
)
CREATE TABLE fiber.gong_call (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
url TEXT,
title TEXT,
scheduled TIMESTAMP WITH TIME ZONE,
started TIMESTAMP WITH TIME ZONE,
duration DOUBLE PRECISION,
primary_user_id TEXT,
direction TEXT,
system TEXT,
scope TEXT,
media TEXT,
language TEXT,
workspace_id TEXT,
sdr_disposition TEXT,
client_unique_id TEXT,
custom_data TEXT,
purpose TEXT,
meeting_url TEXT,
is_private BOOLEAN,
calendar_event_id TEXT
)
Model definition