Bitrix24
Выгружайте CRM-данные из Bitrix24 напрямую в ваше хранилище с помощью Renta. Централизуйте сделки, лиды, контакты, компании и пользовательские поля для расширенной аналитики, отчётности по воронке продаж и отслеживания конверсий — без единой строки кода.
Аутентификация
Renta подключается к Bitrix24 через входящий вебхук — постоянный токен с ограниченными правами, который генерируется прямо в вашем портале Bitrix24. OAuth-авторизация и установка сторонних приложений не требуются.
Подключите источник Bitrix24
Настройка интеграции займет около пяти минут. Вам нужно создать входящий вебхук в портале Bitrix24 и вставить его URL в Renta.
Создайте входящий вебхукStep 1
В левом боковом меню Bitrix24 перейдите в Разработчикам > Другое > Входящий вебхук. Если раздел не отображается, обратитесь к администратору портала.
- Вебхук для вызова REST API.
Скопируйте этот URL — он понадобится на следующем шаге. - Настройка прав.
Выберите как минимум CRM (crm) и Пользователи (user). Вы можете добавить другие права (например, Задачи, Телефония) на будущее. Права доступа можно обновить в любое время без изменения URL вебхука. - Сохранить.
Нажмите на кнопку сохранения.
Перейдите в каталог подключенийStep 2
В Renta откройте Connections > Catalog. Найдите Bitrix24 в категории CRM и кликните по карточке, чтобы открыть форму добавления.
Добавьте новый источник Bitrix24Step 3
Заполните форму подключения:
- Source name.
Укажите понятное название источника. - Webhook URL.
Вставьте скопированный из Bitrix24 URL вебхука. - Save.
Нажмите Save. Renta проверит ссылку на доступность портала и наличие необходимых прав.
Настройки пайплайна
При создании пайплайна с источник ом Bitrix24 настройте следующие параметры.
Типы отчётов
Выберите CRM-объект для выгрузки. Каждый тип отчёта соответствует одной таблице в хранилище и одному методу Bitrix24 REST API.
| Тип отчёта | Метод Bitrix24 API | Описание |
|---|---|---|
| Deals (сделки) | crm.deal.list | Сделки со стадией, воронкой, суммой и ответственным менеджером. |
| Leads (лиды) | crm.lead.list | Входящие лиды с источником, статусом, телефоном, email и пользовательскими полями. |
| Contacts (контакты) | crm.contact.list | Отдельные контактные лица, связанные с компаниями, сделками и лидами. |
| Companies (компании) | crm.company.list | Профили компаний с отраслью, выручкой и контактными данными. |
| Activities (активности) | crm.activity.list | CRM-активности: звонки, письма и встречи, привязанные к сделкам или лидам. |
| Users (пользователи) | user.get | Пользователи портала Bitrix24 — используются для джойнов по полям assigned_by_id и responsible_id. |
| Deal categories (воронки) | crm.dealcategory.list | Описание воронок продаж: названия и порядок сортировки. |
| Deal stages (стадии) | crm.status.list | Стадии всех воронок с названиями, цветами и семантическими метками (выиграно/проиграно/в работе). |
| Currencies (валюты) | crm.currency.list | Справочник валют с кодами, символами и курсами. Базовая валюта задаётся на уровне портала. |
| Userfields (поля) | crm.*.userfield.list | Метаданные всех пользовательских полей (UF_CRM_*) по сделкам, лидам, контактам и компаниям: названия, типы и значения перечислений. |
Параметры
Выберите конкретные поля, которые нужно включить в таблицу назначения. Структура датасета полностью определяется выбранными параметрами. Невыбранные поля не попадут в выгрузку.
| Название | Имя в API | Описание |
|---|---|---|
Id · Обязательный text | id | Unique identifier. |
Title text | title | Title/name of the record. |
Type Id text | type_id | Type code. |
Stage Id text | stage_id | Current stage code in the pipeline. |
Previous Stage Id text | previous_stage_id | Previous stage code before the last transition. |
Probability text | probability | Deal probability of success (percent). |
Currency Id text | currency_id | ISO currency code (RUB, KZT, USD, ...). |
Opportunity text | opportunity | Monetary amount (stored as string). |
Is Manual Opportunity text | is_manual_opportunity | "Y"/"N" — whether OPPORTUNITY was set manually. |
Tax Value text | tax_value | Tax value for the monetary amount. |
Lead Id text | lead_id | Related lead ID. |
Company Id text | company_id | Related company ID. |
Contact Id text | contact_id | Related contact ID. |
Quote Id text | quote_id | Related quote ID. |
Begindate datetime | begindate | Planned start date. |
Closedate datetime | closedate | Planned close date. |
Assigned By Id text | assigned_by_id | ID of the user responsible for the record. |
Created By Id text | created_by_id | ID of the user who created the record. |
Modify By Id text | modify_by_id | ID of the user who last modified the record. |
Date Create datetime | date_create | Creation timestamp. |
Date Modify · Обязательный datetime | date_modify | Last modification timestamp. |
Opened text | opened | "Y"/"N" — whether the record is public. |
Closed text | closed | "Y"/"N" — whether the record is closed. |
Comments text | comments | Free-form comments. |
Additional Info text | additional_info | Additional Info field from Bitrix24 API. |
Location Id text | location_id | Location Id field from Bitrix24 API. |
Category Id text | category_id | Pipeline (deal category) ID. |
Stage Semantic Id text | stage_semantic_id | Stage semantic: P=in-progress, S=success, F=failed. |
Is New text | is_new | "Y"/"N" — new record flag. |
Is Recurring text | is_recurring | "Y"/"N" — whether the record is recurring. |
Is Return Customer text | is_return_customer | "Y"/"N" — repeat customer flag. |
Is Repeated Approach text | is_repeated_approach | "Y"/"N" — repeated approach flag. |
Source Id text | source_id | Lead/traffic source code. |
Source Description text | source_description | Free-form description of the lead source. |
Originator Id text | originator_id | External system identifier that created the record. |
Origin Id text | origin_id | External record identifier in the originating system. |
Moved By Id text | moved_by_id | ID of the user who moved the record to the current stage. |
Moved Time datetime | moved_time | Timestamp when the record was moved to the current stage. |
Last Activity Time datetime | last_activity_time | Timestamp of the last activity on the record. |
Utm Source text | utm_source | UTM source marker. |
Utm Medium text | utm_medium | UTM medium marker. |
Utm Campaign text | utm_campaign | UTM campaign marker. |
Utm Content text | utm_content | UTM content marker. |
Utm Term text | utm_term | UTM term marker. |
Last Communication Time datetime | last_communication_time | Timestamp of the last communication. |
Last Activity By text | last_activity_by | ID of the user who performed the last activity. |
Custom fields values structure | custom_fields_values | User-defined fields (UF_CRM_*) from Bitrix24 admin panel. Each element carries the Bitrix24 field key and its serialized value. Metadata fields field_id / field_name / field_type are populated from crm.{entity}.userfield.list at pipeline start. is_computed stays NULL (Bitrix24 has no equivalent). |
Partition Date · Обязательный date | partition_date | Creation day derived from DATE_CREATE, truncated to a date. Partition key of the destination table: day granularity keeps the incremental MERGE cheap and its partition list small. |
| Название | Имя в API | Описание |
|---|---|---|
Id · Обязательный text | id | Unique identifier. |
Title text | title | Title/name of the record. |
Honorific text | honorific | Honorific (Mr./Mrs./...). |
Name text | name | First name. |
Second Name text | second_name | Middle name. |
Last Name text | last_name | Last name. |
Company Title text | company_title | Name of the related company. |
Company Id text | company_id | Related company ID. |
Contact Id text | contact_id | Related contact ID. |
Is Return Customer text | is_return_customer | "Y"/"N" — repeat customer flag. |
Birthdate datetime | birthdate | Birth date. |
Source Id text | source_id | Lead/traffic source code. |
Source Description text | source_description | Free-form description of the lead source. |
Status Id text | status_id | Current status code. |
Status Description text | status_description | Free-form status description. |
Post text | post | Job title/position. |
Comments text | comments | Free-form comments. |
Currency Id text | currency_id | ISO currency code (RUB, KZT, USD, ...). |
Opportunity text | opportunity | Monetary amount (stored as string). |
Is Manual Opportunity text | is_manual_opportunity | "Y"/"N" — whether OPPORTUNITY was set manually. |
Has Phone text | has_phone | "Y"/"N" — phone is present. |
Has Email text | has_email | "Y"/"N" — email is present. |
Has Imol text | has_imol | "Y"/"N" — Open Line channel is present. |
Assigned By Id text | assigned_by_id | ID of the user responsible for the record. |
Created By Id text | created_by_id | ID of the user who created the record. |
Modify By Id text | modify_by_id | ID of the user who last modified the record. |
Date Create datetime | date_create | Creation timestamp. |
Date Modify · Обязательный datetime | date_modify | Last modification timestamp. |
Date Closed datetime | date_closed | Date the record was closed. |
Status Semantic Id text | status_semantic_id | Status semantic: P=in-progress, S=success, F=failed. |
Opened text | opened | "Y"/"N" — whether the record is public. |
Originator Id text | originator_id | External system identifier that created the record. |
Origin Id text | origin_id | External record identifier in the originating system. |
Moved By Id text | moved_by_id | ID of the user who moved the record to the current stage. |
Moved Time datetime | moved_time | Timestamp when the record was moved to the current stage. |
Address text | address | Physical address, line 1. |
Address 2 text | address_2 | Physical address, line 2. |
Address City text | address_city | City. |
Address Postal Code text | address_postal_code | Postal code. |
Address Region text | address_region | Region / state. |
Address Province text | address_province | Province. |
Address Country text | address_country | Country name. |
Address Country Code text | address_country_code | ISO country code. |
Address Loc Addr Id text | address_loc_addr_id | Internal Bitrix24 location-address ID. |
Utm Source text | utm_source | UTM source marker. |
Utm Medium text | utm_medium | UTM medium marker. |
Utm Campaign text | utm_campaign | UTM campaign marker. |
Utm Content text | utm_content | UTM content marker. |
Utm Term text | utm_term | UTM term marker. |
Last Communication Time datetime | last_communication_time | Timestamp of the last communication. |
Last Activity By text | last_activity_by | ID of the user who performed the last activity. |
Last Activity Time datetime | last_activity_time | Timestamp of the last activity on the record. |
Phone structure | phone | Multi-valued phone list. Each element carries VALUE_TYPE (WORK/MOBILE/HOME/...), VALUE (number), and TYPE_ID=PHONE. |
Email structure | email | Multi-valued email list. Each element: VALUE_TYPE, VALUE (address), TYPE_ID=EMAIL. |
Web structure | web | Multi-valued website list. Each element: VALUE_TYPE, VALUE (URL), TYPE_ID=WEB. |
Im structure | im | Multi-valued IM / messenger list. Each element: VALUE_TYPE (SKYPE/TELEGRAM/WHATSAPP/...), VALUE (handle), TYPE_ID=IM. |
Custom fields values structure | custom_fields_values | User-defined fields (UF_CRM_*) from Bitrix24 admin panel. Each element carries the Bitrix24 field key and its serialized value. Metadata fields field_id / field_name / field_type are populated from crm.{entity}.userfield.list at pipeline start. is_computed stays NULL (Bitrix24 has no equivalent). |
Partition Date · Обязательный date | partition_date | Creation day derived from DATE_CREATE, truncated to a date. Partition key of the destination table: day granularity keeps the incremental MERGE cheap and its partition list small. |
| Название | Имя в API | Описание |
|---|---|---|
Id · Обязательный text | id | Unique identifier. |
Post text | post | Job title/position. |
Comments text | comments | Free-form comments. |
Honorific text | honorific | Honorific (Mr./Mrs./...). |
Name text | name | First name. |
Second Name text | second_name | Middle name. |
Last Name text | last_name | Last name. |
Photo text | photo | Photo file reference. |
Lead Id text | lead_id | Related lead ID. |
Type Id text | type_id | Type code. |
Source Id text | source_id | Lead/traffic source code. |
Source Description text | source_description | Free-form description of the lead source. |
Company Id text | company_id | Related company ID. |
Birthdate datetime | birthdate | Birth date. |
Export text | export | "Y"/"N" — include in export flag. |
Has Phone text | has_phone | "Y"/"N" — phone is present. |
Has Email text | has_email | "Y"/"N" — email is present. |
Has Imol text | has_imol | "Y"/"N" — Open Line channel is present. |
Date Create datetime | date_create | Creation timestamp. |
Date Modify · Обязательный datetime | date_modify | Last modification timestamp. |
Assigned By Id text | assigned_by_id | ID of the user responsible for the record. |
Created By Id text | created_by_id | ID of the user who created the record. |
Modify By Id text | modify_by_id | ID of the user who last modified the record. |
Opened text | opened | "Y"/"N" — whether the record is public. |
Originator Id text | originator_id | External system identifier that created the record. |
Origin Id text | origin_id | External record identifier in the originating system. |
Origin Version text | origin_version | Version of the originating external record. |
Address text | address | Physical address, line 1. |
Address 2 text | address_2 | Physical address, line 2. |
Address City text | address_city | City. |
Address Postal Code text | address_postal_code | Postal code. |
Address Region text | address_region | Region / state. |
Address Province text | address_province | Province. |
Address Country text | address_country | Country name. |
Address Loc Addr Id text | address_loc_addr_id | Internal Bitrix24 location-address ID. |
Utm Source text | utm_source | UTM source marker. |
Utm Medium text | utm_medium | UTM medium marker. |
Utm Campaign text | utm_campaign | UTM campaign marker. |
Utm Content text | utm_content | UTM content marker. |
Utm Term text | utm_term | UTM term marker. |
Last Communication Time datetime | last_communication_time | Timestamp of the last communication. |
Last Activity By text | last_activity_by | ID of the user who performed the last activity. |
Last Activity Time datetime | last_activity_time | Timestamp of the last activity on the record. |
Phone structure | phone | Multi-valued phone list. Each element carries VALUE_TYPE (WORK/MOBILE/HOME/...), VALUE (number), and TYPE_ID=PHONE. |
Email structure | email | Multi-valued email list. Each element: VALUE_TYPE, VALUE (address), TYPE_ID=EMAIL. |
Web structure | web | Multi-valued website list. Each element: VALUE_TYPE, VALUE (URL), TYPE_ID=WEB. |
Im structure | im | Multi-valued IM / messenger list. Each element: VALUE_TYPE (SKYPE/TELEGRAM/WHATSAPP/...), VALUE (handle), TYPE_ID=IM. |
Custom fields values structure | custom_fields_values | User-defined fields (UF_CRM_*) from Bitrix24 admin panel. Each element carries the Bitrix24 field key and its serialized value. Metadata fields field_id / field_name / field_type are populated from crm.{entity}.userfield.list at pipeline start. is_computed stays NULL (Bitrix24 has no equivalent). |
Partition Date · Обязательный date | partition_date | Creation day derived from DATE_CREATE, truncated to a date. Partition key of the destination table: day granularity keeps the incremental MERGE cheap and its partition list small. |
| Название | Имя в API | Описание |
|---|---|---|
Id · Обязательный text | id | Unique identifier. |
Company Type text | company_type | Company type: CUSTOMER, SUPPLIER, ... |
Title text | title | Title/name of the record. |
Logo text | logo | Logo file reference. |
Lead Id text | lead_id | Related lead ID. |
Has Phone text | has_phone | "Y"/"N" — phone is present. |
Has Email text | has_email | "Y"/"N" — email is present. |
Has Imol text | has_imol | "Y"/"N" — Open Line channel is present. |
Assigned By Id text | assigned_by_id | ID of the user responsible for the record. |
Created By Id text | created_by_id | ID of the user who created the record. |
Modify By Id text | modify_by_id | ID of the user who last modified the record. |
Banking Details text | banking_details | Banking details. |
Industry text | industry | Industry code. |
Revenue text | revenue | Annual revenue (string). |
Currency Id text | currency_id | ISO currency code (RUB, KZT, USD, ...). |
Employees text | employees | Employee count range code. |
Comments text | comments | Free-form comments. |
Date Create datetime | date_create | Creation timestamp. |
Date Modify · Обязательный datetime | date_modify | Last modification timestamp. |
Opened text | opened | "Y"/"N" — whether the record is public. |
Is My Company text | is_my_company | "Y"/"N" — whether this is the portal-owner company. |
Originator Id text | originator_id | External system identifier that created the record. |
Origin Id text | origin_id | External record identifier in the originating system. |
Origin Version text | origin_version | Version of the originating external record. |
Address text | address | Physical address, line 1. |
Address 2 text | address_2 | Physical address, line 2. |
Address City text | address_city | City. |
Address Postal Code text | address_postal_code | Postal code. |
Address Region text | address_region | Region / state. |
Address Province text | address_province | Province. |
Address Country text | address_country | Country name. |
Address Country Code text | address_country_code | ISO country code. |
Address Loc Addr Id text | address_loc_addr_id | Internal Bitrix24 location-address ID. |
Address Legal text | address_legal | Legal address. |
Reg Address text | reg_address | Registered address, line 1. |
Reg Address 2 text | reg_address_2 | Registered address, line 2. |
Reg Address City text | reg_address_city | Registered city. |
Reg Address Postal Code text | reg_address_postal_code | Registered postal code. |
Reg Address Region text | reg_address_region | Registered region. |
Reg Address Province text | reg_address_province | Registered province. |
Reg Address Country text | reg_address_country | Registered country. |
Reg Address Country Code text | reg_address_country_code | Registered country ISO code. |
Reg Address Loc Addr Id text | reg_address_loc_addr_id | Internal Bitrix24 registered-location-address ID. |
Utm Source text | utm_source | UTM source marker. |
Utm Medium text | utm_medium | UTM medium marker. |
Utm Campaign text | utm_campaign | UTM campaign marker. |
Utm Content text | utm_content | UTM content marker. |
Utm Term text | utm_term | UTM term marker. |
Last Activity By text | last_activity_by | ID of the user who performed the last activity. |
Last Activity Time datetime | last_activity_time | Timestamp of the last activity on the record. |
Last Communication Time datetime | last_communication_time | Timestamp of the last communication. |
Phone structure | phone | Multi-valued phone list. Each element carries VALUE_TYPE (WORK/MOBILE/HOME/...), VALUE (number), and TYPE_ID=PHONE. |
Email structure | email | Multi-valued email list. Each element: VALUE_TYPE, VALUE (address), TYPE_ID=EMAIL. |
Web structure | web | Multi-valued website list. Each element: VALUE_TYPE, VALUE (URL), TYPE_ID=WEB. |
Im structure | im | Multi-valued IM / messenger list. Each element: VALUE_TYPE (SKYPE/TELEGRAM/WHATSAPP/...), VALUE (handle), TYPE_ID=IM. |
Custom fields values structure | custom_fields_values | User-defined fields (UF_CRM_*) from Bitrix24 admin panel. Each element carries the Bitrix24 field key and its serialized value. Metadata fields field_id / field_name / field_type are populated from crm.{entity}.userfield.list at pipeline start. is_computed stays NULL (Bitrix24 has no equivalent). |
Partition Date · Обязательный date | partition_date | Creation day derived from DATE_CREATE, truncated to a date. Partition key of the destination table: day granularity keeps the incremental MERGE cheap and its partition list small. |
| Название | Имя в API | Описание |
|---|---|---|
Id · Обязательный text | id | Unique identifier. |
Owner Id text | owner_id | ID of the CRM entity the activity is bound to. |
Owner Type Id text | owner_type_id | Entity type the activity is bound to: 1=lead, 2=deal, 3=contact, 4=company. |
Type Id text | type_id | Type code. |
Provider Id text | provider_id | Activity provider code (CRM_TODO, CRM_CALL, ...). |
Provider Type Id text | provider_type_id | Provider sub-type code. |
Provider Group Id text | provider_group_id | Provider group code. |
Associated Entity Id text | associated_entity_id | ID of the related entity produced by the activity. |
Subject text | subject | Activity subject line. |
Created datetime | created | Activity creation timestamp. |
Last Updated · Обязательный datetime | last_updated | Last update timestamp (used as incremental filter field). |
Start Time datetime | start_time | Activity start timestamp. |
End Time datetime | end_time | Activity end timestamp. |
Deadline datetime | deadline | Activity deadline. |
Completed text | completed | "Y"/"N" — completion flag. |
Status text | status | Activity status code. |
Responsible Id text | responsible_id | ID of the user responsible for the activity. |
Priority text | priority | Priority code. |
Notify Type text | notify_type | Notification type code. |
Notify Value text | notify_value | Notification value. |
Description text | description | Activity description. |
Description Type text | description_type | Description format type code. |
Direction text | direction | Direction code: 0=none, 1=incoming, 2=outgoing. |
Location text | location | Activity location. |
Settings json | settings | Provider-specific settings payload (dynamic keys). |
Originator Id text | originator_id | External system identifier that created the record. |
Origin Id text | origin_id | External record identifier in the originating system. |
Author Id text | author_id | ID of the activity author. |
Editor Id text | editor_id | ID of the user who last edited the activity. |
Provider Params json | provider_params | Provider-specific parameters (heterogeneous list/object). |
Provider Data text | provider_data | Provider-specific raw data. |
Result Mark text | result_mark | Result mark code. |
Result Value text | result_value | Result numeric value. |
Result Sum text | result_sum | Result monetary amount. |
Result Currency Id text | result_currency_id | Result currency ISO code. |
Result Status text | result_status | Result status code. |
Result Stream text | result_stream | Result stream code. |
Result Source Id text | result_source_id | Source ID inside the result object. |
Autocomplete Rule text | autocomplete_rule | Autocomplete rule code. |
Partition Date · Обязательный date | partition_date | Creation day derived from CREATED, truncated to a date. Partition key of the destination table: day granularity keeps the incremental MERGE cheap and its partition list small. |
| Название | Имя в API | Описание |
|---|---|---|
Id text | id | Unique identifier. |
Xml Id text | xml_id | External system identifier. |
Active bool | active | Whether the user account is active. |
Name text | name | First name. |
Last Name text | last_name | Last name. |
Email text | email | Primary email address. |
Last Login datetime | last_login | Timestamp of the last login. |
Date Register datetime | date_register | Date the user registered on the portal. |
Time Zone text | time_zone | User timezone name (IANA). |
Is Online text | is_online | "Y"/"N" — online presence flag. |
Timestamp X json | timestamp_x | Record version timestamp wrapped by Bitrix24 (heterogeneous dict). |
Last Activity Date json | last_activity_date | Last activity timestamp per department (heterogeneous dict). |
Personal Gender text | personal_gender | Gender code (M/F/""). |
Personal Birthday text | personal_birthday | Birth date (YYYY-MM-DD or empty string). |
Uf Employment Date datetime | uf_employment_date | User-field: employment date. |
Uf Department array_int | uf_department | Array of department IDs the user belongs to. |
User Type text | user_type | User type code (employee / extranet / ...). |
| Название | Имя в API | Описание |
|---|---|---|
Id text | id | Unique identifier. |
Created Date datetime | created_date | Pipeline creation timestamp. |
Name text | name | First name. |
Sort text | sort | Sort order weight (ascending). |
Is Locked text | is_locked | "Y"/"N" — pipeline is locked from editing. |
| Название | Имя в API | Описание |
|---|---|---|
Id text | id | Unique identifier. |
Entity Id text | entity_id | Directory entity ID (e.g. STATUS, SOURCE, DEAL_STAGE_0). |
Status Id text | status_id | Current status code. |
Name text | name | First name. |
Name Init text | name_init | Original name before localization. |
Sort text | sort | Sort order weight (ascending). |
System text | system | "Y"/"N" — whether the status is system-owned. |
Color text | color | Color hex code for UI rendering. |
Semantics text | semantics | Semantic code (success/failure/in-progress) or null. |
Category Id text | category_id | Pipeline (deal category) ID. |
| Название | Имя в API | Описание |
|---|---|---|
Currency text | currency | ISO currency code (primary key). |
Amount Cnt text | amount_cnt | Amount-per-unit multiplier. |
Amount text | amount | Exchange rate relative to the base currency. |
Sort text | sort | Sort order weight (ascending). |
Base text | base | "Y"/"N" — whether this is the base currency of the portal. |
Full Name text | full_name | Full localized name of the currency. |
Lid text | lid | Locale ID used for the full name. |
Format String text | format_string | Formatting template for amount rendering. |
Dec Point text | dec_point | Decimal separator character. |
Thousands Sep text | thousands_sep | Thousands separator (HTML-encoded). |
Decimals text | decimals | Number of decimal places. |
Date Update datetime | date_update | Timestamp of the last rate update. |
| Название | Имя в API | Описание |
|---|---|---|
Id text | id | Bitrix24 userfield numeric ID (primary key within entity_id scope). |
Entity Id text | entity_id | CRM entity the userfield belongs to: CRM_DEAL, CRM_LEAD, CRM_CONTACT, CRM_COMPANY. |
Field Name text | field_name | Field key used in crm.{entity}.list responses (e.g. UF_CRM_1234567890). |
User Type Id text | user_type_id | Userfield type code: string, integer, enumeration, datetime, boolean, double, file, employee, iblock_section, ... |
Xml Id text | xml_id | External-system identifier of the userfield. |
Sort text | sort | Sort order weight (ascending). |
Multiple text | multiple | "Y"/"N" — whether the field accepts multiple values. |
Mandatory text | mandatory | "Y"/"N" — whether the field is required when creating/updating the record. |
Show Filter text | show_filter | How the field appears in filters: "N" hidden, "I" exact match, "E" substring, "Y" default. |
Show In List text | show_in_list | "Y"/"N" — whether the field is displayed in the list view. |
Edit In List text | edit_in_list | "Y"/"N" — whether inline editing is allowed in the list view. |
Is Searchable text | is_searchable | "Y"/"N" — whether the field participates in full-text search. |
Edit Form Label text | edit_form_label | Human-readable label shown on the edit form (localized via filter.LANG). |
List Column Label text | list_column_label | Column header label in the list view (localized). |
List Filter Label text | list_filter_label | Label shown above the field in filter UI. |
Error Message text | error_message | Custom validation error message (localized). |
Help Message text | help_message | Help tooltip text (localized). |
User Type Owner text | user_type_owner | Identifier of the marketplace app that registered a custom user_type_id (present only for app-defined types). |
Settings json | settings | Type-specific configuration payload (e.g. list display mode, default value, min/max). Raw JSON object. |
List json | list | Enumeration values (only present for user_type_id='enumeration'). Each element has ID, VALUE, SORT, DEF (default flag), XML_ID. |
Date range
Пользователь может не выгружать все записи (например, все лиды), а ограничить их через Date range. В Date range мы указываем период, и учитывается поле DATE_MODIFY, по которому фильтруются данные. То есть, если нужны лиды, которые были обновлены после какого-то периода, для этого можно использовать Date range.
Стратегия синхрониз ации
В таблице ниже описано, как Renta синхронизирует каждый тип отчёта Bitrix24.
| Стратегия | Типы отчётов | Описание |
|---|---|---|
| Инкрементальная (merge) | Deals, Leads, Contacts, Companies, Activities | Renta загружает только записи, изменённые с момента последнего успешного запуска, используя фильтр Bitrix24 по полю DATE_MODIFY. Записи обновляются (upsert) в таблице назначения по уникальному полю id. К окну выборки применяется трёхчасовой защитный нахлёст для учёта задержек репликации в Bitrix24 — дубликаты автоматически схлопываются на стороне хранилища. |
| Полная выгрузка | Users, Deal categories, Deal stages, Currencies, Userfields | Эти таблицы являются справочниками настроек и не имеют поля с датой изменения. Renta перезагружает весь датасет при каждом запуске. Такие таблицы небольшие (как правило, менее 500 строк), поэтому влияние на производительность незначительно. |
Пользовательские поля
Администраторы портала Bitrix24 могут добавлять пользовательские поля (с префиксом UF_CRM_) к сделкам, лидам, контактам и компаниям. Renta автоматически захватывает все пользовательские поля — ручная настройка схемы не требуется.
Значения пользовательских полей хранятся в колонке custom_fields_values в виде структурированного массива. Каждый элемент массива содержит:
| Подполе | Описание |
|---|---|
| field_code | Внутренний ключ поля в Bitrix24, например UF_CRM_1719402824087. |
| field_name | Читаемое название поля, заданное в админ-панели Bitrix24, например «Оценка качества лида». |
| field_type | Тип данных поля, как он определён в Bitrix24: string, integer, enumeration, boolean, datetime и др. |
| field_value | Значение поля для данной записи, сохранённое как текстовая строка. Списочные значения сериализуются в JSON. |
| field_id | Числовой идентификатор определения поля. |
| is_computed | Признак, вычисляется ли поле автоматически средствами Bitrix24. |
Для запроса пользовательских полей в BigQuery разверните массив и фильтруйте по коду или названию поля:
SELECT
id,
title,
cf.field_name AS custom_label,
cf.field_value AS custom_value,
cf.field_type AS custom_type
FROM `project.dataset.deals` d,
UNNEST(custom_fields_values) AS cf
WHERE cf.field_name = 'Оценка качества лида';Тип отчёта Userfields выгружает отдельную справочную таблицу, в которой каждому ключу UF_CRM_* сопоставлены его название, тип и — для полей-перечислений — полный список допустимых значений. Соедините эту таблицу с custom_fields_values, чтобы декодировать числовые идентификаторы перечислений в читаемые названия.
Многозначные поля
Для лидов, контактов и компаний Bitrix24 хранит телефонные номера, email-адреса, ссылки на сайты и мессенджеры как многозначные поля. Renta выгружает каждое из них в виде структурированного массива.
| Колонка | Содержимое |
|---|---|
| phone | Телефонные номера со значением и типом (Work, Home, Mobile, Fax и др.). |
| Email-адреса со значением и типом (Work, Home и др.). | |
| web | URL сайтов со значением и типом (Work, Home, Facebook и др.). |
| im | Идентификаторы мессенджеров со значением и типом (Telegram, WhatsApp, Skype и др.). |
Чтобы выгрузить рабочие телефонные номера лидов в BigQuery:
SELECT
id,
title,
p.value AS phone_number
FROM `project.dataset.leads` l,
UNNEST(phone) AS p
WHERE p.value_type = 'WORK';Расписание синхронизации
Часто задаваемые вопросы
Ready to get started?
Build your data pipeline today or get a personalized demo. Start free!
Need help?
Get expert support to ensure your project succeeds. We're here to help!
Feature requests?
Help shape our product! Share your ideas for new features and integrations.