Bitrix24 CRM

Adicionando o conector

Baseado na documentação da API do Bitrix

Este conector está em modo beta

Requisitos

Instruções

1) Faça login na sua conta do Bitrix, na barra lateral esquerda, selecione “Applications” > “Developer resources”

2) Na nova seção, selecione o menu de “Import and export data”

3) Na seção que irá abrir, role até o final e, em “Assign permissions” e selecione a opção de “CRM (crm)”

4) Role para cima novamente, copie o valor exibido em “Webhook to call REST API” e depois clique em SALVAR ao final da seção

5) Faça login na plataforma da Kondado, vá para a seção de acionar conectores e selecione o conector do Bitrix24 CRM

6) Dê um nome para o seu conector e, em “Inbound Webhook URL”, cole o valor obtido no passo 4 e clique em SALVAR

Agora basta clicar em SALVAR para começar a receber dados do Bitrix24 CRM no seu Data Warehouse ou Data Lake

Integrações

Índice

Gráfico de relacionamento

Clique para ampliar

Activity

Campo Tipo

id

float

[en] Activity ID

associated_entity_id

float

[en] ID of an entity associated with the activity

author_id

float

autocomplete_rule

float

[en] Autocompletion

completed

text

[en] Completed

created

timestamp

[en] Created

deadline

timestamp

[en] Deadline

description

text

[en] Description

description_type

float

[en] Description type

direction

float

editor_id

float

[en] Editor

end_time

timestamp

[en] Completion time

last_updated

timestamp

location

text

[en] Location

notify_type

float

[en] Notification type

notify_value

float

originator_id

text

[en] Data source ID

origin_id

text

[en] Element ID in the data source

owner_id

float

[en] Owner

owner_type_id

float

[en] Owner type

priority

float

[en] Priority

provider_data

text

provider_group_id

text

provider_id

text

[en] Provider ID

provider_type_id

text

[en] Provider type ID

responsible_id

float

result_currency_id

text

result_mark

float

result_source_id

text

result_status

float

result_stream

float

result_sum

text

result_value

text

start_time

text

[en] Start time

status

float

[en] Status

subject

text

[en] Subject

type_id

float

[en] Type

Catalogs

Campo Tipo

id

float

[en] Catalog Id

name

text

[en] Catalog Name

originator_id

text

origin_id

text

xml_id

text

Companies

Campo Tipo

company_id

float

[en] Company ID

date_modify

timestamp

address

text

[en] Company address

address_2

text

[en] Second page of address string In some countries it is customary to split an address into 2 parts

address_city

text

[en] City

address_country

text

[en] Country

address_country_code

text

[en] Country code

address_legal

text

[en] string

address_loc_addr_id

text

address_postal_code

text

[en] Postal code

address_province

text

[en] Province

address_region

text

[en] Region

assigned_by_id

float

[en] Associated with user by ID

banking_details

text

[en] Banking details

comments

text

[en] Comments

company_type

text

[en] Company type crm_status

created_by_id

float

currency_id

text

[en] Currency

date_create

timestamp

employees

text

has_email

text

has_imol

text

has_phone

text

[en] Telephone field fill-up check

industry

text

[en] Sphere of activity

is_my_company

text

[en] char

lead_id

float

[en] ID of the lead, associated with the company

    Leads > > lead_id

logo_downloadurl

text

logo_id

float

logo_showurl

text

modify_by_id

float

[en] Last modification author ID user

opened

text

originator_id

text

[en] Data source ID string Used only to link to an external source.

origin_id

text

[en] Element ID in the data source

origin_version

text

[en] Original version

reg_address

text

[en] Company legal address

reg_address_2

text

reg_address_city

text

[en] City listed in legal address

reg_address_country

text

[en] Country listed in legal address

reg_address_country_code

text

[en] Country code listed in legal address

reg_address_loc_addr_id

text

reg_address_postal_code

text

reg_address_province

text

reg_address_region

text

[en] Region listed in legal address

revenue

float

[en] Annual revenue

title

text

[en] Name

utm_campaign

text

[en] Ad campaign designation

utm_content

text

[en] Campaign content

utm_medium

