Skip to content
Book a demoStart free
Connectors

Zoho Desk connector

Set up the Zoho Desk connector in Kaivo: authentication, configuration, the 35 BigQuery tables it syncs, and answers to common questions.

Zoho Desk connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Zoho Desk data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your customer support data instead of moving it.

Sync your Zoho Desk support data into BigQuery with Kaivo to measure ticket volume, response times, and team performance.

CategoryCustomer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the Zoho Desk connector

Section titled “Getting started with the Zoho Desk connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Zoho Desk account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Zoho Desk credentials. You provide:

Field Description
Client Secret
The Client Secret of your Zoho Desk developer application.

| | OAuth Refresh Token |

The refresh token obtained after completing the Zoho OAuth authorization flow.

|

Prerequisites

Zoho Desk only supports OAuth, so you need your own Zoho developer application:

  1. Go to the Zoho API Console, create a Self Client (or a Server-based Application), and note your Client ID and Client Secret.
  2. Generate a grant token with the required Zoho Desk API scopes, then exchange it for a Refresh Token (see Zoho Desk OAuth docs). Use the accounts URL for your account’s region (e.g. accounts.zoho.eu for the EU).
  3. Select your Data Center below — the suffix of your Zoho Desk URL (com, eu, in, com.au, com.cn, jp, or ca). Using the wrong region returns authorization errors even with a valid token.

Then enter those values below.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Client ID
The Client ID of your Zoho Desk developer application.

| | Data Center |

The Zoho data center where your Zoho Desk account is hosted (the suffix of your desk.zoho.<…> URL).

|

