amoCRM
In this section you will learn:
- How to connect amoCRM data import.
Attention! The Google BigQuery integration has to be enabled to use this feature.
Importing data from amoCRM
After enabling this data source, amoCRM data will be uploaded to BigQuery once every 24 hours.
Connecting and configuring
The process of connecting data sources is described in detail in the overview.
After authorization you need to set the data source parameters.
Options description
Display name
The name of the data source. It is displayed in the interface in the list of sources.
Import leads
Enable import of leads data. If this option enabled, updated leads for the previous day will be uploaded.
Leads custom fields
The leads amoCRM custom fields to import.
Import lead name
Indicates whether or not to download leads names. It’s necessary for cases when the leads names contain sensitive information.
Saving, Disconnecting, Disabling data source
To save and enable the data source, click Save.
The Disconnect button is used to revoke the authorization data. The settings are saved.
You can enable or disable the data source at any time by using the switch on the top right.
Where to get leads data
- amoCrmLeads_{SUBDOMAIN}_{YYYYMMDD} - data for updated “Leads”
Table structures
amoCrmLeads table structure
| Field name | Type | Mode |
|---|---|---|
| id | INTEGER | NULLABLE |
| name | STRING | NULLABLE |
| responsible_user_id | INTEGER | NULLABLE |
| created_by | INTEGER | NULLABLE |
| created_at | INTEGER | NULLABLE |
| updated_at | INTEGER | NULLABLE |
| account_id | INTEGER | NULLABLE |
| pipeline_id | INTEGER | NULLABLE |
| status_id | INTEGER | NULLABLE |
| status_name | STRING | NULLABLE |
| updated_by | INTEGER | NULLABLE |
| is_deleted | BOOLEAN | NULLABLE |
| group_id | INTEGER | NULLABLE |
| closed_at | INTEGER | NULLABLE |
| closest_task_at | INTEGER | NULLABLE |
| sale | INTEGER | NULLABLE |
| loss_reason_id | INTEGER | NULLABLE |
| custom_fields | RECORD | REPEATED |
| custom_fields.id | INTEGER | NULLABLE |
| custom_fields.name | STRING | NULLABLE |
| custom_fields.is_system | BOOLEAN | NULLABLE |
| custom_fields.values | RECORD | REPEATED |
| custom_fields.values.value | STRING | NULLABLE |
| custom_fields.values.enum | INTEGER | NULLABLE |