text

[en] Type of traffic

utm_source

text

utm_term

text

[en] Campaign search condition

Companies: custom fields (data)

Objeto principal

Campo Tipo

company_id

float

    Companies > > company_id

date_modify

timestamp

fdjuighl

float

new_field

float

companies_custom_fields_data_crm_multiple_c

Campo Tipo

company_id

float

[en] Company Id

crm_multiple_a

text

Contacts

Campo Tipo

contact_id

float

[en] Contact ID

address

text

[en] Contact address

address_2

text

[en] Second page of the address

address_city

text

[en] City

address_country

text

[en] Country

address_loc_addr_id

text

address_postal_code

text

[en] Postal code

address_province

text

[en] Province

address_region

text

[en] Region

assigned_by_id

float

[en] Associated with user by ID

birthdate

timestamp

comments

text

[en] Comments

company_id

float

[en] Associating a contact to a company crm_company Outdated.

    Companies > > company_id

created_by_id

float

date_create

timestamp

date_modify

timestamp

export

text

[en] Specifies if the contact is included into export. If N, then it is not possible to upload it.

face_id

text

[en] Linking to persons from faceid module

has_email

text

has_imol

text

has_phone

text

[en] Telephone field fill-up check

honorific

text

[en] Request type

last_name

text

[en] Last name

lead_id

text

[en] Lead ID, associated with the contact

    Leads > > lead_id

modify_by_id

float

[en] Last modification author ID user

name

text

[en] Name

opened

text

[en] Accessible for all

originator_id

text

[en] Data source ID string Used only to link to external source.

origin_id

text

[en] Element ID in the data source

origin_version

text

[en] Original version

photo_downloadurl

text

photo_id

float

photo_showurl

text

post

text

[en] Position

second_name

text

[en] Middle name

source_description

text

source_id

text

type_id

text

[en] ID type

utm_campaign

text

[en] Advertisement campaign designation

utm_content

text

[en] Campaign content

utm_medium

text

[en] Type of traffic

utm_source

text

utm_term

text

[en] Campaign search condition

Contacts: companies

Campo Tipo

contact_id

float

[en] Contact ID

    Contacts > > contact_id

company_id

float

[en] Company id

    Companies > > company_id

is_primary

text

role_id

float

[en] Company role id

sort

float

Contacts: custom fields (data)

Objeto principal

Campo Tipo

contact_id

float

[en] Contact ID

    Contacts > > contact_id

date_modify

timestamp

uf_crm_x

text

uf_crm_y

timestamp

uf_crm_y

float

option_id

float

contacts_custom_fields_data_crm_multiple_c

Campo Tipo

contact_id

float

[en] Contact Id

crm_multiple_a

text

Deals

Campo Tipo

id

float

[en] Deal ID. It is created automatically and is unique for the database.

additional_info

text

[en] Additional information

assigned_by_id

float

[en] Associated with a user by ID

begindate

timestamp

[en] Deal opening date

category_id

float

[en] Deal pipeline ID.

    Deals: pipelines > > id

closed

text

[en] Checkmark 'The deal is closed'

closedate

timestamp

[en] Deal closing date

comments

text

[en] Comments

company_id

float

[en] ID of a company that is a counterpart to the deal

    Companies > > company_id

contact_id

float

[en] Contact person ID

created_by_id

float

[en] Deal creator’s ID

currency_id

text

[en] Deal currency

date_create

timestamp

[en] Creation date

date_modify

timestamp

[en] Modification date

is_manual_opportunity

text

is_new

text

is_recurring

text

is_repeated_approach

text

is_return_customer

text

lead_id

float

[en] Lead ID

    Leads > > lead_id

location_id

text

modify_by_id

float

[en] ID of a person who modified the deal

moved_by_id

float

moved_time

timestamp

opened

text

[en] Checkmark 'Available to everyone'

opportunity

float

[en] Amount in deal currency

originator_id

text

[en] ID of the external information database. The field assignment can be modified by the end developer.

origin_id

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.

probability

float

[en] Deal conclusion probability (in %)

quote_id

float

    Deals: quotes > > id

source_description

text

source_id

text

