AmoCRM. Подключение коннектора
Дата:
Шаг 1. Перейдите во вкладку “Источники данных” и нажмите на кнопку “Плюс”.
Шаг 2. В появившемся окне, найдите “amoCRM” и нажмите кнопку “Добавить”.
Шаг 3. Нажмите кнопку “Настройки”. Для подключения, Вам необходимо установить интеграцию.
Шаг 4. Разрешите доступ к своим данным из amoCRM.
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
amocrm_{}_deals
| Название колонки | Описание |
|---|---|
lead_id |
Lead ID |
name |
Lead name |
responsible_user_id |
Responsible user ID |
created_by |
ID of user who created lead |
updated_by |
ID of user who updated lead last |
account_id |
Account ID where lead is located in |
pipeline_id |
Pipeline ID. Specified if pipelines 142 or 143 were chosen. These pipelines are not unique and required for all digital pipelines |
status_id |
Status ID |
main_contact |
Main contact ID |
group_id |
Group ID of responsible for the lead user |
company |
ID of company attached to this lead |
contacts |
Contact ID |
loss_reason_id |
Loss reason ID |
loss_reason_name |
Loss reason name |
sale |
Lead sale |
date |
Date of lead last change |
created_at |
Lead creation date |
updated_at |
Lead change date |
closed_at |
Time and date when this lead was completed |
closest_task_at |
Time of the nearest task for this lead |
tags |
Lead tags data array |
custom_fields |
Array of current lead custom fields values |
is_deleted |
Indicator of whether lead was deleted |
deleted_at |
[GOOD.BI] timestamp since when we consider item deleted |
Название таблицы:
amocrm_{}_custom_fields_deals
| Название колонки | Описание |
|---|---|
custom_field_id |
Custom field ID |
lead_id |
Lead ID |
name |
Field name |
enum |
Field entity value |
value |
Custom field value |
is_system |
Indicator of whether extra field is systemic |
Название таблицы:
amocrm_{}_contacts
| Название колонки | Описание |
|---|---|
contact_id |
Contact ID |
first_name |
Contact first name |
last_name |
Contact last name |
name |
Contact fullname |
responsible_user_id |
Contact responsible user ID |
created_by |
ID of the user who created the contact |
updated_by |
ID of the user who updated the contact last |
account_id |
Account ID where the contact is located in |
group_id |
Group ID of the contact responsible user |
company |
Linked company ID |
company_name |
Linked company name |
leads |
Linked leads data array |
customers |
Linked customer data |
date |
Time and date the contact was changed |
created_at |
Contact creation date |
updated_at |
Contact update date |
closest_task_at |
Date of the closest open task |
tags |
Contact tags array |
custom_fields |
Array of the current contact custom fields values |
phones |
Phones array |
emails |
E-mails array |
communication_ids |
Communication ID array |
is_deleted |
Indicator of whether contact is deleted |
deleted_at |
[GOOD.BI] timestamp since when we consider item deleted |
Название таблицы:
amocrm_{}_companies
| Название колонки | Описание |
|---|---|
company_id |
Company ID |
name |
Company name |
responsible_user_id |
Company responsible user ID |
created_by |
ID of the user who created the company |
updated_by |
ID of the user who updated the company last |
account_id |
Account ID where the company is located in |
group_id |
Group ID of the company responsible user |
contacts |
Linked contacts data array |
leads |
Linked leads data array |
customers |
Linked customers data array |
date |
Date and time the company was changed |
created_at |
Company creation date |
updated_at |
Company change date |
closest_task_at |
Time of the nearest task for this company |
tags |
Company tags data array |
custom_fields |
Array of the current company custom fields’ values |
is_deleted |
Defines whether company is deleted |
deleted_at |
[GOOD.BI] timestamp since when we consider item deleted |
Название таблицы:
amocrm_{}_statuses
| Название колонки | Описание |
|---|---|
status_id |
Status ID |
status_name |
Name of the stage |
status_sort |
Sequence number of the stage when displayed |
pipeline_id |
Pipeline ID |
pipeline_name |
Pipeline name |
pipeline_sort |
Pipeline sorting |
pipeline_is_main |
Indicator of whether pipeline is main for the account |
pipeline_is_archive |
Indicator of whether pipeline is archive |
Название таблицы:
amocrm_{}_loss_reason
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
name |
Name of the loss reason |
sort |
Sequence number of the loss reason when displayed |
created_at |
loss reason creation date |
updated_at |
loss reason change date |
Название таблицы:
amocrm_{}_users
| Название колонки | Описание |
|---|---|
user_id |
User ID |
name |
User fullname |
last_name |
User last name |
login |
User Login |
group_id |
ID of user’s group |
is_active |
Indicator of whether the user is active |
is_free |
Indicator of whether it is a free user |
is_cancelled |
Indicator of whether account is deleted |
Название таблицы:
amocrm_{}_groups
| Название колонки | Описание |
|---|---|
group_id |
Group ID |
name |
Group name |
Название таблицы:
amocrm_{}_note_types
| Название колонки | Описание |
|---|---|
note_type_id |
Note type ID |
code |
Note type code |
Название таблицы:
amocrm_{}_task_types
| Название колонки | Описание |
|---|---|
task_type_id |
Task Type ID |
name |
Task name |
Название таблицы:
amocrm_{}_element_types
| Название колонки | Описание |
|---|---|
element_type_id |
Element ID |
code |
Element code |
name |
Element description |
Название таблицы:
amocrm_{}_deal_status_history
| Название колонки | Описание |
|---|---|
note_id |
Note ID |
lead_id |
Lead ID |
created_by |
ID of user who created note |
created_at |
Event creation date |
pipeline_id_new |
New pipeline ID |
pipeline_id_old |
Old pipeline ID |
status_new |
New status ID |
status_old |
Old status ID |
Название таблицы:
amocrm_{}_phone_history
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
created_by |
ID of user who created note |
created_at |
Event creation date |
entity_id |
Lead ID |
entity_type |
Always = "contact" |
type |
Event type |
value_before |
Old value |
value_after |
New value |
Название таблицы:
amocrm_{}_notes
| Название колонки | Описание |
|---|---|
note_id |
Note ID |
note_type |
Note type |
element_id |
ID of the element the note will be added to |
element_type |
Type of the element the note will be added to |
responsible_user_id |
Note responsible user ID |
group_id |
Group ID of the note responsible user |
created_by |
ID of user who created note |
created_at |
Note creation date |
updated_at |
Note edit date |
is_editable |
Indicator of whether event is editable |
attachment |
File attached |
text |
Text of event |
params |
Parameters array (required for certain type of events) |
Название таблицы:
amocrm_{}_notes_v4
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
entity_id |
Entity ID |
created_by |
ID of user who created note |
updated_by |
ID of user who created note |
created_at |
Note creation date |
updated_at |
Note edit date |
responsible_user_id |
Note responsible user ID |
group_id |
Group ID of the note responsible user |
note_type |
Note type |
params |
Parameters array (required for certain type of events) |
Название таблицы:
amocrm_{}_tasks
| Название колонки | Описание |
|---|---|
task_id |
Task ID |
element_id |
Contact or deal ID (contact or deal should be defined in element_type) |
element_type |
Type of element attached (1 – contact, 2 - deal, 3 – company, 12 – customer) |
responsible_user_id |
Task responsible user ID |
group_id |
Group ID of the task responsible user |
created_by |
ID of the user who created the task |
created_at |
Task creation date (optional parameter) |
updated_at |
Task edit date (optional parameter) |
complete_till_at |
Task deadline date. If time is set to 23:59, system interfaces will display “All day” instead of time. |
task_type |
Task type |
is_completed |
Indicator of whether the task is completed |
text |
Task description |
result |
Task result |
Название таблицы:
amocrm_{}_events
| Название колонки | Описание |
|---|---|
event_id |
Event ID |
type |
Event type |
created_by |
ID of the user who created the event |
created_at |
Event creation date |
value_after |
Value after event |
value_before |
Value before event |
account_id |
Account ID where the event is located in |
entity_type |
Type of the entity the event belongs to |
entity_id |
ID of the entity the event belongs to |
Название таблицы:
amocrm_{}_custom_fields
| Название колонки | Описание |
|---|---|
custom_field_id |
Custom field ID |
name |
Field name |
type |
Field type |
code |
Field code |
sort |
Sort |
entity_type |
Entity type (leads, contacts, companies, segments, customers, catalogs) |
enums |
Available field values array |
is_deleted |
Field is deleted |
Название таблицы:
amocrm_{}_unsorted
| Название колонки | Описание |
|---|---|
uid |
UID |
created_at |
Creation datetime |
source_uid |
Source UID |
source_name |
Source UID |
category |
sip, mail, chats, forms |
metadata |
Unsorted metadata params |
pipeline_id |
Pipeline ID |
contact_id |
Contact ID |
lead_id |
Lead ID |
company_id |
Company ID |
Название таблицы:
amocrm_{}_calls
| Название колонки | Описание |
|---|---|
uniq |
unique id (null if cancelled) |
note_id |
Note id |
entity_id |
entity_id |
entity_type |
entity_type |
created_by |
created_by |
updated_by |
updated_by |
created_at |
created_at |
updated_at |
updated_at |
responsible_user_id |
responsible_user_id |
group_id |
group_id |
note_type |
note_type |
duration |
duration |
source |
source |
link |
link |
phone |
phone |
call_result |
call_result |
call_status |
call_status |
Название таблицы:
amocrm_{}_contacts_custom_fields
| Название колонки | Описание |
|---|---|
custom_field_id |
Custom field ID |
name |
Field name |
type |
Field type |
code |
Field code |
sort |
Sort |
enums |
Available field values array |
Название таблицы:
amocrm_{}_cf_history
| Название колонки | Описание |
|---|---|
id |
Наш внутренний ид. Не используйте этот столбец |
custom_field_id |
Custom field ID |
created_by |
ID of user who created note |
created_at |
Event creation date |
entity_id |
Entity ID |
entity_type |
Entity type |
value_before |
Old value |
value_after |
New value |
str_value_before |
Parsed to str old value |
str_value_after |
Parsed to str new value |