Release Notes

October 2025

We have made the following schema changes:

Added a new table, WORK_SESSION, which contains work session information for agents, including capacity status, handled item counts, availability metrics, and time-tracking statistics.
We incrementally sync the WORK_SESSION table and its child tables to capture new records.

November 2024

We have added a new column, open_status_at, to the CONVERSATION_HISTORY table.

We have added the following new tables:

BUSINESS_HOLIDAY
BUSINESS_SCHEDULE
BUSINESS_SCHEDULE_HOUR

We are gradually rolling out this change to all existing connections.

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_TEAM
MESSAGE_ASSIGNED_USER
MESSAGE_ATTACHMENT
MESSAGE_CREATED_BY_TEAM
MESSAGE_SHORTCUT

On your Connector Details page, go to the Schema tab and deselect the tables.

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:

ASSISTANT
ASSISTANT_DIALOG
ASSISTANT_DIALOG_NODE
CONVERSATION_TIME
CONVERSATION_TIME_CREATED_BY_TEAM
CUSTOMER_SHARED_WHATSAPP
CUSTOMER_WHATSAPP

We have added the following new columns to the CONVERSATION and CONVERSATION_HISTORY tables:

assistant_emulation
assistant_id
assistant_status
assistant_transferred_at
assistant_type

We are gradually rolling out these changes to all existing connections.

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 connections.

November 2023

We have added the following new columns to the CONVERSATION and CONVERSATION_HISTORY tables:

ended_at
ended_by
ended_reason
spam

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 connections created on or after August 01, 2022:

CONVERSATION_HISTORY
CONVERSATION_CHANNEL_HISTORY
CONVERSATION_TAG_HISTORY
CONVERSATION_SUGGESTED_TAG_HISTORY
CONVERSATION_ASSIGNED_TEAM_HISTORY
CONVERSATION_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:

CARD
COMPANY
CONVERSATION
CUSTOMER
KOBJECT
MESSAGE
NOTE
NOTIFICATION
QUEUE
SHORTCUT
SNOOZE
TAG
TEAM
TEAM_QUEUE
USER

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_createdAt
first_message_in_id
first_message_in_sentAt
first_response_createdAt
first_response_id
first_response_responseTime
first_response_sentAt
first_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.

Read our Kustomer connector documentation.