Kommo Connector Reference

5 metrics74 dimensions

Fields

The Kommo connector exposes 79 fields (5 metrics, 74 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Kommo Fields

Kommo Companies fields

The Companies report of the Kommo connector includes 10 fields.

ID	Type	Name	Description
company_closest_task_at	TIMESTAMP	Company Closest Task At	When the closest open task on the company is due.
company_contacts_count	NUMERIC	Company Contacts	The number of contacts linked to the company.
company_created_at	TIMESTAMP	Company Created At	When the company was created.
company_group_id	TEXT	Company Group ID	The group of the user responsible for the company.
company_id	TEXT	Company ID	The unique identifier for the company.
company_leads_count	NUMERIC	Company Leads	The number of leads linked to the company.
company_name	TEXT	Company Name	The name of the company.
company_responsible_user_id	TEXT	Company Responsible User ID	The unique identifier of the user responsible for the company.
company_tags	TEXT	Company Tags	The comma-separated tags attached to the company.
company_updated_at	TIMESTAMP	Company Updated At	When the company was last updated.

Kommo Contacts fields

The Contacts report of the Kommo connector includes 12 fields.

ID	Type	Name	Description
contact_closest_task_at	TIMESTAMP	Contact Closest Task At	When the closest open task on the contact is due.
contact_company_id	TEXT	Contact Company ID	The unique identifier of the company the contact belongs to.
contact_created_at	TIMESTAMP	Contact Created At	When the contact was created.
contact_first_name	TEXT	Contact First Name	The first name of the contact.
contact_group_id	TEXT	Contact Group ID	The group of the user responsible for the contact.
contact_id	TEXT	Contact ID	The unique identifier for the contact.
contact_last_name	TEXT	Contact Last Name	The last name of the contact.
contact_leads_count	NUMERIC	Contact Leads	The number of leads linked to the contact.
contact_name	TEXT	Contact Name	The full name of the contact.
contact_responsible_user_id	TEXT	Contact Responsible User ID	The unique identifier of the user responsible for the contact.
contact_tags	TEXT	Contact Tags	The comma-separated tags attached to the contact.
contact_updated_at	TIMESTAMP	Contact Updated At	When the contact was last updated.

Kommo General fields

The General report of the Kommo connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The Kommo subdomain the data was pulled from.
account_name	TEXT	Account Name	The name of the Kommo account.
date	DATE	Date	The date of the record.

Kommo Leads fields

The Leads report of the Kommo connector includes 19 fields.

ID	Type	Name	Description
lead_closed_at	TIMESTAMP	Lead Closed At	When the lead was closed as won or lost.
lead_closest_task_at	TIMESTAMP	Lead Closest Task At	When the closest open task on the lead is due.
lead_company_id	TEXT	Lead Company ID	The unique identifier of the company linked to the lead.
lead_contacts_count	NUMERIC	Lead Contacts	The number of contacts linked to the lead.
lead_created_at	TIMESTAMP	Lead Created At	When the lead was created.
lead_deal_name	TEXT	Lead Deal Name	The name of the lead.
lead_group_id	TEXT	Lead Group ID	The group of the user responsible for the lead.
lead_id	TEXT	Lead ID	The unique identifier for the lead.
lead_loss_reason	TEXT	Lead Loss Reason	The reason the lead was lost.
lead_loss_reason_id	TEXT	Lead Loss Reason ID	The unique identifier of the reason the lead was lost.
lead_main_contact_id	TEXT	Lead Main Contact ID	The unique identifier of the main contact linked to the lead.
lead_pipeline_id	TEXT	Lead Pipeline ID	The unique identifier of the pipeline the lead is in.
lead_price	NUMERIC	Lead Price	The sale value of the lead in the account currency.
lead_responsible_user_id	TEXT	Lead Responsible User ID	The unique identifier of the user responsible for the lead.
lead_source	TEXT	Lead Origin	The name of the source the lead came from.
lead_source_id	TEXT	Lead Origin ID	The unique identifier of the source the lead came from.
lead_status_id	TEXT	Lead Stage ID	The unique identifier of the stage the lead is in.
lead_tags	TEXT	Lead Tags	The comma-separated tags attached to the lead.
lead_updated_at	TIMESTAMP	Lead Updated At	When the lead was last updated.

Kommo Pipelines fields

The Pipelines report of the Kommo connector includes 5 fields.

ID	Type	Name	Description
pipeline_id	TEXT	Pipeline ID	The unique identifier for the pipeline.
pipeline_is_archive	BOOLEAN	Pipeline Is Archive	Whether the pipeline is archived.
pipeline_is_main	BOOLEAN	Pipeline Is Main	Whether the pipeline is the main one of the account.
pipeline_is_unsorted_on	BOOLEAN	Pipeline Incoming Leads Enabled	Whether Incoming Leads are enabled for the pipeline.
pipeline_name	TEXT	Pipeline Name	The name of the pipeline.

Kommo Stages fields

The Stages report of the Kommo connector includes 6 fields.

ID	Type	Name	Description
stage_color	TEXT	Stage Color	The color of the stage in the Kommo interface.
stage_id	TEXT	Stage ID	The unique identifier for the pipeline stage.
stage_is_editable	BOOLEAN	Stage Is Editable	Whether the stage can be edited.
stage_name	TEXT	Stage Name	The name of the pipeline stage.
stage_pipeline_id	TEXT	Stage Pipeline ID	The unique identifier of the pipeline the stage belongs to.
stage_type	TEXT	Stage Type	The type of the stage: 0 for a regular stage, 1 for Incoming Leads.

Kommo Users fields

The Users report of the Kommo connector includes 6 fields.

ID	Type	Name	Description
user_email	TEXT	User Email	The email address of the user.
user_id	TEXT	User ID	The unique identifier for the user.
user_is_active	BOOLEAN	User Is Active	Whether the user is active in the account.
user_is_admin	BOOLEAN	User Is Admin	Whether the user is an administrator of the account.
user_lang	TEXT	User Language	The interface language of the user.
user_name	TEXT	User Name	The name of the user.

Kommo other fields

The Kommo connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors