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_LOOKUPSOURCE_LOOKUPSTATUS_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_GROUPtable - Records with empty role_ids from the
AGENT_ROLEtable - Records with empty cc_mails from the
TICKET_CC_EMAILtable - Records with empty fwd_emails from the
TICKET_FWD_EMAILtable - Records with empty reply_cc_emails from the
TICKET_REPLY_CC_EMAILtable - Records with empty to_emails from the
TICKET_TO_EMAILtable - Records with empty tags from the
TICKET_TAGtable - Records with empty to_emails fields from the
CONVERSATION_TO_EMAILtable - Records with empty bcc_emails from the
CONVERSATION_BCC_EMAILtable
August 2018link
We have added a new table, TICKET_TAG.