Release Notes
November 2024
We have added a new column, open_status_at, to the CONVERSATION_HISTORY table.
We have added the following new tables:
BUSINESS_HOLIDAYBUSINESS_SCHEDULEBUSINESS_SCHEDULE_HOUR
We are gradually rolling out this change to all existing connectors.
March 2024
We have added a new column, _fivetran_deleted, to the QUEUE table to capture deletes and replace the deleted column. Also, we have removed the deleted and deleted_at columns from the QUEUE table. Be sure to update your queries.
January 2024
You can now exclude the following child tables of the MESSAGE table from your syncs:
MESSAGE_ASSIGNED_TEAMMESSAGE_ASSIGNED_USERMESSAGE_ATTACHMENTMESSAGE_CREATED_BY_TEAMMESSAGE_SHORTCUT
On your Connector Details page, go to the Schema tab and deselect the tables.
NOTE: If you exclude the child tables and later want to sync the tables, perform a full re-sync to backfill the data in the child tables.
We have added the following new tables:
ASSISTANTASSISTANT_DIALOGASSISTANT_DIALOG_NODECONVERSATION_TIMECONVERSATION_TIME_CREATED_BY_TEAMCUSTOMER_SHARED_WHATSAPPCUSTOMER_WHATSAPP
We have added the following new columns to the CONVERSATION and CONVERSATION_HISTORY tables:
assistant_emulationassistant_idassistant_statusassistant_transferred_atassistant_type
We are gradually rolling out these changes to all existing connectors.
We now sync custom columns to the USER table. To identify a custom column, we add a prefix, custom_, to the column name.
December 2023
We have added two new columns, brand_id and first_response_created_by, to the CONVERSATION and CONVERSATION_HISTORY tables.
We have added a new table, BRAND. We are gradually rolling out this change to all existing connectors.
November 2023
We have added the following new columns to the CONVERSATION and CONVERSATION_HISTORY tables:
ended_atended_byended_reasonspam
We have added two new columns, first_delivered_timestamp and first_delivered_client_type, to the MESSAGE table.
October 2023
You can now configure the API usage limit of the Kustomer connector using our REST API. Previously, the default API usage limit was 90%. For more information, see our Kustomer API Configuration documentation.
September 2023
We have added a new table, CUSTOM_ATTRIBUTE_METADATA, to store the metadata properties for the custom attributes of a specific resource.
August 2022
The following tables now support history mode for connectors created on or after August 01, 2022:
CONVERSATION_HISTORYCONVERSATION_CHANNEL_HISTORYCONVERSATION_TAG_HISTORYCONVERSATION_SUGGESTED_TAG_HISTORYCONVERSATION_ASSIGNED_TEAM_HISTORYCONVERSATION_ASSIGNED_USER_HISTORY
April 2022
We have added a new column, source, to the MESSAGE table.
March 2022
We now capture deletes for the TEAM_MEMBER and CONVERSATION_TAG tables.
February 2022
We have added a new column, first_message_in_meta_to, to the CONVERSATION table. The column stores the message recipient's email address.
January 2021
We have added a new column, satisfaction_level_first_answer, to the CONVERSATION table.
September 2020
You can now exclude the following tables from the sync:
CARDCOMPANYCONVERSATIONCUSTOMERKOBJECTMESSAGENOTENOTIFICATIONQUEUESHORTCUTSNOOZETAGTEAMTEAM_QUEUEUSER
On your connector details page, go to the Schema tab and deselect the tables you want to exclude.
August 2020
We have added two new columns, deleted and deleted_at, to the USER table. You can use the two columns to identify the users that have been deleted from the Kustomer account.
We have added a new column, _fivetran_deleted, to the COMPANY, NOTIFICATION, and CARD tables. The _fivetran_deleted column marks data that was deleted from the Kustomer account.
We have added two new tables, QUEUE and TEAM_QUEUE.
We have added a new column, queue_id, to the CONVERSATION table. The queue_id column stores the foreign key to the QUEUE table.
July 2020
We now support Kustomer applications that are hosted in the European Union (EU) region. When you create a new Kustomer connector, you can now designate EU as the region.
April 2020
We now capture deletes for the CONVERSATION, CUSTOMER, and NOTE tables.
We have added a new table, MESSAGE_ATTACHMENT, which stores message attachment details.
January 2020
We have added a lookup table, MESSAGE_SHORTCUT, with the message_id and shortcut_id fields.
December 2019
We now sync satisfaction level to the CONVERSATION table. Each new satisfaction level column has the prefix satisfaction_level_ (for example, satisfaction_level_rating).
October 2019
You can now create Kustomer connectors through the Fivetran REST API.
September 2019
We have added the following new fields to the CONVERSATION table:
first_message_in_createdAtfirst_message_in_idfirst_message_in_sentAtfirst_response_createdAtfirst_response_idfirst_response_responseTimefirst_response_sentAtfirst_response_time
April 2019
Kustomer is a software platform for customer experience, service, and support integrated with a number of sources to give support staff a complete picture of a customer when they contact the company.