Integration: Gorgias

This article 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.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

Integration Availability

This integration is available for:

  • Growth
  • Pro (V1 and V2)

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.

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)

The embedded diagram houses the ERD for the Daasity Gorgias integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

Gorgias Schema

The Daasity Gorgias extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from 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
JSON Element  Database Column

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
JSON Element Database Column
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
JSON Element Database Column
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
JSON Element Database Column
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
JSON Element  Database Column

 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

  • Endpoint: Tickets and Tags
  • Update Method: UPSERT
  • Table Name: gorgias.ticket_tags
JSON Element  Database Column

 id 

 ticket_id 

 tag::name 

 tag_name 

 tag::id 

 tag_id 

account_id

__account_id

 MD5(id + name + source_id)  __sync_key

 

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
 
JSON Element  Database Column

 id 

 user_id 

 external_id 

 external_id 

 active 

 active 

 email 

 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

JSON Element  Database Column

 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
 
 

Release Notes

  • Updated: 2023-02-27
    • Add the [gorgias.events] table