Kaivo syncs 35 tables from Zoho Desk into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accessible_organizations (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
company_name STRING
country STRING
currency_code STRING
currency_locale STRING
currency_symbol STRING
edition STRING
employee_count FLOAT64
favicon_url STRING
fax STRING
id FLOAT64
is_admin_in_org BOOL
is_default BOOL
is_payload_encryption_enabled BOOL
is_sandbox_portal BOOL
logo_url STRING
mobile STRING
phone_number STRING
portal_name STRING
portal_url STRING
primary_contact STRING
state STRING
street STRING
website STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agent (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
about_info STRING
country_code STRING
email_id STRING
extn STRING
first_name STRING
id STRING
is_confirmed BOOL
lang_code STRING
last_name STRING
mobile STRING
name STRING
phone STRING
photo_url STRING
profile_id STRING
role_id STRING
role_permission_type STRING
status STRING
time_zone STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: agent__associated_chat_department_ids

Section titled “Subtable: agent__associated_chat_department_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: agent__associated_department_ids

Section titled “Subtable: agent__associated_department_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agent_details_by_id (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
about_info STRING
email_id STRING
extn STRING
first_name STRING
id STRING
is_confirmed BOOL
last_name STRING
mobile STRING
phone STRING
photo_url STRING
profile_id STRING
role_id STRING
role_permission_type STRING
status STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: agent_details_by_id__associated_department_ids

Section titled “Subtable: agent_details_by_id__associated_department_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: agent_details_by_id__channel_expert

Section titled “Subtable: agent_details_by_id__channel_expert”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
all_organizations (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
company_name STRING
country STRING
currency_code STRING
currency_locale STRING
currency_symbol STRING
edition STRING
employee_count FLOAT64
favicon_url STRING
fax STRING
id FLOAT64
is_admin_in_org BOOL
is_default BOOL
is_payload_encryption_enabled BOOL
is_sandbox_portal BOOL
logo_url STRING
mobile STRING
phone_number STRING
portal_name STRING
portal_url STRING
primary_contact STRING
state STRING
street STRING
website STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
call (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
activity_time STRING
completed_time STRING
contact_id STRING
created_time STRING
creator_id STRING
department_id STRING
direction STRING
duration STRING
id STRING
is_spam BOOL
is_trashed BOOL
layout_id STRING
modified_by__email_id STRING
modified_by__first_name STRING
modified_by__id STRING
modified_by__last_name STRING
modified_by__photo_url STRING
modified_time STRING
owner_id STRING
priority STRING
start_time STRING
status STRING
status_type STRING
subject STRING
ticket_id STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
channels (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
accepts_replies BOOL
code STRING
name STRING
reply_config__accepts_attachments BOOL
reply_config__include_quoted_message BOOL
reply_config__update_records BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: channels__reply_config__content_types

Section titled “Subtable: channels__reply_config__content_types”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dashboard_created_tickets (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avg STRING
grouped_by STRING
total_ticket_count STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: dashboard_created_tickets__ticket_count

Section titled “Subtable: dashboard_created_tickets__ticket_count”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
count STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dashboard_onhold_tickets (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
count STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
get_latest_thread (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment_count STRING
author__type STRING
author__email STRING
author__first_name STRING
author__id STRING
author__last_name STRING
author__name STRING
author__photo_url STRING
bcc STRING
can_reply BOOL
cc STRING
channel STRING
content STRING
content_type STRING
created_time STRING
direction STRING
from_email_address STRING
has_attach BOOL
id STRING
is_content_truncated BOOL
is_description_thread BOOL
is_forward BOOL
reply_to STRING
responder_id STRING
source__type STRING
status STRING
summary STRING
to STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_accounts (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_name STRING
created_time STRING
customer_happiness__bad_percentage STRING
customer_happiness__good_percentage STRING
customer_happiness__ok_percentage STRING
email STRING
id STRING
phone STRING
web_url STRING
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_agents (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
about_info STRING
country_code STRING
email_id STRING
extn STRING
first_name STRING
id STRING
is_confirmed BOOL
lang_code STRING
last_name STRING
mobile STRING
name STRING
phone STRING
photo_url STRING
profile_id STRING
role_id STRING
role_permission_type STRING
status STRING
time_zone STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: list_agents__associated_chat_department_ids

Section titled “Subtable: list_agents__associated_chat_department_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: list_agents__associated_department_ids

Section titled “Subtable: list_agents__associated_department_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_all_threads (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment_count STRING
author__type STRING
author__email STRING
author__first_name STRING
author__id STRING
author__last_name STRING
author__name STRING
author__photo_url STRING
bcc STRING
can_reply BOOL
cc STRING
channel STRING
content_type STRING
created_time STRING
direction STRING
from_email_address STRING
has_attach BOOL
id STRING
is_description_thread BOOL
is_forward BOOL
responded_in STRING
responder_id STRING
source__type STRING
status STRING
summary STRING
to STRING
visibility STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_articles (65 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachment_count STRING
author__id STRING
author__name STRING
author__photo_url STRING
author__status STRING
author__zuid STRING
author_id STRING
category__id STRING
category__locale STRING
category__name STRING
category_id STRING
comment_count STRING
created_by__id STRING
created_by__name STRING
created_by__photo_url STRING
created_by__status STRING
created_by__zuid STRING
created_time STRING
creator_id STRING
department_id STRING
dislike_count STRING
feedback_count STRING
id STRING
is_locked BOOL
is_trashed BOOL
latest_published_version STRING
latest_version STRING
latest_version_modified_by__id STRING
latest_version_modified_by__name STRING
latest_version_modified_by__photo_url STRING
latest_version_modified_by__status STRING
latest_version_modified_by__zuid STRING
latest_version_modifier_id STRING
latest_version_status STRING
like_count STRING
locale STRING
modified_by__id STRING
modified_by__name STRING
modified_by__photo_url STRING
modified_by__status STRING
modified_by__zuid STRING
modified_time STRING
modifier_id STRING
owner__id STRING
owner__name STRING
owner__photo_url STRING
owner__status STRING
owner__zuid STRING
owner_id STRING
permalink STRING
permission STRING
portal_url STRING
position STRING
root_category_id STRING
source_locale STRING
status STRING
summary STRING
title STRING
translation_id STRING
translation_state STRING
usage_count STRING
view_count STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: list_articles__available_locale_translations

Section titled “Subtable: list_articles__available_locale_translations”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author_id STRING
href STRING
is_locked BOOL
is_trashed BOOL
latest_published_version STRING
latest_version STRING
latest_version_status STRING
locale STRING
status STRING
translation_id STRING
translation_state STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_attachments (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_time STRING
creator_id STRING
href STRING
id STRING
name STRING
size STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_call_comments (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
commented_time STRING
commenter__type STRING
commenter__email STRING
commenter__first_name STRING
commenter__id STRING
commenter__last_name STRING
commenter__name STRING
commenter__photo_url STRING
commenter__role_name STRING
commenter_id STRING
content STRING
content_type STRING
encoded_content STRING
id STRING
modified_time STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_calls (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activity_time STRING
completed_time STRING
contact_id STRING
created_time STRING
creator_id STRING
department_id STRING
direction STRING
id STRING
is_commented BOOL
is_spam BOOL
is_trashed BOOL
layout_id STRING
modified_by__email_id STRING
modified_by__first_name STRING
modified_by__id STRING
modified_by__last_name STRING
modified_by__photo_url STRING
modified_time STRING
owner_id STRING
priority STRING
start_time STRING
status STRING
status_type STRING
subject STRING
ticket_id STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_contacts (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_count STRING
account_id STRING
created_time STRING
customer_happiness__bad_percentage STRING
customer_happiness__good_percentage STRING
customer_happiness__ok_percentage STRING
email STRING
first_name STRING
id STRING
is_anonymous BOOL
is_end_user BOOL
is_spam BOOL
last_name STRING
mobile STRING
owner_id STRING
phone STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_contracts (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id STRING
associated_sla_id STRING
contract_name STRING
contract_status STRING
department_id STRING
id STRING
sla_name STRING
start_date STRING
support_plan__id STRING
support_plan__name STRING
support_plan__status STRING
support_plan__support_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_departments (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
chat_status STRING
created_time STRING
creator_id STRING
has_logo BOOL
id STRING
is_assign_to_team_enabled BOOL
is_default BOOL
is_enabled BOOL
is_visible_in_customer_portal BOOL
name STRING
name_in_customer_portal STRING
sanitized_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_events (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activity_time STRING
category STRING
contact_id STRING
created_time STRING
creator_id STRING
department_id STRING
id STRING
is_commented BOOL
is_spam BOOL
is_trashed BOOL
layout_id STRING
modified_by__email_id STRING
modified_by__first_name STRING
modified_by__id STRING
modified_by__last_name STRING
modified_by__photo_url STRING
modified_time STRING
owner_id STRING
priority STRING
start_time STRING
status STRING
status_type STRING
subject STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_products (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
product_code STRING
product_name STRING
unit_price STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_roles (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
is_default BOOL
is_visible BOOL
name STRING
reports_to STRING
share_data_with_peers BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_tasks (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activity_time STRING
contact_id STRING
created_time STRING
creator_id STRING
department_id STRING
due_date STRING
id STRING
is_commented BOOL
is_spam BOOL
is_trashed BOOL
layout_id STRING
modified_by__email_id STRING
modified_by__first_name STRING
modified_by__id STRING
modified_by__last_name STRING
modified_by__photo_url STRING
modified_time STRING
owner_id STRING
priority STRING
status STRING
status_type STRING
subject STRING
ticket_id STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_tickets (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assignee_id STRING
channel STRING
comment_count STRING
contact_id STRING
created_time STRING
customer_response_time STRING
department_id STRING
due_date STRING
email STRING
id STRING
is_archived BOOL
is_spam BOOL
language STRING
last_thread__channel STRING
last_thread__direction STRING
last_thread__is_draft BOOL
last_thread__is_forward BOOL
layout_id STRING
phone STRING
product_id STRING
source__type STRING
status STRING
status_type STRING
subject STRING
thread_count STRING
ticket_number STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_user_groups (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
added_time STRING
help_center_id STRING
id STRING
logo_url STRING
name STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_users (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email_address STRING
id STRING
last_accessed_time STRING
name STRING
status STRING
user_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
modules (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
api_name STRING
created_time STRING
display_label STRING
has_recycle_bin BOOL
id STRING
is_custom_module BOOL
is_dept_specific BOOL
modified_time STRING
name_field STRING
plural_label STRING
singular_label STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organization (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
company_name STRING
country STRING
currency_code STRING
currency_locale STRING
currency_symbol STRING
edition STRING
employee_count FLOAT64
favicon_url STRING
fax STRING
id FLOAT64
is_admin_in_org BOOL
is_default BOOL
is_payload_encryption_enabled BOOL
is_sandbox_portal BOOL
logo_url STRING
mobile STRING
phone_number STRING
portal_name STRING
portal_url STRING
primary_contact STRING
state STRING
street STRING
website STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_by STRING
created_time STRING
id STRING
is_deleted BOOL
layout_details__id STRING
layout_details__layout_name STRING
layout_id STRING
modified_by STRING
modified_time STRING
owner_id STRING
product_category STRING
product_code STRING
product_name STRING
unit_price STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
profiles (181 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
default BOOL
id STRING
is_visible BOOL
name STRING
permissions__community_comment__view BOOL
permissions__community_topic__view BOOL
permissions__accounts__create BOOL
permissions__accounts__delete BOOL
permissions__accounts__edit BOOL
permissions__accounts__export BOOL
permissions__accounts__import BOOL
permissions__accounts__view BOOL
permissions__agents__create BOOL
permissions__agents__delete BOOL
permissions__agents__edit BOOL
permissions__agents__import BOOL
permissions__agents__overview BOOL
permissions__agents__view_all_fields BOOL
permissions__calls__create BOOL
permissions__calls__delete BOOL
permissions__calls__edit BOOL
permissions__calls__export BOOL
permissions__calls__import BOOL
permissions__calls__view BOOL
permissions__chat__view BOOL
permissions__comments__delete BOOL
permissions__comments__edit BOOL
permissions__community__create BOOL
permissions__community__delete BOOL
permissions__community__edit BOOL
permissions__community__moderate BOOL
permissions__community__view BOOL
permissions__contacts__create BOOL
permissions__contacts__delete BOOL
permissions__contacts__edit BOOL
permissions__contacts__export BOOL
permissions__contacts__import BOOL
permissions__contacts__view BOOL
permissions__contracts__create BOOL
permissions__contracts__delete BOOL
permissions__contracts__edit BOOL
permissions__contracts__export BOOL
permissions__contracts__import BOOL
permissions__contracts__view BOOL
permissions__crm_integ__crm_accounts_activity_calls BOOL
permissions__crm_integ__crm_accounts_activity_events BOOL
permissions__crm_integ__crm_accounts_activity_tasks BOOL
permissions__crm_integ__crm_accounts_info BOOL
permissions__crm_integ__crm_accounts_notes BOOL
permissions__crm_integ__crm_accounts_potentials BOOL
permissions__crm_integ__crm_contacts_activity_calls BOOL
permissions__crm_integ__crm_contacts_activity_events BOOL
permissions__crm_integ__crm_contacts_activity_tasks BOOL
permissions__crm_integ__crm_contacts_info BOOL
permissions__crm_integ__crm_contacts_notes BOOL
permissions__crm_integ__crm_contacts_potentials BOOL
permissions__events__create BOOL
permissions__events__delete BOOL
permissions__events__edit BOOL
permissions__events__export BOOL
permissions__events__import BOOL
permissions__events__view BOOL
permissions__finance_integ__create_contact BOOL
permissions__finance_integ__create_estimate BOOL
permissions__finance_integ__create_invoice BOOL
permissions__finance_integ__create_sales_order BOOL
permissions__finance_integ__send_estimate BOOL
permissions__finance_integ__send_invoice BOOL
permissions__finance_integ__send_sales_order BOOL
permissions__finance_integ__view_estimate BOOL
permissions__finance_integ__view_invoice BOOL
permissions__finance_integ__view_sales_order BOOL
permissions__finance_integ__view_subscription BOOL
permissions__gc__create BOOL
permissions__gc__delete BOOL
permissions__gc__edit BOOL
permissions__gc__view BOOL
permissions__im__create BOOL
permissions__im__delete BOOL
permissions__im__edit BOOL
permissions__im__view BOOL
permissions__kb_category__admin BOOL
permissions__kb_category__create BOOL
permissions__kb_category__delete BOOL
permissions__kb_category__edit BOOL
permissions__kb_category__edit_all_articles BOOL
permissions__kb_category__export BOOL
permissions__kb_category__import BOOL
permissions__kb_category__manage_kb BOOL
permissions__kb_category__view BOOL
permissions__mobileapp__deskapp BOOL
permissions__mobileapp__radar BOOL
permissions__products__create BOOL
permissions__products__delete BOOL
permissions__products__edit BOOL
permissions__products__export BOOL
permissions__products__import BOOL
permissions__products__view BOOL
permissions__reports__create BOOL
permissions__reports__delete BOOL
permissions__reports__edit BOOL
permissions__reports__export BOOL
permissions__reports__view BOOL
permissions__setup__automation BOOL
permissions__setup__buttons BOOL
permissions__setup__chat BOOL
permissions__setup__community BOOL
permissions__setup__customer_happiness BOOL
permissions__setup__department BOOL
permissions__setup__email BOOL
permissions__setup__export_portal_users BOOL
permissions__setup__export_users BOOL
permissions__setup__feature_config BOOL
permissions__setup__gamification BOOL
permissions__setup__google_analytics BOOL
permissions__setup__im BOOL
permissions__setup__import_history BOOL
permissions__setup__layouts BOOL
permissions__setup__localization BOOL
permissions__setup__manage_agents BOOL
permissions__setup__manage_marketplace BOOL
permissions__setup__manager_dashboard BOOL
permissions__setup__mass_reply BOOL
permissions__setup__permission BOOL
permissions__setup__pinned_conversations BOOL
permissions__setup__portal BOOL
permissions__setup__portal_users BOOL
permissions__setup__privacy_settings BOOL
permissions__setup__rebranding BOOL
permissions__setup__recycle_bin BOOL
permissions__setup__sandbox BOOL
permissions__setup__security_settings BOOL
permissions__setup__share_snippet BOOL
permissions__setup__sign_up_approval BOOL
permissions__setup__social BOOL
permissions__setup__tabs_and_fields BOOL
permissions__setup__teams BOOL
permissions__setup__telephony BOOL
permissions__setup__templates BOOL
permissions__setup__time_tracking BOOL
permissions__setup__web_form BOOL
permissions__setup__webhooks BOOL
permissions__social__twitter_conversation_reply BOOL
permissions__social__twitter_post_create BOOL
permissions__social__twitter_post_delete BOOL
permissions__social__view BOOL
permissions__tasks__create BOOL
permissions__tasks__delete BOOL
permissions__tasks__edit BOOL
permissions__tasks__export BOOL
permissions__tasks__import BOOL
permissions__tasks__view BOOL
permissions__tickets__add_followers BOOL
permissions__tickets__change_owner BOOL
permissions__tickets__close_ticket BOOL
permissions__tickets__create BOOL
permissions__tickets__delete BOOL
permissions__tickets__delete_tags BOOL
permissions__tickets__edit BOOL
permissions__tickets__edit_tags BOOL
permissions__tickets__export BOOL
permissions__tickets__handle_unassigned BOOL
permissions__tickets__import BOOL
permissions__tickets__mail_review BOOL
permissions__tickets__mail_send BOOL
permissions__tickets__merge_tickets BOOL
permissions__tickets__revoke_blueprint BOOL
permissions__tickets__unassigned_change_owner BOOL
permissions__tickets__view BOOL
permissions__time_entry__create BOOL
permissions__time_entry__delete BOOL
permissions__time_entry__edit BOOL
permissions__time_entry__view BOOL
permissions__zia__create BOOL
permissions__zia__delete BOOL
permissions__zia__edit BOOL
permissions__zia__view BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
task_attachments (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_time STRING
creator_id STRING
href STRING
id STRING
name STRING
size STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
team_members (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email_id STRING
first_name STRING
id STRING
last_name STRING
photo_url STRING
profile_id STRING
role_id STRING
zuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
department_id STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ticket_activities (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activity_time STRING
activity_type STRING
completed_time STRING
contact_id STRING
created_time STRING
creator_id STRING
department_id STRING
direction STRING
due_date STRING
id STRING
is_commented BOOL
is_spam BOOL
is_trashed BOOL
layout_id STRING
modified_by__email_id STRING
modified_by__first_name STRING
modified_by__id STRING
modified_by__last_name STRING
modified_by__photo_url STRING
modified_time STRING
owner_id STRING
priority STRING
start_time STRING
status STRING
status_type STRING
subject STRING
ticket_id STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
webhooks (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
created_by STRING
created_time STRING
id STRING
ignore_source_id STRING
is_enabled BOOL
modified_time STRING
name STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Zoho Desk supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Zoho Desk?

Section titled “How long does the initial sync take for Zoho Desk?”

It depends on how much history is in your Zoho Desk account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Zoho Desk’s schema changes?

Section titled “What happens when Zoho Desk’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Zoho Desk, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Zoho Desk instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Zoho Desk connector in Kaivo and all of its synced data is deleted with it.

Use list_tickets and list_all_threads to track support volume over time.

Join list_agents with teams to compare workload and handling.

Use list_departments and channels to see where support load sits.

Use Zoho Desk data in your AI and BI tools

Section titled “Use Zoho Desk data in your AI and BI tools”

Once Zoho Desk data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Zoho Desk data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Zoho Desk connector pricing and plan details.

  • HubSpot: Sync HubSpot to BigQuery.
  • Dixa: Sync Dixa to BigQuery.
  • Freshservice: Sync Freshservice to BigQuery.
  • Genesys: Sync Genesys to BigQuery.
  • Gorgias: Sync Gorgias to BigQuery.
  • giosg: Sync giosg to BigQuery.