Integration Specifications
This page will help you learn about how Daasity replicates data from Gorgias, limitations to the data we can extract and where the data is stored in the Gorgias schema.
Integration Overview
Gorgias is a customer support platform used by merchants to centralize customer interactions and automate responses to repetitive questions. The Daasity integration with Gorgias extracts data from the most important endpoints needed to analyze how customers interact with customer support and the performance of those interactions.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
The Daasity Gorgias extractor is built based on this Gorgias API documentation. The following endpoints are used by Daasity to replicate data from Gorgias:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Gorgias integration illustrating the different tables and keys to join across tables.
Gorgias Schema
The Daasity Gorgias extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.
Accounts
Endpoint: Account
Update Method: UPSERT
Table Name: [
gorgias.accounts]
domain
domain
status
status
created_datetime
created_at
current_subscription::plan
subscription_plan
current_subscription::start_datetime
subscription_created_at
current_subscription::status
subscription_status
settings::id
setting_id
settings::type
setting_type
settings::data::timezone
timezone
settings::data::business_hours::days
business_days
settings::data::business_hours::to_time
business_close
settings::data::business_hours::from_time
business_open
MD5(id + domain)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Accounts Custom Attributes
Endpoint: Account
Update Method: UPSERT
Table Name: [
gorgias.accounts_custom_attributes]
domain
domain
setting_row::id
settings_id
key
custom_attribute_key
value
custom_attribute_value
setting_row::type
custom_attribute_type
_account_id
account_id
MD5(setting_row::id + domain + key)
__sync_key
Accounts Custom Attributes Data
Endpoint: Account
Update Method: UPSERT
Table Name: [
gorgias.accounts_custom_attributes_data]
domain
domain
settings_row::id
settings_id
array_name
attribute_data_name
settings_row::type
custom_attribute_type
index
custom_attribute_index
key
custom_data_key
value
custom_data_value
MD5(settings_row::id + domain + array_name + index + source_id + key)
__sync_key
Events
Endpoint:
Update Method: UPSERT
Table Name: [
gorgias.event]
id
event_id
uri
event_uri
object_type
object_type
object_id
object_id
user_id
user_id
type
event_type
context
context
created_datetime
created_at
MD5(id)
__sync_key
Tickets
Endpoint: Tickets
Update Method: UPSERT
Table Name: [
gorgias.tickets]
id
ticket_id
external_id
external_id
channel
ticket_channel
via
via
from_agent
from_agent
status
ticket_status
priority
ticket_priority
requester::id
requester_id
requester::email
requester_email
requester::name
requester_name
requester::firstname
requester_firstname
requester::lastname
requester_lastname
customer::id
customer_id
customer::email
customer_email
customer::name
customer_name
customer::firstname
customer_firstname
customer::lastname
customer_lastname
assignee_user::firstname
assignee_firstname
assignee_user::lastname
assignee_lastname
assignee_user::id
assignee_id
assignee_user::email
assignee_email
subject
ticket_subject
except
ticket_excerpt
messages_count
messages_count
is_unread
is_unread
created_datetime
created_at
opened_datetime
opened_at
last_received_message_datetime
last_received_at
last_message_datetime
last_message_at
updated_datetime
updated_at
closed_datetime
closed_at
trashed_datetime
trashed_at
snooze_datetime
snooze_at
MD5(id + requestor::id + created_datetime + source_id)
__sync_key
Ticket Tags
Update Method: UPSERT
Table Name: [
gorgias.ticket_tags]
id
ticket_id
tag::name
tag_name
tag::id
tag_id
account_id
__account_id
MD5(id + name + source_id)
__sync_key
Ticket Messages
Endpoint: Tickets and Ticket Messages
Update Method: UPSERT
Table Name: [
gorgias.ticket_messages]
JSON Element
Database Column
id
message_id
ticket_id
ticket_id
public
public
channel
channel
via
via
sender::id
sender_id
sender::email
sender_email
sender::name
sender_name
sender::firstname
sender_firstname
sender::lastname
sender_lastname
sender::channel
sender_channel
integration_id
integration_id
from_agent
from_agent
receiver::id
receiver_id
receiver::email
receiver_email
receiver::name
receiver_name
receiver::firstname
receiver_firstname
receiver::lastname
receiver_lastname
receiver::meta::name_set_via
receiver_channel
subject
subject
body_text
body_text
stripped_text
stripped_text
created_datetime
created_at
sent_datetime
send_at
account_id
_account_id
MD5(id + ticket_id + source_id)
__sync_key
Users
Endpoint: Users
Update Method: UPSERT
Table Name: [
gorgias.users]
id
user_id
external_id
external_id
active
active
user_email
firstname
first_name
lastname
last_name
name
user_name
created_datetime
created_at
updated_datetime
updated_at
account_id
_account_id
MD5(id + source_id)
__sync_key
Satisfaction Survey
Endpoint: Satisfaction Surveys
Update Method: UPSERT
Table Name: [
gorgias.satisfaction_survey]
id
survey_id
customer_id
customer_id
ticket_id
ticket_id
sent_datetime
sent_at
scored_datetime
scored_at
body_text
body_text
score
score
created_datetime
created_at
MD5(id + customer_id + ticket_id + source_id)
__sync_key
Was this helpful?