Adding the data source
Requirements
- Bitrix business plan required
- Follow the instructions below with an admin user
Instructions
1) Login to your Bitrix account, on the left sidebar select “Applications” > “Developer resources”
2) In the new section, select the menu of “Import and export data”
3) In the section that will open, scroll to the end and, in “Assign permissions” and select the option of “CRM (crm)”
4) Scroll up again, copy the value displayed under “Webhook to call REST API” and then click SAVE at the end of the section
5) Login to Kondado, go to add data sources and select the Bitrix 24 CRM data source
6) Give your data source a name and, in “Inbound Webhook URL”, paste the value obtained in step 4 and click SAVE
Now just click on SAVE to start receiving data from Bitrix 24 CRM in your Data Warehouse or Data Lake
Pipelines
Summary
- Actitivity
- Catalogs
- Companies
- Companies: custom fields (data)
- Contacts
- Contacts: companies
- Contacts: custom fields (data)
- Deals
- Deals: custom fields (data)
- Deals: custom fields (meta)
- Deals: pipelines
- Deals: pipelines: stages
- Deals: products
- Deals: quotes
- Deals: quotes: products
- Deals: stage history
- Leads
- Leads: custom fields (data)
- Leads: products
- Products
Relationship Chart
Activity
Field | Type | |
---|---|---|
float |
[en] Activity ID |
|
float |
[en] ID of an entity associated with the activity |
|
float |
||
float |
[en] Autocompletion |
|
text |
[en] Completed |
|
timestamp |
[en] Created |
|
timestamp |
[en] Deadline |
|
text |
[en] Description |
|
float |
[en] Description type |
|
float |
||
float |
[en] Editor |
|
timestamp |
[en] Completion time |
|
timestamp |
||
text |
[en] Location |
|
float |
[en] Notification type |
|
float |
||
text |
[en] Data source ID |
|
text |
[en] Element ID in the data source |
|
float |
[en] Owner |
|
float |
[en] Owner type |
|
float |
[en] Priority |
|
text |
||
text |
||
text |
[en] Provider ID |
|
text |
[en] Provider type ID |
|
float |
||
text |
||
float |
||
text |
||
float |
||
float |
||
text |
||
text |
||
text |
[en] Start time |
|
float |
[en] Status |
|
text |
[en] Subject |
|
float |
[en] Type |
Catalogs
Companies
Field | Type | |
---|---|---|
float |
[en] Company ID |
|
timestamp |
||
text |
[en] Company address |
|
text |
[en] Second page of address string In some countries it is customary to split an address into 2 parts |
|
text |
[en] City |
|
text |
[en] Country |
|
text |
[en] Country code |
|
text |
[en] string |
|
text |
||
text |
[en] Postal code |
|
text |
[en] Province |
|
text |
[en] Region |
|
float |
[en] Associated with user by ID |
|
text |
[en] Banking details |
|
text |
[en] Comments |
|
text |
[en] Company type crm_status |
|
float |
||
text |
[en] Currency |
|
timestamp |
||
text |
||
text |
||
text |
||
text |
[en] Telephone field fill-up check |
|
text |
[en] Sphere of activity |
|
text |
[en] char |
|
float |
[en] ID of the lead, associated with the company |
|
text |
||
float |
||
text |
||
float |
[en] Last modification author ID user |
|
text |
||
text |
[en] Data source ID string Used only to link to an external source. |
|
text |
[en] Element ID in the data source |
|
text |
[en] Original version |
|
text |
[en] Company legal address |
|
text |
||
text |
[en] City listed in legal address |
|
text |
[en] Country listed in legal address |
|
text |
[en] Country code listed in legal address |
|
text |
||
text |
||
text |
||
text |
[en] Region listed in legal address |
|
float |
[en] Annual revenue |
|
text |
[en] Name |
|
text |
[en] Ad campaign designation |
|
text |
[en] Campaign content |
|
text |
[en] Type of traffic |
|
text |
||
text |
[en] Campaign search condition |
Companies: custom fields (data)
Contacts
Field | Type | |
---|---|---|
float |
[en] Contact ID |
|
text |
[en] Contact address |
|
text |
[en] Second page of the address |
|
text |
[en] City |
|
text |
[en] Country |
|
text |
||
text |
[en] Postal code |
|
text |
[en] Province |
|
text |
[en] Region |
|
float |
[en] Associated with user by ID |
|
timestamp |
||
text |
[en] Comments |
|
float |
[en] Associating a contact to a company crm_company Outdated. |
|
float |
||
timestamp |
||
timestamp |
||
text |
[en] Specifies if the contact is included into export. If N, then it is not possible to upload it. |
|
text |
[en] Linking to persons from faceid module |
|
text |
||
text |
||
text |
[en] Telephone field fill-up check |
|
text |
[en] Request type |
|
text |
[en] Last name |
|
text |
[en] Lead ID, associated with the contact |
|
float |
[en] Last modification author ID user |
|
text |
[en] Name |
|
text |
[en] Accessible for all |
|
text |
[en] Data source ID string Used only to link to external source. |
|
text |
[en] Element ID in the data source |
|
text |
[en] Original version |
|
text |
||
float |
||
text |
||
text |
[en] Position |
|
text |
[en] Middle name |
|
text |
||
text |
||
text |
[en] ID type |
|
text |
[en] Advertisement campaign designation |
|
text |
[en] Campaign content |
|
text |
[en] Type of traffic |
|
text |
||
text |
[en] Campaign search condition |
Contacts: companies
Contacts: custom fields (data)
Main Object
Field | Type | |
---|---|---|
float |
[en] Contact ID |
|
timestamp |
||
text |
||
timestamp |
||
float |
||
float |
contacts_custom_fields_data_crm_multiple_c
Deals
Field | Type | |
---|---|---|
float |
[en] Deal ID. It is created automatically and is unique for the database. |
|
text |
[en] Additional information |
|
float |
[en] Associated with a user by ID |
|
timestamp |
[en] Deal opening date |
|
float |
[en] Deal pipeline ID. |
|
text |
[en] Checkmark 'The deal is closed' |
|
timestamp |
[en] Deal closing date |
|
text |
[en] Comments |
|
float |
[en] ID of a company that is a counterpart to the deal |
|
float |
[en] Contact person ID |
|
float |
[en] Deal creator’s ID |
|
text |
[en] Deal currency |
|
timestamp |
[en] Creation date |
|
timestamp |
[en] Modification date |
|
text |
||
text |
||
text |
||
text |
||
text |
||
float |
[en] Lead ID |
|
text |
||
float |
[en] ID of a person who modified the deal |
|
float |
||
timestamp |
||
text |
[en] Checkmark 'Available to everyone' |
|
float |
[en] Amount in deal currency |
|
text |
[en] ID of the external information database. The field assignment can be modified by the end developer. |
|
text |
[en] External key used for exchange operations. ID of an object of the external information database. The field assignment can be modified by the end developer. |
|
float |
[en] Deal conclusion probability (in %) |
|
float |
||
text |
||
text |
||
text |
[en] Deal stage ID |
|
text |
||
float |
||
text |
[en] Deal name. A required field. |
|
text |
[en] Deal type ID. |
|
text |
||
text |
||
text |
||
text |
||
text |
Deals: custom fields (data)
Deals: custom fields (meta)
Main Object
Field | Type | |
---|---|---|
float |
[en] Custom field ID |
|
text |
||
text |
||
text |
[en] Type of custom field |
|
text |
||
text |
[en] Custom field Name |
|
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
text |
||
float |
||
float |
||
float |
||
text |
||
text |
||
float |
||
text |
||
float |
||
text |
||
text |
||
text |
||
text |
||
float |
||
text |
[en] Data type |
|
text |
deals_pipelines__SECTIONS
Field | Type | |
---|---|---|
float |
[en] Custom field ID |
|
text |
||
float |
||
text |
deals_pipelines__LIST
Deals: pipelines
Deals: pipelines: stages
Field | Type | |
---|---|---|
float |
[en] Stage Id |
|
float |
[en] Pipeline ID |
|
text |
[en] Color hex value |
|
text |
||
text |
||
text |
||
text |
[en] Stage Name |
|
text |
||
text |
||
float |
[en] Positional value |
|
text |
[en] Stage progress type |
|
text |
Deals: products
Field | Type | |
---|---|---|
float |
[en] Deal ID |
|
float |
[en] ID of Deal and product relation |
|
text |
||
float |
||
float |
||
float |
||
float |
||
text |
||
text |
||
float |
||
float |
||
float |
||
float |
||
float |
||
float |
||
float |
||
float |
||
float |
||
text |
||
float |
Deals: quotes
Field | Type | |
---|---|---|
float |
[en] Quote ID |
|
float |
[en] Associated with a user by the ID. |
|
timestamp |
||
text |
[en] Closed |
|
timestamp |
||
text |
[en] Manager comment |
|
float |
[en] Linking to company |
|
float |
[en] crm_contact (Outdated. Saved for compatibility.) |
|
text |
[en] Quote content |
|
float |
||
text |
[en] Quote currency |
|
timestamp |
||
timestamp |
||
float |
[en] Deal, associated with a quote |
|
float |
[en] Lead, associated with a quote |
|
text |
[en] Location |
|
float |
[en] ID of the last modification author |
|
float |
[en] Company ID, from which the quote is submitted |
|
text |
[en] Accessible for all |
|
float |
[en] Amount |
|
float |
[en] Payer type ID |
|
float |
[en] Quote number |
|
text |
[en] Status |
|
text |
||
float |
||
float |
[en] Amount sum |
|
text |
[en] Conditions |
|
text |
[en] Name |
|
text |
[en] Advertisement campaign designation |
|
text |
[en] Campaign content |
|
text |
[en] Type of traffic |
|
text |
||
text |
[en] Campaign search condition |
|
text |
Deals: quotes: products
Field | Type | |
---|---|---|
float |
[en] Quote ID |
|
float |
[en] Relationship quote-product ID |
|
text |
||
float |
||
float |
||
float |
||
float |
||
text |
||
text |
||
text |
||
float |
||
float |
||
float |
||
float |
||
float |
||
text |
||
float |
||
text |
||
float |
||
text |
||
float |
||
float |
||
text |
||
float |
Deals: stage history
Field | Type | |
---|---|---|
float |
[en] record ID |
|
float |
||
timestamp |
[en] stage date and time |
|
float |
[en] Deal ID |
|
text |
||
text |
||
float |
[en] record type. Can have the following values: 1 - create entity, 2 - move to an intermediary stage, 3 - move to a final stage |
Leads
Field | Type | |
---|---|---|
float |
[en] Lead ID |
|
text |
[en] Contact address |
|
text |
[en] Second page of the address |
|
text |
[en] City |
|
text |
[en] Country |
|
text |
[en] Country |
|
float |
||
text |
[en] Postal code |
|
text |
[en] Province |
|
text |
[en] Region |
|
float |
[en] Associated with user by ID |
|
timestamp |
||
text |
[en] Comments |
|
float |
[en] Linking a contact to a company |
|
text |
[en] Name of company, associated with a lead |
|
float |
[en] Linking a lead to a contact |
|
float |
||
text |
||
text |
||
timestamp |
||
timestamp |
||
text |
||
text |
||
text |
[en] Telephone field fill-up check |
|
text |
[en] Request |
|
text |
||
text |
||
text |
||
float |
[en] Last modification author ID user |
|
float |
||
timestamp |
||
text |
[en] Name |
|
text |
[en] Accessible for all |
|
float |
||
text |
[en] Data source ID |
|
text |
[en] Element ID in the data source |
|
text |
[en] Position |
|
text |
[en] Second name |
|
text |
[en] Source description? |
|
text |
[en] Source ID |
|
text |
||
text |
||
text |
||
text |
[en] Lead name |
|
text |
[en] Advertisement campaign designation |
|
text |
[en] Campaign content |
|
text |
[en] Type of traffic |
|
text |
[en] Advertisement system |
|
text |
[en] Campaign search condition |
|
text |
Leads: custom fields (data)
Leads: products
Field | Type | |
---|---|---|
float |
[en] Lead ID |
|
float |
[en] Relation product-lead id |
|
text |
||
float |
[en] Product discount |
|
float |
||
float |
||
float |
||
text |
||
text |
||
text |
||
float |
[en] Product price |
|
float |
||
float |
||
float |
||
float |
||
text |
||
float |
[en] Product ID |
|
text |
[en] product name |
|
float |
[en] product quantity |
|
text |
||
float |
||
float |
||
text |
||
float |