stage_id

text

[en] Deal stage ID

    Deals: pipelines: stages > > id

stage_semantic_id

text

tax_value

float

title

text

[en] Deal name. A required field.

type_id

text

[en] Deal type ID.

utm_campaign

text

utm_content

text

utm_medium

text

utm_source

text

utm_term

text

Deals: custom fields (data)

Campo Tipo

deal_id

float

    Deals > > id

date_modify

timestamp

uf_crm_x

text

uf_crm_y

timestamp

uf_crm_y

float

option_id

float

Deals: custom fields (meta)

Objeto principal

Campo Tipo

id

float

[en] Custom field ID

edit_form_label_en

text

edit_in_list

text

entity_id

text

[en] Type of custom field

error_message_en

text

field_name

text

[en] Custom field Name

help_message_en

text

is_searchable

text

list_column_label_en

text

list_filter_label_en

text

mandatory

text

multiple

text

settings_caption_no_value

text

settings_default_value

text

settings_default_value

text

settings_display

text

settings_list_height

float

settings_max_length

float

settings_min_length

float

settings_popup

text

settings_regexp

text

settings_rows

float

settings_show_no_value

text

settings_size

float

settings_type

text

settings_value

text

show_filter

text

show_in_list

text

sort

float

user_type_id

text

[en] Data type

xml_id

text

deals_pipelines__SECTIONS

Campo Tipo

id

float

[en] Custom field ID

sections_cal_type

text

sections_id

float

sections_name

text

deals_pipelines__LIST

Campo Tipo

id

float

[en] Custom field ID

list_def

text

list_id

float

list_sort

float

list_value

text

Esta integração é gratuita

Deals: pipelines

Campo Tipo

id

float

[en] Pipeline id

isdefault

text

[en] When the pipeline is default

name

text

[en] Pipeline name

originid

text

originatorid

text

sort

float

[en] Pipeline sort positional value

Esta integração é gratuita

Deals: pipelines: stages

Campo Tipo

id

float

[en] Stage Id

pipeline_id

float

[en] Pipeline ID

    Deals: pipelines > > id

color

text

[en] Color hex value

entity_id

text

extra_color

text

extra_semantics

text

name

text

[en] Stage Name

name_init

text

semantics

text

sort

float

[en] Positional value

status_id

text

[en] Stage progress type

system

text

Esta integração é gratuita

Deals: products

Campo Tipo

deal_id

float

[en] Deal ID

    Deals > > id

deal_product_id

float

[en] ID of Deal and product relation

customized

text

discount_rate

float

discount_sum

float

discount_type_id

float

measure_code

float

measure_name

text

owner_type

text

price_account

float

price_brutto

float

price_exclusive

float

price_netto

float

product_id

float

    Products > > product_id

quantity

float

reserve_id

float

reserve_quantity

float

sort

float

tax_included

text

tax_rate

float

Deals: quotes

Campo Tipo

id

float

[en] Quote ID

assigned_by_id

float

[en] Associated with a user by the ID.

begindate

timestamp

closed

text

[en] Closed

closedate

timestamp

comments

text

[en] Manager comment

company_id

float

[en] Linking to company

    Companies > > company_id

contact_id

float

[en] crm_contact (Outdated. Saved for compatibility.)

    Contacts > > contact_id

content

text

[en] Quote content

created_by_id

float

currency_id

text

[en] Quote currency

date_create

timestamp

date_modify

timestamp

deal_id

float

[en] Deal, associated with a quote

    Deals > > id

lead_id

float

[en] Lead, associated with a quote

location_id

text

[en] Location

modify_by_id

float

[en] ID of the last modification author

mycompany_id

float

[en] Company ID, from which the quote is submitted

opened

text

[en] Accessible for all

opportunity

float

[en] Amount

person_type_id

float

[en] Payer type ID

quote_number

float

[en] Quote number

status_id

text

[en] Status

storage_element_ids

text

storage_type_id

float

tax_value

float

[en] Amount sum

terms

text

[en] Conditions

title

text

[en] Name

utm_campaign

text

[en] Advertisement campaign designation

utm_content

text

[en] Campaign content

