March 2021link
We now automatically sync the CONVERSATION
table if you include the parent TICKET
table in the sync. You can no longer select or deselect the CONVERSATION
table in the Schema tab of your connector details page.
We have added the following new lookup tables to map the custom priority
, source
, and status
values in the TICKET
table:
PRIORITY_LOOKUP
SOURCE_LOOKUP
STATUS_LOOKUP
August 2020link
We have removed the _fivetran_deleted
column from the SATISFACTION_RATING
and SATISFACTION_RATING_VALUE
tables. Now, we incrementally update the SATISFACTION_RATING
and SATISFACTION_RATING_VALUE
tables in the destination.
July 2020link
We have stopped inferring the data types of custom fields in the TICKET
table to improve data integrity. Previously, we used to downcast the STRING data type to other data types.
April 2020link
We have added a new field, association_type
, to the TICKET
table.
January 2020link
We have added the functionality to identify and sync the tickets that are flagged as spam. We will also capture the change in state (non-spam to spam) of a previously synced ticket.
September 2019link
We can now delete all of the following records from the tables below:
- Records with empty group_ids from the
AGENT_GROUP
table - Records with empty role_ids from the
AGENT_ROLE
table - Records with empty cc_mails from the
TICKET_CC_EMAIL
table - Records with empty fwd_emails from the
TICKET_FWD_EMAIL
table - Records with empty reply_cc_emails from the
TICKET_REPLY_CC_EMAIL
table - Records with empty to_emails from the
TICKET_TO_EMAIL
table - Records with empty tags from the
TICKET_TAG
table - Records with empty to_emails fields from the
CONVERSATION_TO_EMAIL
table - Records with empty bcc_emails from the
CONVERSATION_BCC_EMAIL
table
August 2018link
We have added a new table, TICKET_TAG
.