Close.com Connector Reference

24 metrics813 dimensions

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
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 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
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
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
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
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 TIMESTAMP 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 TIMESTAMP 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