Close.com Connector Reference
The Close.com connector exposes 837 fields (24 metrics, 813 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Close.com Fields
Close.com activity_custom_fields fields
The activity_custom_fields report of the Close.com connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| activity_custom_fields__accepts_multiple_values | TEXT | activity_custom_fields.accepts_multiple_values | activity_custom_fields.accepts_multiple_values |
| activity_custom_fields__back_reference_is_visible | TEXT | activity_custom_fields.back_reference_is_visible | activity_custom_fields.back_reference_is_visible |
| activity_custom_fields__choices | TEXT | activity_custom_fields.choices | activity_custom_fields.choices |
| activity_custom_fields__created_by | TEXT | activity_custom_fields.created_by | activity_custom_fields.created_by |
| activity_custom_fields__custom_activity_type_id | TEXT | activity_custom_fields.custom_activity_type_id | activity_custom_fields.custom_activity_type_id |
| activity_custom_fields__date_created | TEXT | activity_custom_fields.date_created | activity_custom_fields.date_created |
| activity_custom_fields__date_updated | DATE | activity_custom_fields.date_updated | activity_custom_fields.date_updated |
| activity_custom_fields__description | TEXT | activity_custom_fields.description | activity_custom_fields.description |
| activity_custom_fields__editable_with_roles | TEXT | activity_custom_fields.editable_with_roles | activity_custom_fields.editable_with_roles |
| activity_custom_fields__id | TEXT | activity_custom_fields.id | activity_custom_fields.id |
| activity_custom_fields__is_shared | TEXT | activity_custom_fields.is_shared | activity_custom_fields.is_shared |
| activity_custom_fields__name | TEXT | activity_custom_fields.name | activity_custom_fields.name |
| activity_custom_fields__organization_id | TEXT | activity_custom_fields.organization_id | activity_custom_fields.organization_id |
| activity_custom_fields__referenced_custom_type_id | TEXT | activity_custom_fields.referenced_custom_type_id | activity_custom_fields.referenced_custom_type_id |
| activity_custom_fields__required | TEXT | activity_custom_fields.required | activity_custom_fields.required |
| activity_custom_fields__type | TEXT | activity_custom_fields.type | activity_custom_fields.type |
| activity_custom_fields__updated_by | TEXT | activity_custom_fields.updated_by | activity_custom_fields.updated_by |
Close.com answered_detached_call_tasks fields
The answered_detached_call_tasks report of the Close.com connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| answered_detached_call_tasks___type | TEXT | answered_detached_call_tasks._type | answered_detached_call_tasks._type |
| answered_detached_call_tasks__assigned_to | TEXT | answered_detached_call_tasks.assigned_to | answered_detached_call_tasks.assigned_to |
| answered_detached_call_tasks__assigned_to_name | TEXT | answered_detached_call_tasks.assigned_to_name | answered_detached_call_tasks.assigned_to_name |
| answered_detached_call_tasks__contact_id | TEXT | answered_detached_call_tasks.contact_id | answered_detached_call_tasks.contact_id |
| answered_detached_call_tasks__contact_name | TEXT | answered_detached_call_tasks.contact_name | answered_detached_call_tasks.contact_name |
| answered_detached_call_tasks__created_by | TEXT | answered_detached_call_tasks.created_by | answered_detached_call_tasks.created_by |
| answered_detached_call_tasks__created_by_name | TEXT | answered_detached_call_tasks.created_by_name | answered_detached_call_tasks.created_by_name |
| answered_detached_call_tasks__date | TEXT | answered_detached_call_tasks.date | answered_detached_call_tasks.date |
| answered_detached_call_tasks__date_created | TEXT | answered_detached_call_tasks.date_created | answered_detached_call_tasks.date_created |
| answered_detached_call_tasks__date_updated | DATE | answered_detached_call_tasks.date_updated | answered_detached_call_tasks.date_updated |
| answered_detached_call_tasks__id | TEXT | answered_detached_call_tasks.id | answered_detached_call_tasks.id |
| answered_detached_call_tasks__is_complete | BOOLEAN | answered_detached_call_tasks.is_complete | answered_detached_call_tasks.is_complete |
| answered_detached_call_tasks__lead_id | TEXT | answered_detached_call_tasks.lead_id | answered_detached_call_tasks.lead_id |
| answered_detached_call_tasks__lead_name | TEXT | answered_detached_call_tasks.lead_name | answered_detached_call_tasks.lead_name |
| answered_detached_call_tasks__object_id | TEXT | answered_detached_call_tasks.object_id | answered_detached_call_tasks.object_id |
| answered_detached_call_tasks__object_type | TEXT | answered_detached_call_tasks.object_type | answered_detached_call_tasks.object_type |
| answered_detached_call_tasks__organization_id | TEXT | answered_detached_call_tasks.organization_id | answered_detached_call_tasks.organization_id |
| answered_detached_call_tasks__phone | TEXT | answered_detached_call_tasks.phone | answered_detached_call_tasks.phone |
| answered_detached_call_tasks__phone_formatted | TEXT | answered_detached_call_tasks.phone_formatted | answered_detached_call_tasks.phone_formatted |
| answered_detached_call_tasks__phone_number_description | TEXT | answered_detached_call_tasks.phone_number_description | answered_detached_call_tasks.phone_number_description |
| answered_detached_call_tasks__recording_url | TEXT | answered_detached_call_tasks.recording_url | answered_detached_call_tasks.recording_url |
| answered_detached_call_tasks__updated_by | TEXT | answered_detached_call_tasks.updated_by | answered_detached_call_tasks.updated_by |
| answered_detached_call_tasks__updated_by_name | TEXT | answered_detached_call_tasks.updated_by_name | answered_detached_call_tasks.updated_by_name |
| answered_detached_call_tasks__view | TEXT | answered_detached_call_tasks.view | answered_detached_call_tasks.view |
Close.com call_activities fields
The call_activities report of the Close.com connector includes 53 fields.
Close.com call_activities fields (call_activities___type to call_activities__sequence_subscription_id)
| ID | Type | Name | Description |
|---|---|---|---|
| call_activities___type | TEXT | call_activities._type | call_activities._type |
| call_activities__activity_at | DATE | call_activities.activity_at | call_activities.activity_at |
| call_activities__call_method | TEXT | call_activities.call_method | call_activities.call_method |
| call_activities__coach_legs | OBJECT | call_activities.coach_legs | call_activities.coach_legs |
| call_activities__contact_id | TEXT | call_activities.contact_id | call_activities.contact_id |
| call_activities__cost | TEXT | call_activities.cost | call_activities.cost |
| call_activities__created_by | TEXT | call_activities.created_by | call_activities.created_by |
| call_activities__created_by_name | TEXT | call_activities.created_by_name | call_activities.created_by_name |
| call_activities__date_answered | TEXT | call_activities.date_answered | call_activities.date_answered |
| call_activities__date_created | TEXT | call_activities.date_created | call_activities.date_created |
| call_activities__date_updated | DATE | call_activities.date_updated | call_activities.date_updated |
| call_activities__dialer_id | TEXT | call_activities.dialer_id | call_activities.dialer_id |
| call_activities__dialer_saved_search_id | TEXT | call_activities.dialer_saved_search_id | call_activities.dialer_saved_search_id |
| call_activities__direction | TEXT | call_activities.direction | call_activities.direction |
| call_activities__disposition | TEXT | call_activities.disposition | call_activities.disposition |
| call_activities__duration | NUMERIC | call_activities.duration | call_activities.duration |
| call_activities__forwarded_to | TEXT | call_activities.forwarded_to | call_activities.forwarded_to |
| call_activities__has_recording | BOOLEAN | call_activities.has_recording | call_activities.has_recording |
| call_activities__id | TEXT | call_activities.id | call_activities.id |
| call_activities__is_forwarded | BOOLEAN | call_activities.is_forwarded | call_activities.is_forwarded |
| call_activities__is_joinable | BOOLEAN | call_activities.is_joinable | call_activities.is_joinable |
| call_activities__is_to_group_number | BOOLEAN | call_activities.is_to_group_number | call_activities.is_to_group_number |
| call_activities__lead_id | TEXT | call_activities.lead_id | call_activities.lead_id |
| call_activities__local_country_iso | TEXT | call_activities.local_country_iso | call_activities.local_country_iso |
| call_activities__local_phone | TEXT | call_activities.local_phone | call_activities.local_phone |
| call_activities__local_phone_formatted | TEXT | call_activities.local_phone_formatted | call_activities.local_phone_formatted |
| call_activities__note | TEXT | call_activities.note | call_activities.note |
| call_activities__note_html | TEXT | call_activities.note_html | call_activities.note_html |
| call_activities__organization_id | TEXT | call_activities.organization_id | call_activities.organization_id |
| call_activities__parent_meeting_id | TEXT | call_activities.parent_meeting_id | call_activities.parent_meeting_id |
| call_activities__phone | TEXT | call_activities.phone | call_activities.phone |
| call_activities__recording_duration | TEXT | call_activities.recording_duration | call_activities.recording_duration |
| call_activities__recording_expires_at | DATE | call_activities.recording_expires_at | call_activities.recording_expires_at |
| call_activities__recording_url | TEXT | call_activities.recording_url | call_activities.recording_url |
| call_activities__remote_country_iso | TEXT | call_activities.remote_country_iso | call_activities.remote_country_iso |
| call_activities__remote_phone | TEXT | call_activities.remote_phone | call_activities.remote_phone |
| call_activities__remote_phone_formatted | TEXT | call_activities.remote_phone_formatted | call_activities.remote_phone_formatted |
| call_activities__sequence_id | TEXT | call_activities.sequence_id | call_activities.sequence_id |
| call_activities__sequence_name | TEXT | call_activities.sequence_name | call_activities.sequence_name |
| call_activities__sequence_subscription_id | TEXT | call_activities.sequence_subscription_id | call_activities.sequence_subscription_id |
Close.com call_activities fields (call_activities__source to call_activities__voicemail_url)
| ID | Type | Name | Description |
|---|---|---|---|
| call_activities__source | TEXT | call_activities.source | call_activities.source |
| call_activities__status | TEXT | call_activities.status | call_activities.status |
| call_activities__transferred_from | TEXT | call_activities.transferred_from | call_activities.transferred_from |
| call_activities__transferred_from_user_id | TEXT | call_activities.transferred_from_user_id | call_activities.transferred_from_user_id |
| call_activities__transferred_to | TEXT | call_activities.transferred_to | call_activities.transferred_to |
| call_activities__transferred_to_user_id | TEXT | call_activities.transferred_to_user_id | call_activities.transferred_to_user_id |
| call_activities__updated_by | TEXT | call_activities.updated_by | call_activities.updated_by |
| call_activities__updated_by_name | TEXT | call_activities.updated_by_name | call_activities.updated_by_name |
| call_activities__user_id | TEXT | call_activities.user_id | call_activities.user_id |
| call_activities__user_name | TEXT | call_activities.user_name | call_activities.user_name |
| call_activities__users | OBJECT | call_activities.users | call_activities.users |
| call_activities__voicemail_duration | NUMERIC | call_activities.voicemail_duration | call_activities.voicemail_duration |
| call_activities__voicemail_url | TEXT | call_activities.voicemail_url | call_activities.voicemail_url |
Close.com contact_custom_fields fields
The contact_custom_fields report of the Close.com connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contact_custom_fields__accepts_multiple_values | TEXT | contact_custom_fields.accepts_multiple_values | contact_custom_fields.accepts_multiple_values |
| contact_custom_fields__back_reference_is_visible | TEXT | contact_custom_fields.back_reference_is_visible | contact_custom_fields.back_reference_is_visible |
| contact_custom_fields__choices | TEXT | contact_custom_fields.choices | contact_custom_fields.choices |
| contact_custom_fields__created_by | TEXT | contact_custom_fields.created_by | contact_custom_fields.created_by |
| contact_custom_fields__date_created | TEXT | contact_custom_fields.date_created | contact_custom_fields.date_created |
| contact_custom_fields__date_updated | DATE | contact_custom_fields.date_updated | contact_custom_fields.date_updated |
| contact_custom_fields__description | TEXT | contact_custom_fields.description | contact_custom_fields.description |
| contact_custom_fields__editable_with_roles | TEXT | contact_custom_fields.editable_with_roles | contact_custom_fields.editable_with_roles |
| contact_custom_fields__id | TEXT | contact_custom_fields.id | contact_custom_fields.id |
| contact_custom_fields__is_shared | TEXT | contact_custom_fields.is_shared | contact_custom_fields.is_shared |
| contact_custom_fields__name | TEXT | contact_custom_fields.name | contact_custom_fields.name |
| contact_custom_fields__organization_id | TEXT | contact_custom_fields.organization_id | contact_custom_fields.organization_id |
| contact_custom_fields__referenced_custom_type_id | TEXT | contact_custom_fields.referenced_custom_type_id | contact_custom_fields.referenced_custom_type_id |
| contact_custom_fields__type | TEXT | contact_custom_fields.type | contact_custom_fields.type |
| contact_custom_fields__updated_by | TEXT | contact_custom_fields.updated_by | contact_custom_fields.updated_by |
Close.com contacts fields
The contacts report of the Close.com connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| contacts__created_by | TEXT | contacts.created_by | contacts.created_by |
| contacts__date_created | TEXT | contacts.date_created | contacts.date_created |
| contacts__date_updated | DATE | contacts.date_updated | contacts.date_updated |
| contacts__display_name | TEXT | contacts.display_name | contacts.display_name |
| contacts__emails | OBJECT | contacts.emails | contacts.emails |
| contacts__id | TEXT | contacts.id | contacts.id |
| contacts__integration_links | OBJECT | contacts.integration_links | contacts.integration_links |
| contacts__lead_id | TEXT | contacts.lead_id | contacts.lead_id |
| contacts__name | TEXT | contacts.name | contacts.name |
| contacts__organization_id | TEXT | contacts.organization_id | contacts.organization_id |
| contacts__phones | OBJECT | contacts.phones | contacts.phones |
| contacts__title | TEXT | contacts.title | contacts.title |
| contacts__updated_by | TEXT | contacts.updated_by | contacts.updated_by |
| contacts__urls | OBJECT | contacts.urls | contacts.urls |
Close.com created_activities fields
The created_activities report of the Close.com connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| created_activities___type | TEXT | created_activities._type | created_activities._type |
| created_activities__activity_at | DATE | created_activities.activity_at | created_activities.activity_at |
| created_activities__contact_id | TEXT | created_activities.contact_id | created_activities.contact_id |
| created_activities__created_by | TEXT | created_activities.created_by | created_activities.created_by |
| created_activities__created_by_name | TEXT | created_activities.created_by_name | created_activities.created_by_name |
| created_activities__date_created | TEXT | created_activities.date_created | created_activities.date_created |
| created_activities__date_updated | DATE | created_activities.date_updated | created_activities.date_updated |
| created_activities__id | TEXT | created_activities.id | created_activities.id |
| created_activities__import_id | TEXT | created_activities.import_id | created_activities.import_id |
| created_activities__lead_id | TEXT | created_activities.lead_id | created_activities.lead_id |
| created_activities__organization_id | TEXT | created_activities.organization_id | created_activities.organization_id |
| created_activities__source | TEXT | created_activities.source | created_activities.source |
| created_activities__updated_by | TEXT | created_activities.updated_by | created_activities.updated_by |
| created_activities__updated_by_name | TEXT | created_activities.updated_by_name | created_activities.updated_by_name |
| created_activities__user_id | TEXT | created_activities.user_id | created_activities.user_id |
| created_activities__user_name | TEXT | created_activities.user_name | created_activities.user_name |
| created_activities__users | OBJECT | created_activities.users | created_activities.users |
Close.com custom_activities fields
The custom_activities report of the Close.com connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| custom_activities__api_create_only | BOOLEAN | custom_activities.api_create_only | custom_activities.api_create_only |
| custom_activities__created_by | TEXT | custom_activities.created_by | custom_activities.created_by |
| custom_activities__date_created | TEXT | custom_activities.date_created | custom_activities.date_created |
| custom_activities__date_updated | DATE | custom_activities.date_updated | custom_activities.date_updated |
| custom_activities__description | TEXT | custom_activities.description | custom_activities.description |
| custom_activities__editable_with_roles | OBJECT | custom_activities.editable_with_roles | custom_activities.editable_with_roles |
| custom_activities__fields | OBJECT | custom_activities.fields | custom_activities.fields |
| custom_activities__id | TEXT | custom_activities.id | custom_activities.id |
Close.com custom_email_connected_accounts fields
The custom_email_connected_accounts report of the Close.com connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| custom_email_connected_accounts___type | TEXT | custom_email_connected_accounts._type | custom_email_connected_accounts._type |
| custom_email_connected_accounts__id | TEXT | custom_email_connected_accounts.id | custom_email_connected_accounts.id |
| custom_email_connected_accounts__identities | OBJECT | custom_email_connected_accounts.identities | custom_email_connected_accounts.identities |
| custom_email_connected_accounts__imap | OBJECT | custom_email_connected_accounts.imap | custom_email_connected_accounts.imap |
| custom_email_connected_accounts__organization_id | TEXT | custom_email_connected_accounts.organization_id | custom_email_connected_accounts.organization_id |
| custom_email_connected_accounts__smtp | OBJECT | custom_email_connected_accounts.smtp | custom_email_connected_accounts.smtp |
| custom_email_connected_accounts__user_id | TEXT | custom_email_connected_accounts.user_id | custom_email_connected_accounts.user_id |
Close.com delete_bulk_actions fields
The delete_bulk_actions report of the Close.com connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| delete_bulk_actions__created_by | TEXT | delete_bulk_actions.created_by | delete_bulk_actions.created_by |
| delete_bulk_actions__date_created | TEXT | delete_bulk_actions.date_created | delete_bulk_actions.date_created |
| delete_bulk_actions__date_updated | DATE | delete_bulk_actions.date_updated | delete_bulk_actions.date_updated |
| delete_bulk_actions__id | TEXT | delete_bulk_actions.id | delete_bulk_actions.id |
| delete_bulk_actions__n_leads | NUMERIC | delete_bulk_actions.n_leads | delete_bulk_actions.n_leads |
| delete_bulk_actions__n_leads_processed | NUMERIC | delete_bulk_actions.n_leads_processed | delete_bulk_actions.n_leads_processed |
| delete_bulk_actions__organization_id | TEXT | delete_bulk_actions.organization_id | delete_bulk_actions.organization_id |
| delete_bulk_actions__query | TEXT | delete_bulk_actions.query | delete_bulk_actions.query |
| delete_bulk_actions__send_done_email | BOOLEAN | delete_bulk_actions.send_done_email | delete_bulk_actions.send_done_email |
| delete_bulk_actions__status | TEXT | delete_bulk_actions.status | delete_bulk_actions.status |
| delete_bulk_actions__updated_by | TEXT | delete_bulk_actions.updated_by | delete_bulk_actions.updated_by |
Close.com dialer fields
The dialer report of the Close.com connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| dialer__caller_id | TEXT | dialer.caller_id | dialer.caller_id |
| dialer__date_created | TEXT | dialer.date_created | dialer.date_created |
| dialer__date_updated | DATE | dialer.date_updated | dialer.date_updated |
| dialer__id | TEXT | dialer.id | dialer.id |
| dialer__is_user_dependent | BOOLEAN | dialer.is_user_dependent | dialer.is_user_dependent |
| dialer__music_preference | TEXT | dialer.music_preference | dialer.music_preference |
| dialer__organization_id | TEXT | dialer.organization_id | dialer.organization_id |
| dialer__ring_mode | TEXT | dialer.ring_mode | dialer.ring_mode |
| dialer__source_type | TEXT | dialer.source_type | dialer.source_type |
| dialer__source_value | TEXT | dialer.source_value | dialer.source_value |
| dialer__status | TEXT | dialer.status | dialer.status |
| dialer__type | TEXT | dialer.type | dialer.type |
| dialer__user_id | TEXT | dialer.user_id | dialer.user_id |
| dialer__users | OBJECT | dialer.users | dialer.users |
| dialer__visibility_mode | TEXT | dialer.visibility_mode | dialer.visibility_mode |
Close.com edit_bulk_actions fields
The edit_bulk_actions report of the Close.com connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| edit_bulk_actions__created_by | TEXT | edit_bulk_actions.created_by | edit_bulk_actions.created_by |
| edit_bulk_actions__custom_field_name | TEXT | edit_bulk_actions.custom_field_name | edit_bulk_actions.custom_field_name |
| edit_bulk_actions__custom_field_value | TEXT | edit_bulk_actions.custom_field_value | edit_bulk_actions.custom_field_value |
| edit_bulk_actions__date_created | TEXT | edit_bulk_actions.date_created | edit_bulk_actions.date_created |
| edit_bulk_actions__date_updated | DATE | edit_bulk_actions.date_updated | edit_bulk_actions.date_updated |
| edit_bulk_actions__id | TEXT | edit_bulk_actions.id | edit_bulk_actions.id |
| edit_bulk_actions__lead_status_id | TEXT | edit_bulk_actions.lead_status_id | edit_bulk_actions.lead_status_id |
| edit_bulk_actions__n_leads | NUMERIC | edit_bulk_actions.n_leads | edit_bulk_actions.n_leads |
| edit_bulk_actions__n_leads_processed | NUMERIC | edit_bulk_actions.n_leads_processed | edit_bulk_actions.n_leads_processed |
| edit_bulk_actions__n_objects | NUMERIC | edit_bulk_actions.n_objects | edit_bulk_actions.n_objects |
| edit_bulk_actions__n_objects_processed | NUMERIC | edit_bulk_actions.n_objects_processed | edit_bulk_actions.n_objects_processed |
| edit_bulk_actions__organization_id | TEXT | edit_bulk_actions.organization_id | edit_bulk_actions.organization_id |
| edit_bulk_actions__query | TEXT | edit_bulk_actions.query | edit_bulk_actions.query |
| edit_bulk_actions__send_done_email | BOOLEAN | edit_bulk_actions.send_done_email | edit_bulk_actions.send_done_email |
| edit_bulk_actions__status | TEXT | edit_bulk_actions.status | edit_bulk_actions.status |
| edit_bulk_actions__type | TEXT | edit_bulk_actions.type | edit_bulk_actions.type |
| edit_bulk_actions__updated_by | TEXT | edit_bulk_actions.updated_by | edit_bulk_actions.updated_by |
Close.com email_activities fields
The email_activities report of the Close.com connector includes 50 fields.
Close.com email_activities fields (email_activities___type to email_activities__status)
| ID | Type | Name | Description |
|---|---|---|---|
| email_activities___type | TEXT | email_activities._type | email_activities._type |
| email_activities__activity_at | DATE | email_activities.activity_at | email_activities.activity_at |
| email_activities__attachments | OBJECT | email_activities.attachments | email_activities.attachments |
| email_activities__bcc | OBJECT | email_activities.bcc | email_activities.bcc |
| email_activities__body_html | TEXT | email_activities.body_html | email_activities.body_html |
| email_activities__body_html_quoted | OBJECT | email_activities.body_html_quoted | email_activities.body_html_quoted |
| email_activities__body_preview | TEXT | email_activities.body_preview | email_activities.body_preview |
| email_activities__body_text | TEXT | email_activities.body_text | email_activities.body_text |
| email_activities__body_text_quoted | OBJECT | email_activities.body_text_quoted | email_activities.body_text_quoted |
| email_activities__bulk_email_action_id | TEXT | email_activities.bulk_email_action_id | email_activities.bulk_email_action_id |
| email_activities__cc | OBJECT | email_activities.cc | email_activities.cc |
| email_activities__contact_id | TEXT | email_activities.contact_id | email_activities.contact_id |
| email_activities__created_by | TEXT | email_activities.created_by | email_activities.created_by |
| email_activities__created_by_name | TEXT | email_activities.created_by_name | email_activities.created_by_name |
| email_activities__date_created | TEXT | email_activities.date_created | email_activities.date_created |
| email_activities__date_scheduled | TEXT | email_activities.date_scheduled | email_activities.date_scheduled |
| email_activities__date_sent | TEXT | email_activities.date_sent | email_activities.date_sent |
| email_activities__date_updated | DATE | email_activities.date_updated | email_activities.date_updated |
| email_activities__direction | TEXT | email_activities.direction | email_activities.direction |
| email_activities__email_account_id | TEXT | email_activities.email_account_id | email_activities.email_account_id |
| email_activities__envelope | OBJECT | email_activities.envelope | email_activities.envelope |
| email_activities__followup_sequence_delay | TEXT | email_activities.followup_sequence_delay | email_activities.followup_sequence_delay |
| email_activities__followup_sequence_id | TEXT | email_activities.followup_sequence_id | email_activities.followup_sequence_id |
| email_activities__has_reply | BOOLEAN | email_activities.has_reply | email_activities.has_reply |
| email_activities__id | TEXT | email_activities.id | email_activities.id |
| email_activities__in_reply_to_id | TEXT | email_activities.in_reply_to_id | email_activities.in_reply_to_id |
| email_activities__lead_id | TEXT | email_activities.lead_id | email_activities.lead_id |
| email_activities__message_ids | OBJECT | email_activities.message_ids | email_activities.message_ids |
| email_activities__need_smtp_credentials | BOOLEAN | email_activities.need_smtp_credentials | email_activities.need_smtp_credentials |
| email_activities__opens | OBJECT | email_activities.opens | email_activities.opens |
| email_activities__opens_summary | TEXT | email_activities.opens_summary | email_activities.opens_summary |
| email_activities__organization_id | TEXT | email_activities.organization_id | email_activities.organization_id |
| email_activities__references | OBJECT | email_activities.references | email_activities.references |
| email_activities__send_as_id | TEXT | email_activities.send_as_id | email_activities.send_as_id |
| email_activities__send_attempts | OBJECT | email_activities.send_attempts | email_activities.send_attempts |
| email_activities__sender | TEXT | email_activities.sender | email_activities.sender |
| email_activities__sequence_id | TEXT | email_activities.sequence_id | email_activities.sequence_id |
| email_activities__sequence_name | TEXT | email_activities.sequence_name | email_activities.sequence_name |
| email_activities__sequence_subscription_id | TEXT | email_activities.sequence_subscription_id | email_activities.sequence_subscription_id |
| email_activities__status | TEXT | email_activities.status | email_activities.status |
Close.com email_activities fields (email_activities__subject to email_activities__users)
| ID | Type | Name | Description |
|---|---|---|---|
| email_activities__subject | TEXT | email_activities.subject | email_activities.subject |
| email_activities__template_id | TEXT | email_activities.template_id | email_activities.template_id |
| email_activities__template_name | TEXT | email_activities.template_name | email_activities.template_name |
| email_activities__thread_id | TEXT | email_activities.thread_id | email_activities.thread_id |
| email_activities__to | OBJECT | email_activities.to | email_activities.to |
| email_activities__updated_by | TEXT | email_activities.updated_by | email_activities.updated_by |
| email_activities__updated_by_name | TEXT | email_activities.updated_by_name | email_activities.updated_by_name |
| email_activities__user_id | TEXT | email_activities.user_id | email_activities.user_id |
| email_activities__user_name | TEXT | email_activities.user_name | email_activities.user_name |
| email_activities__users | OBJECT | email_activities.users | email_activities.users |
Close.com email_bulk_actions fields
The email_bulk_actions report of the Close.com connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_bulk_actions__contact_preference | TEXT | email_bulk_actions.contact_preference | email_bulk_actions.contact_preference |
| email_bulk_actions__created_by | TEXT | email_bulk_actions.created_by | email_bulk_actions.created_by |
| email_bulk_actions__date_created | TEXT | email_bulk_actions.date_created | email_bulk_actions.date_created |
| email_bulk_actions__date_updated | DATE | email_bulk_actions.date_updated | email_bulk_actions.date_updated |
| email_bulk_actions__id | TEXT | email_bulk_actions.id | email_bulk_actions.id |
| email_bulk_actions__n_leads | NUMERIC | email_bulk_actions.n_leads | email_bulk_actions.n_leads |
| email_bulk_actions__n_leads_processed | NUMERIC | email_bulk_actions.n_leads_processed | email_bulk_actions.n_leads_processed |
| email_bulk_actions__organization_id | TEXT | email_bulk_actions.organization_id | email_bulk_actions.organization_id |
| email_bulk_actions__query | TEXT | email_bulk_actions.query | email_bulk_actions.query |
| email_bulk_actions__send_done_email | BOOLEAN | email_bulk_actions.send_done_email | email_bulk_actions.send_done_email |
| email_bulk_actions__status | TEXT | email_bulk_actions.status | email_bulk_actions.status |
| email_bulk_actions__template_id | TEXT | email_bulk_actions.template_id | email_bulk_actions.template_id |
| email_bulk_actions__updated_by | TEXT | email_bulk_actions.updated_by | email_bulk_actions.updated_by |
Close.com email_followup_tasks fields
The email_followup_tasks report of the Close.com connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_followup_tasks___type | TEXT | email_followup_tasks._type | email_followup_tasks._type |
| email_followup_tasks__assigned_to | TEXT | email_followup_tasks.assigned_to | email_followup_tasks.assigned_to |
| email_followup_tasks__assigned_to_name | TEXT | email_followup_tasks.assigned_to_name | email_followup_tasks.assigned_to_name |
| email_followup_tasks__body_preview | TEXT | email_followup_tasks.body_preview | email_followup_tasks.body_preview |
| email_followup_tasks__contact_id | TEXT | email_followup_tasks.contact_id | email_followup_tasks.contact_id |
| email_followup_tasks__contact_name | TEXT | email_followup_tasks.contact_name | email_followup_tasks.contact_name |
| email_followup_tasks__created_by | TEXT | email_followup_tasks.created_by | email_followup_tasks.created_by |
| email_followup_tasks__created_by_name | TEXT | email_followup_tasks.created_by_name | email_followup_tasks.created_by_name |
| email_followup_tasks__date | TEXT | email_followup_tasks.date | email_followup_tasks.date |
| email_followup_tasks__date_created | TEXT | email_followup_tasks.date_created | email_followup_tasks.date_created |
| email_followup_tasks__date_updated | DATE | email_followup_tasks.date_updated | email_followup_tasks.date_updated |
| email_followup_tasks__email_id | TEXT | email_followup_tasks.email_id | email_followup_tasks.email_id |
| email_followup_tasks__id | TEXT | email_followup_tasks.id | email_followup_tasks.id |
| email_followup_tasks__is_complete | BOOLEAN | email_followup_tasks.is_complete | email_followup_tasks.is_complete |
| email_followup_tasks__lead_id | TEXT | email_followup_tasks.lead_id | email_followup_tasks.lead_id |
| email_followup_tasks__lead_name | TEXT | email_followup_tasks.lead_name | email_followup_tasks.lead_name |
| email_followup_tasks__object_id | TEXT | email_followup_tasks.object_id | email_followup_tasks.object_id |
| email_followup_tasks__object_type | TEXT | email_followup_tasks.object_type | email_followup_tasks.object_type |
| email_followup_tasks__organization_id | TEXT | email_followup_tasks.organization_id | email_followup_tasks.organization_id |
| email_followup_tasks__subject | TEXT | email_followup_tasks.subject | email_followup_tasks.subject |
| email_followup_tasks__total_emails_count_in_thread | NUMERIC | email_followup_tasks.total_emails_count_in_thread | email_followup_tasks.total_emails_count_in_thread |
| email_followup_tasks__updated_by | TEXT | email_followup_tasks.updated_by | email_followup_tasks.updated_by |
| email_followup_tasks__updated_by_name | TEXT | email_followup_tasks.updated_by_name | email_followup_tasks.updated_by_name |
| email_followup_tasks__view | TEXT | email_followup_tasks.view | email_followup_tasks.view |
Close.com email_sequences fields
The email_sequences report of the Close.com connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_sequences__allow_manual_enrollment | BOOLEAN | email_sequences.allow_manual_enrollment | email_sequences.allow_manual_enrollment |
| email_sequences__created_by_id | TEXT | email_sequences.created_by_id | email_sequences.created_by_id |
| email_sequences__date_created | TEXT | email_sequences.date_created | email_sequences.date_created |
| email_sequences__date_updated | DATE | email_sequences.date_updated | email_sequences.date_updated |
| email_sequences__id | TEXT | email_sequences.id | email_sequences.id |
| email_sequences__name | TEXT | email_sequences.name | email_sequences.name |
| email_sequences__organization_id | TEXT | email_sequences.organization_id | email_sequences.organization_id |
| email_sequences__schedule_id | TEXT | email_sequences.schedule_id | email_sequences.schedule_id |
| email_sequences__status | TEXT | email_sequences.status | email_sequences.status |
| email_sequences__steps | OBJECT | email_sequences.steps | email_sequences.steps |
| email_sequences__timezone | TEXT | email_sequences.timezone | email_sequences.timezone |
| email_sequences__trigger_query | TEXT | email_sequences.trigger_query | email_sequences.trigger_query |
| email_sequences__updated_by_id | TEXT | email_sequences.updated_by_id | email_sequences.updated_by_id |
Close.com email_templates fields
The email_templates report of the Close.com connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_templates__attachments | OBJECT | email_templates.attachments | email_templates.attachments |
| email_templates__body | TEXT | email_templates.body | email_templates.body |
| email_templates__created_by | TEXT | email_templates.created_by | email_templates.created_by |
| email_templates__date_created | TEXT | email_templates.date_created | email_templates.date_created |
| email_templates__date_updated | DATE | email_templates.date_updated | email_templates.date_updated |
| email_templates__id | TEXT | email_templates.id | email_templates.id |
| email_templates__is_archived | BOOLEAN | email_templates.is_archived | email_templates.is_archived |
| email_templates__is_shared | BOOLEAN | email_templates.is_shared | email_templates.is_shared |
| email_templates__name | TEXT | email_templates.name | email_templates.name |
| email_templates__organization_id | TEXT | email_templates.organization_id | email_templates.organization_id |
| email_templates__subject | TEXT | email_templates.subject | email_templates.subject |
| email_templates__updated_by | TEXT | email_templates.updated_by | email_templates.updated_by |
Close.com email_thread_activities fields
The email_thread_activities report of the Close.com connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_thread_activities___type | TEXT | email_thread_activities._type | email_thread_activities._type |
| email_thread_activities__activity_at | DATE | email_thread_activities.activity_at | email_thread_activities.activity_at |
| email_thread_activities__contact_id | TEXT | email_thread_activities.contact_id | email_thread_activities.contact_id |
| email_thread_activities__created_by | TEXT | email_thread_activities.created_by | email_thread_activities.created_by |
| email_thread_activities__created_by_name | TEXT | email_thread_activities.created_by_name | email_thread_activities.created_by_name |
| email_thread_activities__date_created | TEXT | email_thread_activities.date_created | email_thread_activities.date_created |
| email_thread_activities__date_updated | DATE | email_thread_activities.date_updated | email_thread_activities.date_updated |
| email_thread_activities__id | TEXT | email_thread_activities.id | email_thread_activities.id |
| email_thread_activities__latest_emails | OBJECT | email_thread_activities.latest_emails | email_thread_activities.latest_emails |
| email_thread_activities__latest_normalized_subject | TEXT | email_thread_activities.latest_normalized_subject | email_thread_activities.latest_normalized_subject |
| email_thread_activities__lead_id | TEXT | email_thread_activities.lead_id | email_thread_activities.lead_id |
| email_thread_activities__n_emails | NUMERIC | email_thread_activities.n_emails | email_thread_activities.n_emails |
| email_thread_activities__organization_id | TEXT | email_thread_activities.organization_id | email_thread_activities.organization_id |
| email_thread_activities__participants | OBJECT | email_thread_activities.participants | email_thread_activities.participants |
| email_thread_activities__updated_by | TEXT | email_thread_activities.updated_by | email_thread_activities.updated_by |
| email_thread_activities__updated_by_name | TEXT | email_thread_activities.updated_by_name | email_thread_activities.updated_by_name |
| email_thread_activities__user_id | TEXT | email_thread_activities.user_id | email_thread_activities.user_id |
| email_thread_activities__user_name | TEXT | email_thread_activities.user_name | email_thread_activities.user_name |
| email_thread_activities__users | OBJECT | email_thread_activities.users | email_thread_activities.users |
Close.com events fields
The events report of the Close.com connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| events__action | TEXT | events.action | events.action |
| events__api_key_id | TEXT | events.api_key_id | events.api_key_id |
| events__changed_fields | OBJECT | events.changed_fields | events.changed_fields |
| events__data | OBJECT | events.data | events.data |
| events__date_created | TEXT | events.date_created | events.date_created |
| events__date_updated | DATE | events.date_updated | events.date_updated |
| events__id | TEXT | events.id | events.id |
| events__lead_id | TEXT | events.lead_id | events.lead_id |
| events__meta | OBJECT | events.meta | events.meta |
| events__oauth_client_id | TEXT | events.oauth_client_id | events.oauth_client_id |
| events__oauth_scope | TEXT | events.oauth_scope | events.oauth_scope |
| events__object_id | TEXT | events.object_id | events.object_id |
| events__object_type | TEXT | events.object_type | events.object_type |
| events__organization_id | TEXT | events.organization_id | events.organization_id |
| events__previous_data | OBJECT | events.previous_data | events.previous_data |
| events__request_id | TEXT | events.request_id | events.request_id |
| events__user_id | TEXT | events.user_id | events.user_id |
Close.com General fields
The General report of the Close.com connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The unique identifier for the account. |
| account_name | TEXT | Account Name | The name of the account. |
| date | DATE | Date | The date of the record. |
Close.com google_connected_accounts fields
The google_connected_accounts report of the Close.com connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| google_connected_accounts___type | TEXT | google_connected_accounts._type | google_connected_accounts._type |
| google_connected_accounts__id | TEXT | google_connected_accounts.id | google_connected_accounts.id |
| google_connected_accounts__identities | OBJECT | google_connected_accounts.identities | google_connected_accounts.identities |
| google_connected_accounts__organization_id | TEXT | google_connected_accounts.organization_id | google_connected_accounts.organization_id |
| google_connected_accounts__synced_calendars | OBJECT | google_connected_accounts.synced_calendars | google_connected_accounts.synced_calendars |
| google_connected_accounts__user_id | TEXT | google_connected_accounts.user_id | google_connected_accounts.user_id |
Close.com incoming_email_tasks fields
The incoming_email_tasks report of the Close.com connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| incoming_email_tasks___type | TEXT | incoming_email_tasks._type | incoming_email_tasks._type |
| incoming_email_tasks__assigned_to | TEXT | incoming_email_tasks.assigned_to | incoming_email_tasks.assigned_to |
| incoming_email_tasks__assigned_to_name | TEXT | incoming_email_tasks.assigned_to_name | incoming_email_tasks.assigned_to_name |
| incoming_email_tasks__body_preview | TEXT | incoming_email_tasks.body_preview | incoming_email_tasks.body_preview |
| incoming_email_tasks__cleared_followups | OBJECT | incoming_email_tasks.cleared_followups | incoming_email_tasks.cleared_followups |
| incoming_email_tasks__contact_id | TEXT | incoming_email_tasks.contact_id | incoming_email_tasks.contact_id |
| incoming_email_tasks__contact_name | TEXT | incoming_email_tasks.contact_name | incoming_email_tasks.contact_name |
| incoming_email_tasks__created_by | TEXT | incoming_email_tasks.created_by | incoming_email_tasks.created_by |
| incoming_email_tasks__created_by_name | TEXT | incoming_email_tasks.created_by_name | incoming_email_tasks.created_by_name |
| incoming_email_tasks__date | TEXT | incoming_email_tasks.date | incoming_email_tasks.date |
| incoming_email_tasks__date_created | TEXT | incoming_email_tasks.date_created | incoming_email_tasks.date_created |
| incoming_email_tasks__date_updated | DATE | incoming_email_tasks.date_updated | incoming_email_tasks.date_updated |
| incoming_email_tasks__emails | OBJECT | incoming_email_tasks.emails | incoming_email_tasks.emails |
| incoming_email_tasks__id | TEXT | incoming_email_tasks.id | incoming_email_tasks.id |
| incoming_email_tasks__is_complete | BOOLEAN | incoming_email_tasks.is_complete | incoming_email_tasks.is_complete |
| incoming_email_tasks__lead_id | TEXT | incoming_email_tasks.lead_id | incoming_email_tasks.lead_id |
| incoming_email_tasks__lead_name | TEXT | incoming_email_tasks.lead_name | incoming_email_tasks.lead_name |
| incoming_email_tasks__object_type | TEXT | incoming_email_tasks.object_type | incoming_email_tasks.object_type |
| incoming_email_tasks__organization_id | TEXT | incoming_email_tasks.organization_id | incoming_email_tasks.organization_id |
| incoming_email_tasks__subject | TEXT | incoming_email_tasks.subject | incoming_email_tasks.subject |
| incoming_email_tasks__updated_by | TEXT | incoming_email_tasks.updated_by | incoming_email_tasks.updated_by |
| incoming_email_tasks__updated_by_name | TEXT | incoming_email_tasks.updated_by_name | incoming_email_tasks.updated_by_name |
| incoming_email_tasks__view | TEXT | incoming_email_tasks.view | incoming_email_tasks.view |
Close.com incoming_sms_tasks fields
The incoming_sms_tasks report of the Close.com connector includes 25 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| incoming_sms_tasks___type | TEXT | incoming_sms_tasks._type | incoming_sms_tasks._type |
| incoming_sms_tasks__assigned_to | TEXT | incoming_sms_tasks.assigned_to | incoming_sms_tasks.assigned_to |
| incoming_sms_tasks__assigned_to_name | TEXT | incoming_sms_tasks.assigned_to_name | incoming_sms_tasks.assigned_to_name |
| incoming_sms_tasks__contact_id | TEXT | incoming_sms_tasks.contact_id | incoming_sms_tasks.contact_id |
| incoming_sms_tasks__contact_name | TEXT | incoming_sms_tasks.contact_name | incoming_sms_tasks.contact_name |
| incoming_sms_tasks__created_by | TEXT | incoming_sms_tasks.created_by | incoming_sms_tasks.created_by |
| incoming_sms_tasks__created_by_name | TEXT | incoming_sms_tasks.created_by_name | incoming_sms_tasks.created_by_name |
| incoming_sms_tasks__date | TEXT | incoming_sms_tasks.date | incoming_sms_tasks.date |
| incoming_sms_tasks__date_created | TEXT | incoming_sms_tasks.date_created | incoming_sms_tasks.date_created |
| incoming_sms_tasks__date_updated | DATE | incoming_sms_tasks.date_updated | incoming_sms_tasks.date_updated |
| incoming_sms_tasks__id | TEXT | incoming_sms_tasks.id | incoming_sms_tasks.id |
| incoming_sms_tasks__is_complete | BOOLEAN | incoming_sms_tasks.is_complete | incoming_sms_tasks.is_complete |
| incoming_sms_tasks__lead_id | TEXT | incoming_sms_tasks.lead_id | incoming_sms_tasks.lead_id |
| incoming_sms_tasks__lead_name | TEXT | incoming_sms_tasks.lead_name | incoming_sms_tasks.lead_name |
| incoming_sms_tasks__local_phone | TEXT | incoming_sms_tasks.local_phone | incoming_sms_tasks.local_phone |
| incoming_sms_tasks__object_id | TEXT | incoming_sms_tasks.object_id | incoming_sms_tasks.object_id |
| incoming_sms_tasks__object_type | TEXT | incoming_sms_tasks.object_type | incoming_sms_tasks.object_type |
| incoming_sms_tasks__organization_id | TEXT | incoming_sms_tasks.organization_id | incoming_sms_tasks.organization_id |
| incoming_sms_tasks__remote_phone | TEXT | incoming_sms_tasks.remote_phone | incoming_sms_tasks.remote_phone |
| incoming_sms_tasks__remote_phone_description | TEXT | incoming_sms_tasks.remote_phone_description | incoming_sms_tasks.remote_phone_description |
| incoming_sms_tasks__remote_phone_formatted | TEXT | incoming_sms_tasks.remote_phone_formatted | incoming_sms_tasks.remote_phone_formatted |
| incoming_sms_tasks__text | TEXT | incoming_sms_tasks.text | incoming_sms_tasks.text |
| incoming_sms_tasks__updated_by | TEXT | incoming_sms_tasks.updated_by | incoming_sms_tasks.updated_by |
| incoming_sms_tasks__updated_by_name | TEXT | incoming_sms_tasks.updated_by_name | incoming_sms_tasks.updated_by_name |
| incoming_sms_tasks__view | TEXT | incoming_sms_tasks.view | incoming_sms_tasks.view |
Close.com integration_links fields
The integration_links report of the Close.com connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| integration_links__created_by | TEXT | integration_links.created_by | integration_links.created_by |
| integration_links__date_created | TEXT | integration_links.date_created | integration_links.date_created |
| integration_links__date_updated | DATE | integration_links.date_updated | integration_links.date_updated |
| integration_links__id | TEXT | integration_links.id | integration_links.id |
| integration_links__name | TEXT | integration_links.name | integration_links.name |
| integration_links__organization_id | TEXT | integration_links.organization_id | integration_links.organization_id |
| integration_links__type | TEXT | integration_links.type | integration_links.type |
| integration_links__updated_by | TEXT | integration_links.updated_by | integration_links.updated_by |
| integration_links__url | TEXT | integration_links.url | integration_links.url |
Close.com lead_custom_fields fields
The lead_custom_fields report of the Close.com connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| lead_custom_fields__accepts_multiple_values | TEXT | lead_custom_fields.accepts_multiple_values | lead_custom_fields.accepts_multiple_values |
| lead_custom_fields__back_reference_is_visible | TEXT | lead_custom_fields.back_reference_is_visible | lead_custom_fields.back_reference_is_visible |
| lead_custom_fields__choices | TEXT | lead_custom_fields.choices | lead_custom_fields.choices |
| lead_custom_fields__created_by | TEXT | lead_custom_fields.created_by | lead_custom_fields.created_by |
| lead_custom_fields__date_created | TEXT | lead_custom_fields.date_created | lead_custom_fields.date_created |
| lead_custom_fields__date_updated | DATE | lead_custom_fields.date_updated | lead_custom_fields.date_updated |
| lead_custom_fields__description | TEXT | lead_custom_fields.description | lead_custom_fields.description |
| lead_custom_fields__editable_with_roles | TEXT | lead_custom_fields.editable_with_roles | lead_custom_fields.editable_with_roles |
| lead_custom_fields__id | TEXT | lead_custom_fields.id | lead_custom_fields.id |
| lead_custom_fields__is_shared | TEXT | lead_custom_fields.is_shared | lead_custom_fields.is_shared |
| lead_custom_fields__name | TEXT | lead_custom_fields.name | lead_custom_fields.name |
| lead_custom_fields__organization_id | TEXT | lead_custom_fields.organization_id | lead_custom_fields.organization_id |
| lead_custom_fields__referenced_custom_type_id | TEXT | lead_custom_fields.referenced_custom_type_id | lead_custom_fields.referenced_custom_type_id |
| lead_custom_fields__status_id | TEXT | lead_custom_fields.status_id | lead_custom_fields.status_id |
| lead_custom_fields__type | TEXT | lead_custom_fields.type | lead_custom_fields.type |
| lead_custom_fields__updated_by | TEXT | lead_custom_fields.updated_by | lead_custom_fields.updated_by |
Close.com lead_status_change_activities fields
The lead_status_change_activities report of the Close.com connector includes 19 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| lead_status_change_activities___type | TEXT | lead_status_change_activities._type | lead_status_change_activities._type |
| lead_status_change_activities__activity_at | DATE | lead_status_change_activities.activity_at | lead_status_change_activities.activity_at |
| lead_status_change_activities__contact_id | TEXT | lead_status_change_activities.contact_id | lead_status_change_activities.contact_id |
| lead_status_change_activities__created_by | TEXT | lead_status_change_activities.created_by | lead_status_change_activities.created_by |
| lead_status_change_activities__created_by_name | TEXT | lead_status_change_activities.created_by_name | lead_status_change_activities.created_by_name |
| lead_status_change_activities__date_created | TEXT | lead_status_change_activities.date_created | lead_status_change_activities.date_created |
| lead_status_change_activities__date_updated | DATE | lead_status_change_activities.date_updated | lead_status_change_activities.date_updated |
| lead_status_change_activities__id | TEXT | lead_status_change_activities.id | lead_status_change_activities.id |
| lead_status_change_activities__lead_id | TEXT | lead_status_change_activities.lead_id | lead_status_change_activities.lead_id |
| lead_status_change_activities__new_status_id | TEXT | lead_status_change_activities.new_status_id | lead_status_change_activities.new_status_id |
| lead_status_change_activities__new_status_label | TEXT | lead_status_change_activities.new_status_label | lead_status_change_activities.new_status_label |
| lead_status_change_activities__old_status_id | TEXT | lead_status_change_activities.old_status_id | lead_status_change_activities.old_status_id |
| lead_status_change_activities__old_status_label | TEXT | lead_status_change_activities.old_status_label | lead_status_change_activities.old_status_label |
| lead_status_change_activities__organization_id | TEXT | lead_status_change_activities.organization_id | lead_status_change_activities.organization_id |
| lead_status_change_activities__updated_by | TEXT | lead_status_change_activities.updated_by | lead_status_change_activities.updated_by |
| lead_status_change_activities__updated_by_name | TEXT | lead_status_change_activities.updated_by_name | lead_status_change_activities.updated_by_name |
| lead_status_change_activities__user_id | TEXT | lead_status_change_activities.user_id | lead_status_change_activities.user_id |
| lead_status_change_activities__user_name | TEXT | lead_status_change_activities.user_name | lead_status_change_activities.user_name |
| lead_status_change_activities__users | OBJECT | lead_status_change_activities.users | lead_status_change_activities.users |
Close.com lead_statuses fields
The lead_statuses report of the Close.com connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| lead_statuses__id | TEXT | lead_statuses.id | lead_statuses.id |
| lead_statuses__label | TEXT | lead_statuses.label | lead_statuses.label |
| lead_statuses__organization_id | TEXT | lead_statuses.organization_id | lead_statuses.organization_id |
Close.com lead_tasks fields
The lead_tasks report of the Close.com connector includes 23 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| lead_tasks___type | TEXT | lead_tasks._type | lead_tasks._type |
| lead_tasks__assigned_to | TEXT | lead_tasks.assigned_to | lead_tasks.assigned_to |
| lead_tasks__assigned_to_name | TEXT | lead_tasks.assigned_to_name | lead_tasks.assigned_to_name |
| lead_tasks__contact_id | TEXT | lead_tasks.contact_id | lead_tasks.contact_id |
| lead_tasks__contact_name | TEXT | lead_tasks.contact_name | lead_tasks.contact_name |
| lead_tasks__created_by | TEXT | lead_tasks.created_by | lead_tasks.created_by |
| lead_tasks__created_by_name | TEXT | lead_tasks.created_by_name | lead_tasks.created_by_name |
| lead_tasks__date | TEXT | lead_tasks.date | lead_tasks.date |
| lead_tasks__date_created | TEXT | lead_tasks.date_created | lead_tasks.date_created |
| lead_tasks__date_updated | DATE | lead_tasks.date_updated | lead_tasks.date_updated |
| lead_tasks__due_date | TEXT | lead_tasks.due_date | lead_tasks.due_date |
| lead_tasks__id | TEXT | lead_tasks.id | lead_tasks.id |
| lead_tasks__is_complete | BOOLEAN | lead_tasks.is_complete | lead_tasks.is_complete |
| lead_tasks__is_dateless | BOOLEAN | lead_tasks.is_dateless | lead_tasks.is_dateless |
| lead_tasks__lead_id | TEXT | lead_tasks.lead_id | lead_tasks.lead_id |
| lead_tasks__lead_name | TEXT | lead_tasks.lead_name | lead_tasks.lead_name |
| lead_tasks__object_id | TEXT | lead_tasks.object_id | lead_tasks.object_id |
| lead_tasks__object_type | TEXT | lead_tasks.object_type | lead_tasks.object_type |
| lead_tasks__organization_id | TEXT | lead_tasks.organization_id | lead_tasks.organization_id |
| lead_tasks__text | TEXT | lead_tasks.text | lead_tasks.text |
| lead_tasks__updated_by | TEXT | lead_tasks.updated_by | lead_tasks.updated_by |
| lead_tasks__updated_by_name | TEXT | lead_tasks.updated_by_name | lead_tasks.updated_by_name |
| lead_tasks__view | TEXT | lead_tasks.view | lead_tasks.view |
Close.com leads fields
The leads report of the Close.com connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| leads__addresses | OBJECT | leads.addresses | leads.addresses |
| leads__contacts | OBJECT | leads.contacts | leads.contacts |
| leads__created_by | TEXT | leads.created_by | leads.created_by |
| leads__created_by_name | TEXT | leads.created_by_name | leads.created_by_name |
| leads__custom | OBJECT | leads.custom | leads.custom |
| leads__date_created | TEXT | leads.date_created | leads.date_created |
| leads__date_updated | DATE | leads.date_updated | leads.date_updated |
| leads__description | TEXT | leads.description | leads.description |
| leads__display_name | TEXT | leads.display_name | leads.display_name |
| leads__html_url | TEXT | leads.html_url | leads.html_url |
| leads__id | TEXT | leads.id | leads.id |
| leads__integration_links | OBJECT | leads.integration_links | leads.integration_links |
| leads__name | TEXT | leads.name | leads.name |
| leads__opportunities | OBJECT | leads.opportunities | leads.opportunities |
| leads__organization_id | TEXT | leads.organization_id | leads.organization_id |
| leads__status_id | TEXT | leads.status_id | leads.status_id |
| leads__status_label | TEXT | leads.status_label | leads.status_label |
| leads__tasks | OBJECT | leads.tasks | leads.tasks |
| leads__updated_by | TEXT | leads.updated_by | leads.updated_by |
| leads__updated_by_name | TEXT | leads.updated_by_name | leads.updated_by_name |
| leads__url | TEXT | leads.url | leads.url |
Close.com meeting_activities fields
The meeting_activities report of the Close.com connector includes 38 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| meeting_activities___type | TEXT | meeting_activities._type | meeting_activities._type |
| meeting_activities__activity_at | DATE | meeting_activities.activity_at | meeting_activities.activity_at |
| meeting_activities__attendees | OBJECT | meeting_activities.attendees | meeting_activities.attendees |
| meeting_activities__calendar_event_link | TEXT | meeting_activities.calendar_event_link | meeting_activities.calendar_event_link |
| meeting_activities__calendar_event_uids | OBJECT | meeting_activities.calendar_event_uids | meeting_activities.calendar_event_uids |
| meeting_activities__conference_links | OBJECT | meeting_activities.conference_links | meeting_activities.conference_links |
| meeting_activities__connected_account_id | TEXT | meeting_activities.connected_account_id | meeting_activities.connected_account_id |
| meeting_activities__contact_id | TEXT | meeting_activities.contact_id | meeting_activities.contact_id |
| meeting_activities__created_by | TEXT | meeting_activities.created_by | meeting_activities.created_by |
| meeting_activities__created_by_name | TEXT | meeting_activities.created_by_name | meeting_activities.created_by_name |
| meeting_activities__date_created | TEXT | meeting_activities.date_created | meeting_activities.date_created |
| meeting_activities__date_updated | DATE | meeting_activities.date_updated | meeting_activities.date_updated |
| meeting_activities__duration | NUMERIC | meeting_activities.duration | meeting_activities.duration |
| meeting_activities__ends_at | DATE | meeting_activities.ends_at | meeting_activities.ends_at |
| meeting_activities__id | TEXT | meeting_activities.id | meeting_activities.id |
| meeting_activities__integrations | OBJECT | meeting_activities.integrations | meeting_activities.integrations |
| meeting_activities__is_recurring | BOOLEAN | meeting_activities.is_recurring | meeting_activities.is_recurring |
| meeting_activities__lead_id | TEXT | meeting_activities.lead_id | meeting_activities.lead_id |
| meeting_activities__location | TEXT | meeting_activities.location | meeting_activities.location |
| meeting_activities__note | TEXT | meeting_activities.note | meeting_activities.note |
| meeting_activities__notetaker_id | TEXT | meeting_activities.notetaker_id | meeting_activities.notetaker_id |
| meeting_activities__organization_id | TEXT | meeting_activities.organization_id | meeting_activities.organization_id |
| meeting_activities__provider_calendar_event_id | TEXT | meeting_activities.provider_calendar_event_id | meeting_activities.provider_calendar_event_id |
| meeting_activities__provider_calendar_ids | OBJECT | meeting_activities.provider_calendar_ids | meeting_activities.provider_calendar_ids |
| meeting_activities__provider_calendar_type | TEXT | meeting_activities.provider_calendar_type | meeting_activities.provider_calendar_type |
| meeting_activities__source | TEXT | meeting_activities.source | meeting_activities.source |
| meeting_activities__starts_at | DATE | meeting_activities.starts_at | meeting_activities.starts_at |
| meeting_activities__status | TEXT | meeting_activities.status | meeting_activities.status |
| meeting_activities__summary | TEXT | meeting_activities.summary | meeting_activities.summary |
| meeting_activities__title | TEXT | meeting_activities.title | meeting_activities.title |
| meeting_activities__updated_by | TEXT | meeting_activities.updated_by | meeting_activities.updated_by |
| meeting_activities__updated_by_name | TEXT | meeting_activities.updated_by_name | meeting_activities.updated_by_name |
| meeting_activities__user_id | TEXT | meeting_activities.user_id | meeting_activities.user_id |
| meeting_activities__user_name | TEXT | meeting_activities.user_name | meeting_activities.user_name |
| meeting_activities__user_note | TEXT | meeting_activities.user_note | meeting_activities.user_note |
| meeting_activities__user_note_date_updated | DATE | meeting_activities.user_note_date_updated | meeting_activities.user_note_date_updated |
| meeting_activities__user_note_html | TEXT | meeting_activities.user_note_html | meeting_activities.user_note_html |
| meeting_activities__users | OBJECT | meeting_activities.users | meeting_activities.users |
Close.com missed_call_tasks fields
The missed_call_tasks report of the Close.com connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| missed_call_tasks___type | TEXT | missed_call_tasks._type | missed_call_tasks._type |
| missed_call_tasks__assigned_to | TEXT | missed_call_tasks.assigned_to | missed_call_tasks.assigned_to |
| missed_call_tasks__assigned_to_name | TEXT | missed_call_tasks.assigned_to_name | missed_call_tasks.assigned_to_name |
| missed_call_tasks__contact_id | TEXT | missed_call_tasks.contact_id | missed_call_tasks.contact_id |
| missed_call_tasks__contact_name | TEXT | missed_call_tasks.contact_name | missed_call_tasks.contact_name |
| missed_call_tasks__created_by | TEXT | missed_call_tasks.created_by | missed_call_tasks.created_by |
| missed_call_tasks__created_by_name | TEXT | missed_call_tasks.created_by_name | missed_call_tasks.created_by_name |
| missed_call_tasks__date | TEXT | missed_call_tasks.date | missed_call_tasks.date |
| missed_call_tasks__date_created | TEXT | missed_call_tasks.date_created | missed_call_tasks.date_created |
| missed_call_tasks__date_updated | DATE | missed_call_tasks.date_updated | missed_call_tasks.date_updated |
| missed_call_tasks__id | TEXT | missed_call_tasks.id | missed_call_tasks.id |
| missed_call_tasks__is_complete | BOOLEAN | missed_call_tasks.is_complete | missed_call_tasks.is_complete |
| missed_call_tasks__lead_id | TEXT | missed_call_tasks.lead_id | missed_call_tasks.lead_id |
| missed_call_tasks__lead_name | TEXT | missed_call_tasks.lead_name | missed_call_tasks.lead_name |
| missed_call_tasks__local_phone | TEXT | missed_call_tasks.local_phone | missed_call_tasks.local_phone |
| missed_call_tasks__object_id | TEXT | missed_call_tasks.object_id | missed_call_tasks.object_id |
| missed_call_tasks__object_type | TEXT | missed_call_tasks.object_type | missed_call_tasks.object_type |
| missed_call_tasks__organization_id | TEXT | missed_call_tasks.organization_id | missed_call_tasks.organization_id |
| missed_call_tasks__phone | TEXT | missed_call_tasks.phone | missed_call_tasks.phone |
| missed_call_tasks__phone_formatted | TEXT | missed_call_tasks.phone_formatted | missed_call_tasks.phone_formatted |
| missed_call_tasks__phone_number_description | TEXT | missed_call_tasks.phone_number_description | missed_call_tasks.phone_number_description |
| missed_call_tasks__updated_by | TEXT | missed_call_tasks.updated_by | missed_call_tasks.updated_by |
| missed_call_tasks__updated_by_name | TEXT | missed_call_tasks.updated_by_name | missed_call_tasks.updated_by_name |
| missed_call_tasks__view | TEXT | missed_call_tasks.view | missed_call_tasks.view |
Close.com note_activities fields
The note_activities report of the Close.com connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| note_activities___type | TEXT | note_activities._type | note_activities._type |
| note_activities__contact_id | TEXT | note_activities.contact_id | note_activities.contact_id |
| note_activities__created_by | TEXT | note_activities.created_by | note_activities.created_by |
| note_activities__created_by_name | TEXT | note_activities.created_by_name | note_activities.created_by_name |
| note_activities__date_created | TEXT | note_activities.date_created | note_activities.date_created |
| note_activities__date_updated | DATE | note_activities.date_updated | note_activities.date_updated |
| note_activities__id | TEXT | note_activities.id | note_activities.id |
| note_activities__lead_id | TEXT | note_activities.lead_id | note_activities.lead_id |
| note_activities__note | TEXT | note_activities.note | note_activities.note |
| note_activities__organization_id | TEXT | note_activities.organization_id | note_activities.organization_id |
| note_activities__updated_by | TEXT | note_activities.updated_by | note_activities.updated_by |
| note_activities__updated_by_name | TEXT | note_activities.updated_by_name | note_activities.updated_by_name |
| note_activities__user_id | TEXT | note_activities.user_id | note_activities.user_id |
| note_activities__user_name | TEXT | note_activities.user_name | note_activities.user_name |
Close.com opportunities fields
The opportunities report of the Close.com connector includes 30 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| opportunities__annualized_expected_value | NUMERIC | opportunities.annualized_expected_value | opportunities.annualized_expected_value |
| opportunities__annualized_value | NUMERIC | opportunities.annualized_value | opportunities.annualized_value |
| opportunities__confidence | NUMERIC | opportunities.confidence | opportunities.confidence |
| opportunities__contact_id | TEXT | opportunities.contact_id | opportunities.contact_id |
| opportunities__contact_name | TEXT | opportunities.contact_name | opportunities.contact_name |
| opportunities__created_by | TEXT | opportunities.created_by | opportunities.created_by |
| opportunities__created_by_name | TEXT | opportunities.created_by_name | opportunities.created_by_name |
| opportunities__date_created | TEXT | opportunities.date_created | opportunities.date_created |
| opportunities__date_lost | TEXT | opportunities.date_lost | opportunities.date_lost |
| opportunities__date_updated | DATE | opportunities.date_updated | opportunities.date_updated |
| opportunities__date_won | TEXT | opportunities.date_won | opportunities.date_won |
| opportunities__expected_value | NUMERIC | opportunities.expected_value | opportunities.expected_value |
| opportunities__id | TEXT | opportunities.id | opportunities.id |
| opportunities__integration_links | OBJECT | opportunities.integration_links | opportunities.integration_links |
| opportunities__lead_id | TEXT | opportunities.lead_id | opportunities.lead_id |
| opportunities__lead_name | TEXT | opportunities.lead_name | opportunities.lead_name |
| opportunities__note | TEXT | opportunities.note | opportunities.note |
| opportunities__organization_id | TEXT | opportunities.organization_id | opportunities.organization_id |
| opportunities__status_display_name | TEXT | opportunities.status_display_name | opportunities.status_display_name |
| opportunities__status_id | TEXT | opportunities.status_id | opportunities.status_id |
| opportunities__status_label | TEXT | opportunities.status_label | opportunities.status_label |
| opportunities__status_type | TEXT | opportunities.status_type | opportunities.status_type |
| opportunities__updated_by | TEXT | opportunities.updated_by | opportunities.updated_by |
| opportunities__updated_by_name | TEXT | opportunities.updated_by_name | opportunities.updated_by_name |
| opportunities__user_id | TEXT | opportunities.user_id | opportunities.user_id |
| opportunities__user_name | TEXT | opportunities.user_name | opportunities.user_name |
| opportunities__value | NUMERIC | opportunities.value | opportunities.value |
| opportunities__value_currency | TEXT | opportunities.value_currency | opportunities.value_currency |
| opportunities__value_formatted | TEXT | opportunities.value_formatted | opportunities.value_formatted |
| opportunities__value_period | TEXT | opportunities.value_period | opportunities.value_period |
Close.com opportunity_custom_fields fields
The opportunity_custom_fields report of the Close.com connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| opportunity_custom_fields__accepts_multiple_values | TEXT | opportunity_custom_fields.accepts_multiple_values | opportunity_custom_fields.accepts_multiple_values |
| opportunity_custom_fields__back_reference_is_visible | TEXT | opportunity_custom_fields.back_reference_is_visible | opportunity_custom_fields.back_reference_is_visible |
| opportunity_custom_fields__choices | TEXT | opportunity_custom_fields.choices | opportunity_custom_fields.choices |
| opportunity_custom_fields__created_by | TEXT | opportunity_custom_fields.created_by | opportunity_custom_fields.created_by |
| opportunity_custom_fields__date_created | TEXT | opportunity_custom_fields.date_created | opportunity_custom_fields.date_created |
| opportunity_custom_fields__date_updated | DATE | opportunity_custom_fields.date_updated | opportunity_custom_fields.date_updated |
| opportunity_custom_fields__description | TEXT | opportunity_custom_fields.description | opportunity_custom_fields.description |
| opportunity_custom_fields__editable_with_roles | TEXT | opportunity_custom_fields.editable_with_roles | opportunity_custom_fields.editable_with_roles |
| opportunity_custom_fields__id | TEXT | opportunity_custom_fields.id | opportunity_custom_fields.id |
| opportunity_custom_fields__is_shared | TEXT | opportunity_custom_fields.is_shared | opportunity_custom_fields.is_shared |
| opportunity_custom_fields__name | TEXT | opportunity_custom_fields.name | opportunity_custom_fields.name |
| opportunity_custom_fields__organization_id | TEXT | opportunity_custom_fields.organization_id | opportunity_custom_fields.organization_id |
| opportunity_custom_fields__referenced_custom_type_id | TEXT | opportunity_custom_fields.referenced_custom_type_id | opportunity_custom_fields.referenced_custom_type_id |
| opportunity_custom_fields__type | TEXT | opportunity_custom_fields.type | opportunity_custom_fields.type |
| opportunity_custom_fields__updated_by | TEXT | opportunity_custom_fields.updated_by | opportunity_custom_fields.updated_by |
Close.com opportunity_due_tasks fields
The opportunity_due_tasks report of the Close.com connector includes 24 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| opportunity_due_tasks___type | TEXT | opportunity_due_tasks._type | opportunity_due_tasks._type |
| opportunity_due_tasks__assigned_to | TEXT | opportunity_due_tasks.assigned_to | opportunity_due_tasks.assigned_to |
| opportunity_due_tasks__assigned_to_name | TEXT | opportunity_due_tasks.assigned_to_name | opportunity_due_tasks.assigned_to_name |
| opportunity_due_tasks__contact_id | TEXT | opportunity_due_tasks.contact_id | opportunity_due_tasks.contact_id |
| opportunity_due_tasks__contact_name | TEXT | opportunity_due_tasks.contact_name | opportunity_due_tasks.contact_name |
| opportunity_due_tasks__created_by | TEXT | opportunity_due_tasks.created_by | opportunity_due_tasks.created_by |
| opportunity_due_tasks__created_by_name | TEXT | opportunity_due_tasks.created_by_name | opportunity_due_tasks.created_by_name |
| opportunity_due_tasks__date | TEXT | opportunity_due_tasks.date | opportunity_due_tasks.date |
| opportunity_due_tasks__date_created | TEXT | opportunity_due_tasks.date_created | opportunity_due_tasks.date_created |
| opportunity_due_tasks__date_updated | DATE | opportunity_due_tasks.date_updated | opportunity_due_tasks.date_updated |
| opportunity_due_tasks__id | TEXT | opportunity_due_tasks.id | opportunity_due_tasks.id |
| opportunity_due_tasks__is_complete | BOOLEAN | opportunity_due_tasks.is_complete | opportunity_due_tasks.is_complete |
| opportunity_due_tasks__lead_id | TEXT | opportunity_due_tasks.lead_id | opportunity_due_tasks.lead_id |
| opportunity_due_tasks__lead_name | TEXT | opportunity_due_tasks.lead_name | opportunity_due_tasks.lead_name |
| opportunity_due_tasks__object_id | TEXT | opportunity_due_tasks.object_id | opportunity_due_tasks.object_id |
| opportunity_due_tasks__object_type | TEXT | opportunity_due_tasks.object_type | opportunity_due_tasks.object_type |
| opportunity_due_tasks__opportunity_note | TEXT | opportunity_due_tasks.opportunity_note | opportunity_due_tasks.opportunity_note |
| opportunity_due_tasks__opportunity_value | NUMERIC | opportunity_due_tasks.opportunity_value | opportunity_due_tasks.opportunity_value |
| opportunity_due_tasks__opportunity_value_formatted | TEXT | opportunity_due_tasks.opportunity_value_formatted | opportunity_due_tasks.opportunity_value_formatted |
| opportunity_due_tasks__opportunity_value_period | TEXT | opportunity_due_tasks.opportunity_value_period | opportunity_due_tasks.opportunity_value_period |
| opportunity_due_tasks__organization_id | TEXT | opportunity_due_tasks.organization_id | opportunity_due_tasks.organization_id |
| opportunity_due_tasks__updated_by | TEXT | opportunity_due_tasks.updated_by | opportunity_due_tasks.updated_by |
| opportunity_due_tasks__updated_by_name | TEXT | opportunity_due_tasks.updated_by_name | opportunity_due_tasks.updated_by_name |
| opportunity_due_tasks__view | TEXT | opportunity_due_tasks.view | opportunity_due_tasks.view |
Close.com opportunity_status_change_activities fields
The opportunity_status_change_activities report of the Close.com connector includes 32 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| opportunity_status_change_activities___type | TEXT | opportunity_status_change_activities._type | opportunity_status_change_activities._type |
| opportunity_status_change_activities__activity_at | DATE | opportunity_status_change_activities.activity_at | opportunity_status_change_activities.activity_at |
| opportunity_status_change_activities__contact_id | TEXT | opportunity_status_change_activities.contact_id | opportunity_status_change_activities.contact_id |
| opportunity_status_change_activities__created_by | TEXT | opportunity_status_change_activities.created_by | opportunity_status_change_activities.created_by |
| opportunity_status_change_activities__created_by_name | TEXT | opportunity_status_change_activities.created_by_name | opportunity_status_change_activities.created_by_name |
| opportunity_status_change_activities__date_created | TEXT | opportunity_status_change_activities.date_created | opportunity_status_change_activities.date_created |
| opportunity_status_change_activities__date_updated | DATE | opportunity_status_change_activities.date_updated | opportunity_status_change_activities.date_updated |
| opportunity_status_change_activities__id | TEXT | opportunity_status_change_activities.id | opportunity_status_change_activities.id |
| opportunity_status_change_activities__lead_id | TEXT | opportunity_status_change_activities.lead_id | opportunity_status_change_activities.lead_id |
| opportunity_status_change_activities__new_pipeline_id | TEXT | opportunity_status_change_activities.new_pipeline_id | opportunity_status_change_activities.new_pipeline_id |
| opportunity_status_change_activities__new_pipeline_name | TEXT | opportunity_status_change_activities.new_pipeline_name | opportunity_status_change_activities.new_pipeline_name |
| opportunity_status_change_activities__new_status_id | TEXT | opportunity_status_change_activities.new_status_id | opportunity_status_change_activities.new_status_id |
| opportunity_status_change_activities__new_status_label | TEXT | opportunity_status_change_activities.new_status_label | opportunity_status_change_activities.new_status_label |
| opportunity_status_change_activities__new_status_type | TEXT | opportunity_status_change_activities.new_status_type | opportunity_status_change_activities.new_status_type |
| opportunity_status_change_activities__old_pipeline_id | TEXT | opportunity_status_change_activities.old_pipeline_id | opportunity_status_change_activities.old_pipeline_id |
| opportunity_status_change_activities__old_pipeline_name | TEXT | opportunity_status_change_activities.old_pipeline_name | opportunity_status_change_activities.old_pipeline_name |
| opportunity_status_change_activities__old_status_id | TEXT | opportunity_status_change_activities.old_status_id | opportunity_status_change_activities.old_status_id |
| opportunity_status_change_activities__old_status_label | TEXT | opportunity_status_change_activities.old_status_label | opportunity_status_change_activities.old_status_label |
| opportunity_status_change_activities__old_status_type | TEXT | opportunity_status_change_activities.old_status_type | opportunity_status_change_activities.old_status_type |
| opportunity_status_change_activities__opportunity_confidence | NUMERIC | opportunity_status_change_activities.opportunity_confidence | opportunity_status_change_activities.opportunity_confidence |
| opportunity_status_change_activities__opportunity_date_won | TEXT | opportunity_status_change_activities.opportunity_date_won | opportunity_status_change_activities.opportunity_date_won |
| opportunity_status_change_activities__opportunity_id | TEXT | opportunity_status_change_activities.opportunity_id | opportunity_status_change_activities.opportunity_id |
| opportunity_status_change_activities__opportunity_value | NUMERIC | opportunity_status_change_activities.opportunity_value | opportunity_status_change_activities.opportunity_value |
| opportunity_status_change_activities__opportunity_value_currency | TEXT | opportunity_status_change_activities.opportunity_value_currency | opportunity_status_change_activities.opportunity_value_currency |
| opportunity_status_change_activities__opportunity_value_formatted | TEXT | opportunity_status_change_activities.opportunity_value_formatted | opportunity_status_change_activities.opportunity_value_formatted |
| opportunity_status_change_activities__opportunity_value_period | TEXT | opportunity_status_change_activities.opportunity_value_period | opportunity_status_change_activities.opportunity_value_period |
| opportunity_status_change_activities__organization_id | TEXT | opportunity_status_change_activities.organization_id | opportunity_status_change_activities.organization_id |
| opportunity_status_change_activities__updated_by | TEXT | opportunity_status_change_activities.updated_by | opportunity_status_change_activities.updated_by |
| opportunity_status_change_activities__updated_by_name | TEXT | opportunity_status_change_activities.updated_by_name | opportunity_status_change_activities.updated_by_name |
| opportunity_status_change_activities__user_id | TEXT | opportunity_status_change_activities.user_id | opportunity_status_change_activities.user_id |
| opportunity_status_change_activities__user_name | TEXT | opportunity_status_change_activities.user_name | opportunity_status_change_activities.user_name |
| opportunity_status_change_activities__users | OBJECT | opportunity_status_change_activities.users | opportunity_status_change_activities.users |
Close.com opportunity_statuses fields
The opportunity_statuses report of the Close.com connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| opportunity_statuses__id | TEXT | opportunity_statuses.id | opportunity_statuses.id |
| opportunity_statuses__label | TEXT | opportunity_statuses.label | opportunity_statuses.label |
| opportunity_statuses__organization_id | TEXT | opportunity_statuses.organization_id | opportunity_statuses.organization_id |
| opportunity_statuses__pipeline_id | TEXT | opportunity_statuses.pipeline_id | opportunity_statuses.pipeline_id |
| opportunity_statuses__type | TEXT | opportunity_statuses.type | opportunity_statuses.type |
Close.com pipelines fields
The pipelines report of the Close.com connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| pipelines__created_by | TEXT | pipelines.created_by | pipelines.created_by |
| pipelines__date_created | TEXT | pipelines.date_created | pipelines.date_created |
| pipelines__date_updated | DATE | pipelines.date_updated | pipelines.date_updated |
| pipelines__id | TEXT | pipelines.id | pipelines.id |
| pipelines__name | TEXT | pipelines.name | pipelines.name |
| pipelines__organization_id | TEXT | pipelines.organization_id | pipelines.organization_id |
| pipelines__statuses | OBJECT | pipelines.statuses | pipelines.statuses |
| pipelines__updated_by | TEXT | pipelines.updated_by | pipelines.updated_by |
Close.com roles fields
The roles report of the Close.com connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| roles__date_created | TEXT | roles.date_created | roles.date_created |
| roles__date_updated | DATE | roles.date_updated | roles.date_updated |
| roles__editable | BOOLEAN | roles.editable | roles.editable |
| roles__id | TEXT | roles.id | roles.id |
| roles__name | TEXT | roles.name | roles.name |
| roles__organization_id | TEXT | roles.organization_id | roles.organization_id |
| roles__permissions | OBJECT | roles.permissions | roles.permissions |
| roles__visibility_user_lcf_behavior | TEXT | roles.visibility_user_lcf_behavior | roles.visibility_user_lcf_behavior |
| roles__visibility_user_lcf_ids | OBJECT | roles.visibility_user_lcf_ids | roles.visibility_user_lcf_ids |
Close.com send_as fields
The send_as report of the Close.com connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| send_as__allowed_user_id | TEXT | send_as.allowed_user_id | send_as.allowed_user_id |
| send_as__allowing_user_id | TEXT | send_as.allowing_user_id | send_as.allowing_user_id |
| send_as__id | TEXT | send_as.id | send_as.id |
| send_as__organization_id | TEXT | send_as.organization_id | send_as.organization_id |
Close.com sequence_subscription_bulk_actions fields
The sequence_subscription_bulk_actions report of the Close.com connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sequence_subscription_bulk_actions__action_type | TEXT | sequence_subscription_bulk_actions.action_type | sequence_subscription_bulk_actions.action_type |
| sequence_subscription_bulk_actions__contact_preference | TEXT | sequence_subscription_bulk_actions.contact_preference | sequence_subscription_bulk_actions.contact_preference |
| sequence_subscription_bulk_actions__created_by | TEXT | sequence_subscription_bulk_actions.created_by | sequence_subscription_bulk_actions.created_by |
| sequence_subscription_bulk_actions__date_created | TEXT | sequence_subscription_bulk_actions.date_created | sequence_subscription_bulk_actions.date_created |
| sequence_subscription_bulk_actions__date_updated | DATE | sequence_subscription_bulk_actions.date_updated | sequence_subscription_bulk_actions.date_updated |
| sequence_subscription_bulk_actions__id | TEXT | sequence_subscription_bulk_actions.id | sequence_subscription_bulk_actions.id |
| sequence_subscription_bulk_actions__n_leads | NUMERIC | sequence_subscription_bulk_actions.n_leads | sequence_subscription_bulk_actions.n_leads |
| sequence_subscription_bulk_actions__n_leads_processed | NUMERIC | sequence_subscription_bulk_actions.n_leads_processed | sequence_subscription_bulk_actions.n_leads_processed |
| sequence_subscription_bulk_actions__organization_id | TEXT | sequence_subscription_bulk_actions.organization_id | sequence_subscription_bulk_actions.organization_id |
| sequence_subscription_bulk_actions__query | TEXT | sequence_subscription_bulk_actions.query | sequence_subscription_bulk_actions.query |
| sequence_subscription_bulk_actions__send_done_email | BOOLEAN | sequence_subscription_bulk_actions.send_done_email | sequence_subscription_bulk_actions.send_done_email |
| sequence_subscription_bulk_actions__sender_account_id | TEXT | sequence_subscription_bulk_actions.sender_account_id | sequence_subscription_bulk_actions.sender_account_id |
| sequence_subscription_bulk_actions__sender_email | TEXT | sequence_subscription_bulk_actions.sender_email | sequence_subscription_bulk_actions.sender_email |
| sequence_subscription_bulk_actions__sender_name | TEXT | sequence_subscription_bulk_actions.sender_name | sequence_subscription_bulk_actions.sender_name |
| sequence_subscription_bulk_actions__sequence_id | TEXT | sequence_subscription_bulk_actions.sequence_id | sequence_subscription_bulk_actions.sequence_id |
| sequence_subscription_bulk_actions__status | TEXT | sequence_subscription_bulk_actions.status | sequence_subscription_bulk_actions.status |
| sequence_subscription_bulk_actions__updated_by | TEXT | sequence_subscription_bulk_actions.updated_by | sequence_subscription_bulk_actions.updated_by |
Close.com smart_views fields
The smart_views report of the Close.com connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| smart_views__date_created | TEXT | smart_views.date_created | smart_views.date_created |
| smart_views__date_updated | DATE | smart_views.date_updated | smart_views.date_updated |
| smart_views__id | TEXT | smart_views.id | smart_views.id |
| smart_views__is_shared | BOOLEAN | smart_views.is_shared | smart_views.is_shared |
| smart_views__is_user_dependent | BOOLEAN | smart_views.is_user_dependent | smart_views.is_user_dependent |
| smart_views__name | TEXT | smart_views.name | smart_views.name |
| smart_views__organization_id | TEXT | smart_views.organization_id | smart_views.organization_id |
| smart_views__query | TEXT | smart_views.query | smart_views.query |
| smart_views__s_query | OBJECT | smart_views.s_query | smart_views.s_query |
| smart_views__type | TEXT | smart_views.type | smart_views.type |
| smart_views__user_id | TEXT | smart_views.user_id | smart_views.user_id |
Close.com sms_activities fields
The sms_activities report of the Close.com connector includes 33 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_activities___type | TEXT | sms_activities._type | sms_activities._type |
| sms_activities__activity_at | DATE | sms_activities.activity_at | sms_activities.activity_at |
| sms_activities__attachments | OBJECT | sms_activities.attachments | sms_activities.attachments |
| sms_activities__contact_id | TEXT | sms_activities.contact_id | sms_activities.contact_id |
| sms_activities__cost | TEXT | sms_activities.cost | sms_activities.cost |
| sms_activities__created_by | TEXT | sms_activities.created_by | sms_activities.created_by |
| sms_activities__created_by_name | TEXT | sms_activities.created_by_name | sms_activities.created_by_name |
| sms_activities__date_created | TEXT | sms_activities.date_created | sms_activities.date_created |
| sms_activities__date_scheduled | TEXT | sms_activities.date_scheduled | sms_activities.date_scheduled |
| sms_activities__date_sent | TEXT | sms_activities.date_sent | sms_activities.date_sent |
| sms_activities__date_updated | DATE | sms_activities.date_updated | sms_activities.date_updated |
| sms_activities__direction | TEXT | sms_activities.direction | sms_activities.direction |
| sms_activities__error_message | TEXT | sms_activities.error_message | sms_activities.error_message |
| sms_activities__id | TEXT | sms_activities.id | sms_activities.id |
| sms_activities__lead_id | TEXT | sms_activities.lead_id | sms_activities.lead_id |
| sms_activities__local_country_iso | TEXT | sms_activities.local_country_iso | sms_activities.local_country_iso |
| sms_activities__local_phone | TEXT | sms_activities.local_phone | sms_activities.local_phone |
| sms_activities__local_phone_formatted | TEXT | sms_activities.local_phone_formatted | sms_activities.local_phone_formatted |
| sms_activities__organization_id | TEXT | sms_activities.organization_id | sms_activities.organization_id |
| sms_activities__remote_country_iso | TEXT | sms_activities.remote_country_iso | sms_activities.remote_country_iso |
| sms_activities__remote_phone | TEXT | sms_activities.remote_phone | sms_activities.remote_phone |
| sms_activities__remote_phone_formatted | TEXT | sms_activities.remote_phone_formatted | sms_activities.remote_phone_formatted |
| sms_activities__sequence_id | TEXT | sms_activities.sequence_id | sms_activities.sequence_id |
| sms_activities__sequence_name | TEXT | sms_activities.sequence_name | sms_activities.sequence_name |
| sms_activities__sequence_subscription_id | TEXT | sms_activities.sequence_subscription_id | sms_activities.sequence_subscription_id |
| sms_activities__source | TEXT | sms_activities.source | sms_activities.source |
| sms_activities__status | TEXT | sms_activities.status | sms_activities.status |
| sms_activities__template_id | TEXT | sms_activities.template_id | sms_activities.template_id |
| sms_activities__text | TEXT | sms_activities.text | sms_activities.text |
| sms_activities__updated_by | TEXT | sms_activities.updated_by | sms_activities.updated_by |
| sms_activities__updated_by_name | TEXT | sms_activities.updated_by_name | sms_activities.updated_by_name |
| sms_activities__user_id | TEXT | sms_activities.user_id | sms_activities.user_id |
| sms_activities__user_name | TEXT | sms_activities.user_name | sms_activities.user_name |
Close.com task_completed_activities fields
The task_completed_activities report of the Close.com connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| task_completed_activities___type | TEXT | task_completed_activities._type | task_completed_activities._type |
| task_completed_activities__activity_at | DATE | task_completed_activities.activity_at | task_completed_activities.activity_at |
| task_completed_activities__created_by | TEXT | task_completed_activities.created_by | task_completed_activities.created_by |
| task_completed_activities__created_by_name | TEXT | task_completed_activities.created_by_name | task_completed_activities.created_by_name |
| task_completed_activities__date_created | TEXT | task_completed_activities.date_created | task_completed_activities.date_created |
| task_completed_activities__date_updated | DATE | task_completed_activities.date_updated | task_completed_activities.date_updated |
| task_completed_activities__id | TEXT | task_completed_activities.id | task_completed_activities.id |
| task_completed_activities__lead_id | TEXT | task_completed_activities.lead_id | task_completed_activities.lead_id |
| task_completed_activities__organization_id | TEXT | task_completed_activities.organization_id | task_completed_activities.organization_id |
| task_completed_activities__task_assigned_to | TEXT | task_completed_activities.task_assigned_to | task_completed_activities.task_assigned_to |
| task_completed_activities__task_assigned_to_name | TEXT | task_completed_activities.task_assigned_to_name | task_completed_activities.task_assigned_to_name |
| task_completed_activities__task_id | TEXT | task_completed_activities.task_id | task_completed_activities.task_id |
| task_completed_activities__task_text | TEXT | task_completed_activities.task_text | task_completed_activities.task_text |
| task_completed_activities__updated_by | TEXT | task_completed_activities.updated_by | task_completed_activities.updated_by |
| task_completed_activities__updated_by_name | TEXT | task_completed_activities.updated_by_name | task_completed_activities.updated_by_name |
| task_completed_activities__user_id | TEXT | task_completed_activities.user_id | task_completed_activities.user_id |
| task_completed_activities__user_name | TEXT | task_completed_activities.user_name | task_completed_activities.user_name |
| task_completed_activities__users | OBJECT | task_completed_activities.users | task_completed_activities.users |
Close.com users fields
The users report of the Close.com connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| users__date_created | TEXT | users.date_created | users.date_created |
| users__date_updated | DATE | users.date_updated | users.date_updated |
| users__email | TEXT | users.email | users.email |
| users__email_verification_token_generated_at | DATE | users.email_verification_token_generated_at | users.email_verification_token_generated_at |
| users__email_verified_at | DATE | users.email_verified_at | users.email_verified_at |
| users__first_name | TEXT | users.first_name | users.first_name |
| users__id | TEXT | users.id | users.id |
| users__image | TEXT | users.image | users.image |
| users__last_name | TEXT | users.last_name | users.last_name |
| users__last_used_timezone | TEXT | users.last_used_timezone | users.last_used_timezone |
| users__organizations | OBJECT | users.organizations | users.organizations |
Close.com voicemail_tasks fields
The voicemail_tasks report of the Close.com connector includes 26 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| voicemail_tasks___type | TEXT | voicemail_tasks._type | voicemail_tasks._type |
| voicemail_tasks__assigned_to | TEXT | voicemail_tasks.assigned_to | voicemail_tasks.assigned_to |
| voicemail_tasks__assigned_to_name | TEXT | voicemail_tasks.assigned_to_name | voicemail_tasks.assigned_to_name |
| voicemail_tasks__contact_id | TEXT | voicemail_tasks.contact_id | voicemail_tasks.contact_id |
| voicemail_tasks__contact_name | TEXT | voicemail_tasks.contact_name | voicemail_tasks.contact_name |
| voicemail_tasks__created_by | TEXT | voicemail_tasks.created_by | voicemail_tasks.created_by |
| voicemail_tasks__created_by_name | TEXT | voicemail_tasks.created_by_name | voicemail_tasks.created_by_name |
| voicemail_tasks__date | TEXT | voicemail_tasks.date | voicemail_tasks.date |
| voicemail_tasks__date_created | TEXT | voicemail_tasks.date_created | voicemail_tasks.date_created |
| voicemail_tasks__date_updated | DATE | voicemail_tasks.date_updated | voicemail_tasks.date_updated |
| voicemail_tasks__id | TEXT | voicemail_tasks.id | voicemail_tasks.id |
| voicemail_tasks__is_complete | BOOLEAN | voicemail_tasks.is_complete | voicemail_tasks.is_complete |
| voicemail_tasks__lead_id | TEXT | voicemail_tasks.lead_id | voicemail_tasks.lead_id |
| voicemail_tasks__lead_name | TEXT | voicemail_tasks.lead_name | voicemail_tasks.lead_name |
| voicemail_tasks__local_phone | TEXT | voicemail_tasks.local_phone | voicemail_tasks.local_phone |
| voicemail_tasks__object_id | TEXT | voicemail_tasks.object_id | voicemail_tasks.object_id |
| voicemail_tasks__object_type | TEXT | voicemail_tasks.object_type | voicemail_tasks.object_type |
| voicemail_tasks__organization_id | TEXT | voicemail_tasks.organization_id | voicemail_tasks.organization_id |
| voicemail_tasks__phone | TEXT | voicemail_tasks.phone | voicemail_tasks.phone |
| voicemail_tasks__phone_formatted | TEXT | voicemail_tasks.phone_formatted | voicemail_tasks.phone_formatted |
| voicemail_tasks__phone_number_description | TEXT | voicemail_tasks.phone_number_description | voicemail_tasks.phone_number_description |
| voicemail_tasks__updated_by | TEXT | voicemail_tasks.updated_by | voicemail_tasks.updated_by |
| voicemail_tasks__updated_by_name | TEXT | voicemail_tasks.updated_by_name | voicemail_tasks.updated_by_name |
| voicemail_tasks__view | TEXT | voicemail_tasks.view | voicemail_tasks.view |
| voicemail_tasks__voicemail_duration | NUMERIC | voicemail_tasks.voicemail_duration | voicemail_tasks.voicemail_duration |
| voicemail_tasks__voicemail_url | TEXT | voicemail_tasks.voicemail_url | voicemail_tasks.voicemail_url |
Close.com zoom_connected_accounts fields
The zoom_connected_accounts report of the Close.com connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| zoom_connected_accounts___type | TEXT | zoom_connected_accounts._type | zoom_connected_accounts._type |
| zoom_connected_accounts__email | TEXT | zoom_connected_accounts.email | zoom_connected_accounts.email |
| zoom_connected_accounts__id | TEXT | zoom_connected_accounts.id | zoom_connected_accounts.id |
| zoom_connected_accounts__identities | OBJECT | zoom_connected_accounts.identities | zoom_connected_accounts.identities |
| zoom_connected_accounts__organization_id | TEXT | zoom_connected_accounts.organization_id | zoom_connected_accounts.organization_id |
| zoom_connected_accounts__user_id | TEXT | zoom_connected_accounts.user_id | zoom_connected_accounts.user_id |
Close.com other fields
The Close.com connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
