Release Noteslink
January 2024link
We have added the following new tables:
SLA_POLICY
SLA_POLICY_APPLICABLE_TO
SLA_POLICY_ESCALATION_NEXT_RESPONSE
SLA_POLICY_ESCALATION_REMINDER_NEXT_RESPONSE
SLA_POLICY_ESCALATION_REMINDER_RESOLUTION
SLA_POLICY_ESCALATION_REMINDER_RESPONSE
SLA_POLICY_ESCALATION_RESOLUTION
SLA_POLICY_ESCALATION_RESPONSE
SLA_POLICY_TARGET
These tables support capturing deletes and will be synced once daily. We are gradually rolling out this change to all existing customers.
November 2023link
We have added the following new columns to the BUSINESS_HOUR
table:
sunday_start_time
sunday_end_time
monday_start_time
monday_end_time
tuesday_start_time
tuesday_end_time
wednesday_start_time
wednesday_end_time
thursday_start_time
thursday_end_time
friday_start_time
friday_end_time
saturday_start_time
saturday_end_time
We have added the following new columns to the COMPANY
table:
health_score
account_tier
renewal_date
industry
org_company_id
We have added the following new columns to the TICKET
table:
stats_status_updated_at
stats_reopened_at
stats_pending_since
We have added the following new columns to the TICKET_HISTORY
table:
stats_status_updated_at
stats_reopened_at
stats_pending_since
We have added the following new tables to the Freshdesk connector:
AUTOMATION
AUTOMATION_EVENT
AUTOMATION_ACTION
AUTOMATION_CONDITION
AUTOMATION_PERFORMER_MEMBER
These tables will be synced once a day and will support delete capture. We are gradually rolling out this change to all existing customers.
January 2023link
The TICKET_HISTORY
table now supports history mode for connectors created on or after January 10, 2023.
March 2021link
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
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.
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
.