Imports
The imports table contains data about uploads created in the organization.
This table can be used to determine which imports exist, as well as metadata about the import such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| name | The name of the import in the user interface. | VARCHAR | No |
| filename | The file name of the file used for the import. | VARCHAR | Yes |
| encoding | The encoding of the file used for the import. | VARCHAR | Yes |
| created_by_id | The numerical identifier of the user who created this import. Relates to the id column in the users table. |
INT4 | No |
| campaign_id | The numerical identifier of the campaign this import was assigned to. Relates to the id column in the campaigns table. |
INT8 | No |
| entity_type_id | The numerical identifier of the entity type this import used to import entities. Relates to the id column in the entity_types table. |
INT8 | No |
| errors_download_url | The URL to download any errors for this import. | VARCHAR | Yes |
| mappings | A JSON representation of the data mappings for this import. | JSONB | Yes |
| status | The status of this import. 0 for received, 1 for processing, 2 for complete. |
INT4 | Yes |
| visibility_status | The visibility status of this import. 0 for active, 1 for archived. |
INT4 | Yes |
| summary | This column is currently unused. | JSONB | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| summary_rows_count | The number of rows imported. | INT4 | Yes |
| summary_processed_count | The number of rows successfully processed. | INT4 | Yes |
| summary_error_count | The number of rows that errored. | INT4 | Yes |
| summary_entities_created_count | The number of entities created by the import. | INT4 | Yes |
| summary_entities_added_to_campaign_count | The number of entities added to the campaign by the import. | INT4 | Yes |
| summary_entities_matched_count | The number of already existing entities matched in the campaign by the import. | INT4 | Yes |
| original_csv_headers | A JSON representation of the original CSV's headers. | VARCHAR | Yes |