Ask or search…
K
Links

Gorgias V2

Gorgias ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Gorgias Url Gorgias Username Gorgias API
Replication Type
Key based Replication
Replication Key
NA LastRun
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Customers
Events
Integration
Jobs
Rules
Surveys
Users
Teams
Tags
Tickets
Messages
View
Custom_Field
Widgets

Integrate Gorgias with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Impact from Integrations page
  3. 3.
    Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
  4. 4.
    Provide your Gorgias Base Url, Gorgias Username and Gorgias API Key. Click here to learn more about Gorgias Base Url, Username and API Key
  5. 5.
    After providing the details to authorize Daton to periodically extract data from Inventory Planner.
  6. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 1.
    Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Gorgias Data

Customers
Purpose: Retrieve a list of all customers
Replication: Key-Based Replication
Replication Key: NA
Fields
fullname
type
id
NUMERIC
active
BOOLEAN
email
STRING
name
STRING
firstname
STRING
lastname
STRING
created_datetime
TIMESTAMP
updated_datetime
TIMESTAMP
meta
RECORD
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
note
STRING
language
STRING
timezone
STRING
meta.name_set_via
STRING
meta.profile_picture_url
STRING
meta.location_info
RECORD
meta.location_info.currency
RECORD
meta.location_info.currency.code
STRING
meta.location_info.languages
RECORD
meta.location_info.languages.name
STRING
meta.location_info.time_zone
RECORD
meta.location_info.time_zone.abbr
STRING
meta.location_info.time_zone.name
STRING
meta.location_info.time_zone.offset
STRING
meta.location_info.ip
STRING
meta.location_info.city
STRING
meta.location_info.region
STRING
meta.location_info.region_code
STRING
meta.location_info.calling_code
STRING
meta.location_info.country_code
STRING
meta.location_info.country_name
STRING
meta.last_phone_call_ended_at
DATETIME
Events
Purpose: Retrieve a list of all events
Replication: Key-Based Replication
Replication Key: NA
Fields
fullname
type
id
NUMERIC
context
STRING
created_datetime
TIMESTAMP
object_id
NUMERIC
object_type
STRING
type
STRING
uri
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
user_id
NUMERIC
Integration
Purpose: List integrations
Replication: Key-Based Replication
Replication Key: NA
Fields
fullname
type
id
NUMERIC
created_datetime
TIMESTAMP
description
STRING
http
RECORD
meta
RECORD
name
STRING
type
STRING
updated_datetime
TIMESTAMP
user
RECORD
uri
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
decoration
RECORD
deactivated_datetime
TIMESTAMP
http.id
NUMERIC
http.method
STRING
http.response_content_type
STRING
http.triggers
RECORD
http.triggers.ticket-created
BOOLEAN
http.triggers.ticket-updated
BOOLEAN
http.triggers.ticket-message-created
BOOLEAN
http.url
STRING
http.form
STRING
http.request_content_type
STRING
meta.failures
NUMERIC
meta.phone_number_id
NUMERIC
meta.preferences
RECORD
meta.preferences.record_inbound_calls
BOOLEAN
meta.preferences.voicemail_outside_business_hours
BOOLEAN
meta.preferences.record_outbound_calls
BOOLEAN
meta.preferences.ringing_behaviour
STRING
meta.preferences.auto_responder
RECORD
meta.preferences.auto_responder.enabled
BOOLEAN
meta.preferences.auto_responder.reply
STRING
meta.preferences.email_capture_enabled
BOOLEAN
meta.preferences.email_capture_enforcement
STRING
meta.preferences.linked_email_integration
NUMERIC
meta.preferences.hide_on_mobile
BOOLEAN
meta.preferences.hide_outside_business_hours
BOOLEAN
meta.preferences.display_campaigns_hidden_chat
BOOLEAN
meta.preferences.offline_mode_enabled_datetime
TIMESTAMP
meta.preferences.live_chat_availability
STRING
meta.preferences.control_ticket_volume
BOOLEAN
meta.voicemail
RECORD
meta.voicemail.voice_message_type
STRING
meta.voicemail.text_to_speech_content
STRING
meta.voicemail.voice_recording_file_path
STRING
meta.voicemail.allow_to_leave_voicemail
BOOLEAN
meta.greeting_message
RECORD
meta.greeting_message.voice_message_type
STRING
meta.function
STRING
meta.oauth
RECORD
meta.oauth.status
STRING
meta.oauth.scope
STRING
meta.import_state
RECORD
meta.import_state.is_over
BOOLEAN
meta.import_state.oldest_created_at
TIMESTAMP
meta.import_state.enabled
BOOLEAN
meta.import_state.next_page_link
STRING
meta.import_state.count
NUMERIC
meta.import_state.ticket_count
NUMERIC
meta.import_state.customers
RECORD
meta.import_state.customers.is_over
BOOLEAN
meta.import_state.customers.oldest_created_at
TIMESTAMP
meta.import_state.products
RECORD
meta.import_state.products.is_over
BOOLEAN
meta.import_state.products.oldest_created_at
TIMESTAMP
meta.import_state.oldest_created_at_dtm
DATETIME
meta.yotpo_account_id
STRING
meta.enable_yotpo_tickets
BOOLEAN
meta.sync_state
RECORD
meta.sync_state.is_initialized
BOOLEAN
meta.sync_state.page
NUMERIC
meta.store_name
STRING
meta.need_scope_update
BOOLEAN
meta.history_sync
RECORD
meta.history_sync.posts
RECORD
meta.history_sync.posts.is_synchronized
BOOLEAN
meta.history_sync.posts.oldest_time_synced
DATETIME
meta.history_sync.posts.nb_of_tickets_created
NUMERIC
meta.history_sync.oldest_syncable
DATETIME
meta.history_sync.is_synchronized
BOOLEAN
meta.instagram
RECORD
meta.instagram.id
STRING
meta.instagram.name
STRING
meta.instagram.username
STRING
meta.instagram.followers_count
NUMERIC
meta.instagram.instagram_direct_message_allowed
BOOLEAN
meta.picture
RECORD
meta.picture.data
RECORD
meta.picture.data.height
NUMERIC
meta.picture.data.is_silhouette
BOOLEAN
meta.picture.data.url
STRING
meta.picture.data.width
NUMERIC
meta.settings
RECORD
meta.settings.messenger_enabled
BOOLEAN
meta.settings.posts_enabled
BOOLEAN
meta.settings.mentions_enabled
BOOLEAN
meta.settings.import_history_enabled
BOOLEAN
meta.settings.instagram_comments_enabled
BOOLEAN
meta.settings.instagram_mentions_enabled
BOOLEAN
meta.settings.instagram_ads_enabled
BOOLEAN
meta.settings.recommendations_enabled
BOOLEAN
meta.settings.instagram_direct_message_enabled
BOOLEAN
meta.roles
STRING
meta.can_be_onboarded
BOOLEAN
meta.page_id
STRING
meta.name
STRING
meta.language
STRING
meta.about
STRING
meta.category
STRING
meta.quick_replies
RECORD
meta.quick_replies.enabled
BOOLEAN
meta.quick_replies.replies
STRING
meta.campaigns
RECORD
meta.campaigns.triggers
RECORD
meta.campaigns.triggers.key
STRING
meta.campaigns.triggers.operator
STRING
meta.campaigns.triggers.value
STRING
meta.campaigns.message
RECORD
meta.campaigns.message.text
STRING
meta.campaigns.message.html
STRING
meta.campaigns.name
STRING
meta.campaigns.id
STRING
meta.campaigns.deactivated_datetime
DATETIME
meta.wizard
RECORD
meta.wizard.status
STRING
meta.wizard.step
STRING
meta.app_id
STRING
meta.shop_name
STRING
meta.shop_type
STRING
meta.shop_integration_id
NUMERIC
meta.subscription
RECORD
meta.subscription.id
STRING
meta.subscription.expiration_datetime
DATETIME
meta.signature
RECORD
meta.signature.text
STRING
meta.signature.html
STRING
meta.provider
STRING
meta.address
STRING
meta.outlook_user_id
STRING
meta.notifications
RECORD
meta.notifications.max_http_failures
RECORD
meta.notifications.max_http_failures.sent_datetime
DATETIME
meta.webhooks
RECORD
meta.webhooks.topic
STRING
meta.webhooks.address
STRING
meta.webhooks.webhook_id
NUMERIC
meta.shop_display_name
STRING
meta.shop_domain
STRING
meta.shop_id
NUMERIC
meta.shop_phone
STRING
meta.shop_plan
STRING
meta.uses_multi_currency
BOOLEAN
meta.sync_customer_notes
BOOLEAN
meta.currency
STRING
user.id
NUMERIC
decoration.position
RECORD
decoration.position.alignment
STRING
decoration.position.offsetX
NUMERIC
decoration.position.offsetY
NUMERIC
decoration.avatar
RECORD
decoration.avatar.image_type
STRING
decoration.avatar.name_type
STRING
decoration.main_color
STRING
decoration.conversation_color
STRING
decoration.introduction_text
STRING
decoration.offline_introduction_text
STRING
decoration.avatar_type
STRING
Jobs
Purpose: Fetches all the jobs
Replication: Key-Based Replication
Replication Key: NA
Fields
fullname
type
id
NUMERIC
created_datetime
TIMESTAMP
ended_datetime
TIMESTAMP
info
RECORD
params
RECORD
started_datetime
TIMESTAMP
status
STRING
type
STRING
user_id
NUMERIC
uri
STRING
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
scheduled_datetime
TIMESTAMP
failed_datetime
TIMESTAMP
info.iteration_over
BOOLEAN
info.progress_count
NUMERIC
info.progress_cursor
NUMERIC
info.progress_cursor_dtm
DATETIME
info.archive
RECORD
info.archive.url
STRING
info.archive.name
STRING
info.archive.size
NUMERIC
info.archive.content_type
STRING
info.archive.absolute_path
STRING
info._composed_files
RECORD
info._composed_files.url
STRING
info._composed_files.name
STRING
info._composed_files.size
NUMERIC
info._composed_files.content_type
STRING
info._composed_files.absolute_path
STRING
info.timezone
STRING
info.use_custom_fields
BOOLEAN
info.message
STRING
info._exception
STRING
params.ticket_ids
STRING
params.updates
RECORD
params.updates.status
STRING
params.updates.is_unread
BOOLEAN
params.updates.trashed_datetime
TIMESTAMP
params.updates.assignee_user
RECORD
params.updates.assignee_user.id
NUMERIC
params.updates.assignee_user.name
STRING
params.updates.tags
STRING
params.view
RECORD
params.view.filters_ast
RECORD
params.view.filters_ast.loc
RECORD
params.view.filters_ast.loc.end
RECORD
params.view.filters_ast.loc.end.line
NUMERIC
params.view.filters_ast.loc.end.column
NUMERIC
params.view.filters_ast.loc.start
RECORD
params.view.filters_ast.loc.start.line
NUMERIC
params.view.filters_ast.loc.start.column
NUMERIC
params.view.filters_ast.body
RECORD
params.view.filters_ast.body.loc
RECORD
params.view.filters_ast.body.loc.end
RECORD
params.view.filters_ast.body.loc.end.line
NUMERIC
params.view.filters_ast.body.loc.end.column
NUMERIC
params.view.filters_ast.body.loc.start
RECORD
params.view.filters_ast.body.loc.start.line
NUMERIC
params.view.filters_ast.body.loc.start.column
NUMERIC
params.view.filters_ast.body.expression
RECORD
params.view.filters_ast.body.expression.loc
RECORD
params.view.filters_ast.body.expression.loc.end
RECORD
params.view.filters_ast.body.expression.loc.end.line
NUMERIC
params.view.filters_ast.body.expression.loc.end.column
NUMERIC
params.view.filters_ast.body.expression.loc.start
RECORD
params.view.filters_ast.body.expression.loc.start.line
NUMERIC
params.view.filters_ast.body.expression.loc.start.column
NUMERIC
params.view.filters_ast.body.expression.callee
RECORD
params.view.filters_ast.body.expression.callee.loc
RECORD
params.view.filters_ast.body.expression.callee.loc.end
RECORD
params.view.filters_ast.body.expression.callee.loc.end.line