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]

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

Last updated