utm_medium

text

[en] Type of traffic

utm_source

text

utm_term

text

[en] Campaign search condition

webform_id

text

Deals: quotes: products

Campo Tipo

quote_id

float

[en] Quote ID

id

float

[en] Relationship quote-product ID

customized

text

discount_rate

float

discount_sum

float

discount_type_id

float

measure_code

float

measure_name

text

original_product_name

text

owner_type

text

price

float

price_account

float

price_brutto

float

price_exclusive

float

price_netto

float

product_description

text

product_id

float

    Products > > product_id

product_name

text

quantity

float

reserve_id

text

reserve_quantity

float

sort

float

tax_included

text

tax_rate

float

Deals: stage history

Campo Tipo

id

float

[en] record ID

pipeline_id

float

    Deals: pipelines: stages > > pipeline_id

created_time

timestamp

[en] stage date and time

deal_id

float

[en] Deal ID

    Deals > > id

stage_id

text

    Deals: pipelines: stages > > status_id

stage_semantic_id

text

type_id

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

Campo Tipo

lead_id

float

[en] Lead ID

address

text

[en] Contact address

address_2

text

[en] Second page of the address

address_city

text

[en] City

address_country

text

[en] Country

address_country_code

text

[en] Country

address_loc_addr_id

float

address_postal_code

text

[en] Postal code

address_province

text

[en] Province

address_region

text

[en] Region

assigned_by_id

float

[en] Associated with user by ID

birthdate

timestamp

comments

text

[en] Comments

company_id

float

[en] Linking a contact to a company

    Companies > > company_id

company_title

text

[en] Name of company, associated with a lead

contact_id

float

[en] Linking a lead to a contact

    Contacts > > contact_id

created_by_id

float

currency_id

text

date_closed

text

date_create

timestamp

date_modify

timestamp

has_email

text

has_imol

text

has_phone

text

[en] Telephone field fill-up check

honorific

text

[en] Request

is_manual_opportunity

text

is_return_customer

text

last_name

text

modify_by_id

float

[en] Last modification author ID user

moved_by_id

float

moved_time

timestamp

name

text

[en] Name

opened

text

[en] Accessible for all

opportunity

float

originator_id

text

[en] Data source ID

origin_id

text

[en] Element ID in the data source

post

text

[en] Position

second_name

text

[en] Second name

source_description

text

[en] Source description?

source_id

text

[en] Source ID

status_description

text

status_id

text

status_semantic_id

text

title

text

[en] Lead name

utm_campaign

text

[en] Advertisement campaign designation

utm_content

text

[en] Campaign content

utm_medium

text

[en] Type of traffic

utm_source

text

[en] Advertisement system

utm_term

text

[en] Campaign search condition

webform_id

text

Leads: custom fields (data)

Campo Tipo

lead_id

float

[en] Lead ID

    Leads > > lead_id

date_modify

timestamp

uf_crm_x

text

uf_crm_y

timestamp

uf_crm_y

float

option_id

float

Leads: products

Campo Tipo

lead_id

float

[en] Lead ID

    Leads > > lead_id

id

float

[en] Relation product-lead id

customized

text

discount_rate

float

[en] Product discount

discount_sum

float

discount_type_id

float

measure_code

float

measure_name

text

original_product_name

text

owner_type

text

price

float

[en] Product price

price_account

float

price_brutto

float

price_exclusive

float

price_netto

float

product_description

text

product_id

float

[en] Product ID

    Products > > product_id

product_name

text

[en] product name

quantity

float

[en] product quantity

reserve_id

text

reserve_quantity

float

sort

float

tax_included

text

tax_rate

float

Products

Campo Tipo

product_id

float

[en] Product Id

active

text

catalog_id

float

    Catalogs > > id

code

text

created_by

float

currency_id

text

date_create

timestamp

description

text

description_type

text

detail_picture

text

measure

float

modified_by

float

name

text

preview_picture

text

price

float

section_id

float

sort

float

timestamp_x

timestamp

vat_id

text

vat_included

text

xml_id

float

uf_crm_x

text

uf_crm_y

timestamp

uf_crm_y

float

option_id

float