Contractors Cloud Connector Reference

30 metrics325 dimensions

Fields

The Contractors Cloud connector exposes 355 fields (30 metrics, 325 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Contractors Cloud Fields

Contractors Cloud Appointments fields

The Appointments report of the Contractors Cloud connector includes 38 fields.

ID	Type	Name	Description
appointment_additional_emails	OBJECT	Appointment Additional Emails	Extra invite recipients beyond the primary attendee.
appointment_address_city	CITY	Appointment Address City	City of the appointment.
appointment_address_latitude	TEXT	Appointment Address Latitude	Latitude of the appointment address.
appointment_address_longitude	TEXT	Appointment Address Longitude	Longitude of the appointment address.
appointment_address_state	TEXT	Appointment Address State	State of the appointment.
appointment_address_street	TEXT	Appointment Address Street	Street address of the appointment.
appointment_address_zip	TEXT	Appointment Address Zip	ZIP code of the appointment.
appointment_appointment_category_id	TEXT	Appointment Category ID	Appointment-category identifier.
appointment_appointment_result_id	TEXT	Appointment Result ID	Appointment-result identifier (outcome).
appointment_appointment_type_id	TEXT	Appointment Type ID	Appointment-type identifier.
appointment_attendees	OBJECT	Appointment Attendees	Detailed attendee records for the appointment.
appointment_colors	OBJECT	Appointment Colors	UI colors associated with the appointment.
appointment_company_appointment_type_id	TEXT	Appointment Company Appointment Type ID	Company-specific appointment-type identifier.
appointment_company_id	TEXT	Appointment Company ID	Company that owns the appointment.
appointment_created_at	TIMESTAMP	Appointment Created At	When the appointment was created.
appointment_created_by	TEXT	Appointment Created By	User who created the appointment.
appointment_customer_invite_email	TEXT	Appointment Customer Invite Email	Email used to invite the customer to the appointment.
appointment_description	TEXT	Appointment Description	Description / notes for the appointment.
appointment_ends_at	TIMESTAMP	Appointment Ends At	Scheduled end time of the appointment.
appointment_first_attendee_id	TEXT	Appointment First Attendee ID	Primary attendee user id.
appointment_fourth_attendee_id	TEXT	Appointment Fourth Attendee ID	Fourth attendee user id.
appointment_google_event_id	TEXT	Appointment Google Event ID	Google Calendar event ID linked to the appointment.
appointment_google_owner_email	TEXT	Appointment Google Owner Email	Google account email that owns the calendar event.
appointment_google_owner_name	TEXT	Appointment Google Owner Name	Google account display name that owns the calendar event.
appointment_id	TEXT	Appointment ID	Unique identifier for the appointment.
appointment_is_all_day	BOOLEAN	Appointment Is All Day	Whether the appointment is all-day.
appointment_is_in_progress	BOOLEAN	Appointment Is In Progress	Whether the appointment is in progress.
appointment_is_in_the_future	BOOLEAN	Appointment Is In The Future	Whether the appointment is in the future.
appointment_is_in_the_past	BOOLEAN	Appointment Is In The Past	Whether the appointment is in the past.
appointment_is_internal	BOOLEAN	Appointment Is Internal	Whether the appointment is internal-only.
appointment_project_id	TEXT	Appointment Project ID	Project the appointment is tied to.
appointment_second_attendee_id	TEXT	Appointment Second Attendee ID	Second attendee user id.
appointment_slot_type	TEXT	Appointment Slot Type	Slot type of the appointment (placeholder/confirmed).
appointment_starts_at	TIMESTAMP	Appointment Starts At	Scheduled start time of the appointment.
appointment_tenant_id	TEXT	Appointment Tenant ID	Tenant the appointment belongs to.
appointment_third_attendee_id	TEXT	Appointment Third Attendee ID	Third attendee user id.
appointment_title	TEXT	Appointment Title	Title of the appointment.
appointment_updated_at	TIMESTAMP	Appointment Updated At	When the appointment was last updated.

Contractors Cloud Companies fields

The Companies report of the Contractors Cloud connector includes 10 fields.

ID	Type	Name	Description
company_address_city	CITY	Company Address City	City of the company.
company_address_latitude	TEXT	Company Address Latitude	Latitude of the company address.
company_address_longitude	TEXT	Company Address Longitude	Longitude of the company address.
company_address_state	TEXT	Company Address State	State of the company.
company_address_street	TEXT	Company Address Street	Street address of the company.
company_address_zip	TEXT	Company Address Zip	ZIP code of the company.
company_id	TEXT	Company ID	Unique identifier for the company (brand).
company_name	TEXT	Company Name	Display name of the company.
company_tenant_id	TEXT	Company Tenant ID	Tenant the company belongs to.
company_timezone	TEXT	Company Timezone	IANA timezone configured for the company.

Contractors Cloud Contacts fields

The Contacts report of the Contractors Cloud connector includes 27 fields.

ID	Type	Name	Description
contact_address_city	CITY	Contact Address City	City of the contact's address.
contact_address_state	TEXT	Contact Address State	State of the contact's address.
contact_address_street	TEXT	Contact Address Street	Street address of the contact.
contact_address_zip	TEXT	Contact Address Zip	ZIP code of the contact's address.
contact_comment	TEXT	Contact Comment	Free-form comment on the contact.
contact_created_at	TIMESTAMP	Contact Created At	When the contact was created.
contact_department	TEXT	Contact Department	Department of the contact.
contact_email	TEXT	Contact Email	Primary email of the contact.
contact_email_alt	TEXT	Contact Email Alt	Alternate email of the contact.
contact_first_name	TEXT	Contact First Name	Given name of the contact.
contact_id	TEXT	Contact ID	Unique identifier for the contact.
contact_import_id	TEXT	Contact Import ID	ID of the import that created the contact.
contact_import_name	TEXT	Contact Import Name	Name of the import that created the contact.
contact_last_name	TEXT	Contact Last Name	Surname of the contact.
contact_merge_status	TEXT	Contact Merge Status	Merge-status code for the contact.
contact_nick_name	TEXT	Contact Nick Name	Nickname of the contact.
contact_owned_by	TEXT	Contact Owned By	User ID that owns the contact.
contact_phone_cell	TEXT	Contact Phone Cell	Mobile phone number of the contact.
contact_phone_fax	TEXT	Contact Phone Fax	Fax number of the contact.
contact_phone_home	TEXT	Contact Phone Home	Home phone number of the contact.
contact_phone_work	TEXT	Contact Phone Work	Work phone number of the contact.
contact_phone_work_ext	TEXT	Contact Phone Work Extension	Work phone extension of the contact.
contact_prefix	TEXT	Contact Prefix	Name prefix code for the contact.
contact_status	BOOLEAN	Contact Active Status	Whether the contact is active.
contact_tenant_id	TEXT	Contact Tenant ID	Tenant the contact belongs to.
contact_title	TEXT	Contact Title	Job title of the contact.
contact_updated_at	TIMESTAMP	Contact Updated At	When the contact was last updated.

Contractors Cloud Customer Accounts fields

The Customer Accounts report of the Contractors Cloud connector includes 55 fields.

Contractors Cloud Customer Accounts fields (customer_account_address_city to customer_account_shipping_address_street)

ID	Type	Name	Description
customer_account_address_city	CITY	Customer Account Address City	City of the customer account's address.
customer_account_address_latitude	TEXT	Customer Account Address Latitude	Latitude of the customer account's address.
customer_account_address_longitude	TEXT	Customer Account Address Longitude	Longitude of the customer account's address.
customer_account_address_state	TEXT	Customer Account Address State	State of the customer account's address.
customer_account_address_street	TEXT	Customer Account Address Street	Street address of the customer account.
customer_account_address_zip	TEXT	Customer Account Address Zip	ZIP code of the customer account's address.
customer_account_created_at	TIMESTAMP	Customer Account Created At	When the customer account was created.
customer_account_created_by	TEXT	Customer Account Created By	User who created the customer account.
customer_account_id	TEXT	Customer Account ID	Unique identifier for the customer account (property).
customer_account_is_portal_enabled	BOOLEAN	Customer Account Is Portal Enabled	Whether the customer portal is enabled.
customer_account_is_taxable	BOOLEAN	Customer Account Is Taxable	Whether the customer account is subject to tax.
customer_account_merge_status	TEXT	Customer Account Merge Status	Merge-status code for the customer account.
customer_account_name	TEXT	Customer Account Name	Display name of the customer account.
customer_account_notes	TEXT	Customer Account Notes	Free-form notes on the customer account.
customer_account_primary_email	TEXT	Customer Account Primary Email	Email address of the primary contact stub.
customer_account_primary_first_name	TEXT	Customer Account Primary First Name	First name of the primary contact stub.
customer_account_primary_last_name	TEXT	Customer Account Primary Last Name	Last name of the primary contact stub.
customer_account_primary_nick_name	TEXT	Customer Account Primary Nick Name	Nickname of the primary contact stub.
customer_account_primary_phone_cell	TEXT	Customer Account Primary Phone Cell	Mobile phone of the primary contact stub.
customer_account_primary_phone_fax	TEXT	Customer Account Primary Phone Fax	Fax number of the primary contact stub.
customer_account_primary_phone_home	TEXT	Customer Account Primary Phone Home	Home phone of the primary contact stub.
customer_account_primary_phone_work	TEXT	Customer Account Primary Phone Work	Work phone of the primary contact stub.
customer_account_primary_phone_work_ext	TEXT	Customer Account Primary Phone Work Extension	Work phone extension of the primary contact stub.
customer_account_primary_prefix	TEXT	Customer Account Primary Prefix	Name prefix of the primary contact stub.
customer_account_primary_title_id	TEXT	Customer Account Primary Title ID	Title ID of the primary contact stub.
customer_account_rep_id	TEXT	Customer Account Rep ID	Sales rep assigned to the customer account.
customer_account_secondary_email	TEXT	Customer Account Secondary Email	Email address of the secondary contact stub.
customer_account_secondary_first_name	TEXT	Customer Account Secondary First Name	First name of the secondary contact stub.
customer_account_secondary_last_name	TEXT	Customer Account Secondary Last Name	Last name of the secondary contact stub.
customer_account_secondary_nick_name	TEXT	Customer Account Secondary Nick Name	Nickname of the secondary contact stub.
customer_account_secondary_phone_cell	TEXT	Customer Account Secondary Phone Cell	Mobile phone of the secondary contact stub.
customer_account_secondary_phone_fax	TEXT	Customer Account Secondary Phone Fax	Fax number of the secondary contact stub.
customer_account_secondary_phone_home	TEXT	Customer Account Secondary Phone Home	Home phone of the secondary contact stub.
customer_account_secondary_phone_work	TEXT	Customer Account Secondary Phone Work	Work phone of the secondary contact stub.
customer_account_secondary_phone_work_ext	TEXT	Customer Account Secondary Phone Work Extension	Work phone extension of the secondary contact stub.
customer_account_secondary_prefix	TEXT	Customer Account Secondary Prefix	Name prefix of the secondary contact stub.
customer_account_secondary_title_id	TEXT	Customer Account Secondary Title ID	Title ID of the secondary contact stub.
customer_account_shipping_address_city	CITY	Customer Account Shipping Address City	Shipping city of the customer account.
customer_account_shipping_address_state	TEXT	Customer Account Shipping Address State	Shipping state of the customer account.
customer_account_shipping_address_street	TEXT	Customer Account Shipping Address Street	Shipping street address of the customer account.

Contractors Cloud Customer Accounts fields (customer_account_shipping_address_zip to customer_account_updated_at)

ID	Type	Name	Description
customer_account_shipping_address_zip	TEXT	Customer Account Shipping Address Zip	Shipping ZIP code of the customer account.
customer_account_tenant_id	TEXT	Customer Account Tenant ID	Tenant the customer account belongs to.
customer_account_tertiary_email	TEXT	Customer Account Tertiary Email	Email address of the tertiary contact stub.
customer_account_tertiary_first_name	TEXT	Customer Account Tertiary First Name	First name of the tertiary contact stub.
customer_account_tertiary_last_name	TEXT	Customer Account Tertiary Last Name	Last name of the tertiary contact stub.
customer_account_tertiary_nick_name	TEXT	Customer Account Tertiary Nick Name	Nickname of the tertiary contact stub.
customer_account_tertiary_phone_cell	TEXT	Customer Account Tertiary Phone Cell	Mobile phone of the tertiary contact stub.
customer_account_tertiary_phone_fax	TEXT	Customer Account Tertiary Phone Fax	Fax number of the tertiary contact stub.
customer_account_tertiary_phone_home	TEXT	Customer Account Tertiary Phone Home	Home phone of the tertiary contact stub.
customer_account_tertiary_phone_work	TEXT	Customer Account Tertiary Phone Work	Work phone of the tertiary contact stub.
customer_account_tertiary_phone_work_ext	TEXT	Customer Account Tertiary Phone Work Extension	Work phone extension of the tertiary contact stub.
customer_account_tertiary_prefix	TEXT	Customer Account Tertiary Prefix	Name prefix of the tertiary contact stub.
customer_account_tertiary_title_id	TEXT	Customer Account Tertiary Title ID	Title ID of the tertiary contact stub.
customer_account_type	TEXT	Customer Account Type	Customer-account type code (Person/Business).
customer_account_updated_at	TIMESTAMP	Customer Account Updated At	When the customer account was last updated.

Contractors Cloud Events fields

The Events report of the Contractors Cloud connector includes 19 fields.

ID	Type	Name	Description
event_address_area	TEXT	Event Address Area	Area name targeted by the event.
event_address_state	TEXT	Event Address State	State targeted by the event.
event_address_zip	TEXT	Event Address Zip	ZIP code targeted by the event.
event_billing_city	CITY	Event Billing City	Billing city configured on the event.
event_billing_fax	TEXT	Event Billing Fax	Billing fax number configured on the event.
event_billing_name	TEXT	Event Billing Name	Billing name configured on the event.
event_billing_phone	TEXT	Event Billing Phone	Billing phone number configured on the event.
event_billing_state	TEXT	Event Billing State	Billing state configured on the event.
event_billing_street	TEXT	Event Billing Street	Billing street address configured on the event.
event_billing_url	TEXT	Event Billing URL	Billing URL configured on the event.
event_billing_zip	TEXT	Event Billing Zip	Billing ZIP code configured on the event.
event_comment	TEXT	Event Comment	Free-form comment on the event.
event_company_id	TEXT	Event Company ID	Company that owns the event.
event_ends_at	DATE	Event Ends At	End date of the event.
event_id	TEXT	Event ID	Unique identifier for the event.
event_is_active	BOOLEAN	Event Is Active	Whether the event is active.
event_name	TEXT	Event Name	Display name of the event.
event_starts_at	DATE	Event Starts At	Start date of the event.
event_tenant_id	TEXT	Event Tenant ID	Tenant the event belongs to.

Contractors Cloud General fields

The General report of the Contractors Cloud connector includes 3 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The Windsor account ID for the connection.
account_name	TEXT	Account Name	The Windsor account name for the connection.
date	DATE	Date	Snapshot date for dimensional records (defaults to date_to) or updated_at for date-filtered tables.

Contractors Cloud Lead Connections fields

The Lead Connections report of the Contractors Cloud connector includes 27 fields.

ID	Type	Name	Description
lead_connection_company_id	TEXT	Lead Connection Company ID	Company that owns the lead connection.
lead_connection_created_at	TIMESTAMP	Lead Connection Created At	When the lead connection was created.
lead_connection_data_type	TEXT	Lead Connection Data Type	Payload type accepted by the connection (json/excel/text).
lead_connection_description	TEXT	Lead Connection Description	Free-form description of the lead connection.
lead_connection_event_id	TEXT	Lead Connection Event ID	Event the lead connection is tied to.
lead_connection_id	TEXT	Lead Connection ID	Unique identifier for the lead connection (UUID).
lead_connection_is_active	BOOLEAN	Lead Connection Is Active	Whether the lead connection is active.
lead_connection_last_lead_received_at	TIMESTAMP	Lead Connection Last Lead Received At	When the lead connection most recently received a lead.
lead_connection_lead_source_code	TEXT	Lead Connection Lead Source Code	Code of the embedded lead source.
lead_connection_lead_source_company_id	TEXT	Lead Connection Lead Source Company ID	Company of the embedded lead source.
lead_connection_lead_source_cost	NUMERIC	Lead Connection Lead Source Cost	Acquisition cost configured on the lead source.
lead_connection_lead_source_description	TEXT	Lead Connection Lead Source Description	Description of the embedded lead source.
lead_connection_lead_source_ends_at	DATE	Lead Connection Lead Source Ends At	End date of the embedded lead source.
lead_connection_lead_source_id	TEXT	Lead Connection Lead Source ID	Lead source the lead connection feeds.
lead_connection_lead_source_is_active	BOOLEAN	Lead Connection Lead Source Is Active	Whether the embedded lead source is active.
lead_connection_lead_source_lead_category_id	TEXT	Lead Connection Lead Source Category ID	Lead category of the embedded lead source.
lead_connection_lead_source_name	TEXT	Lead Connection Lead Source Name	Display name of the embedded lead source.
lead_connection_lead_source_starts_at	DATE	Lead Connection Lead Source Starts At	Start date of the embedded lead source.
lead_connection_lead_source_tenant_id	TEXT	Lead Connection Lead Source Tenant ID	Tenant of the embedded lead source (via include=lead_source).
lead_connection_lead_source_total_used	NUMERIC	Lead Connection Lead Source Total Used	Total leads attributed to the lead source.
lead_connection_name	TEXT	Lead Connection Name	Display name of the lead connection.
lead_connection_rep_primary_id	TEXT	Lead Connection Primary Rep ID	Primary sales rep configured on the lead connection.
lead_connection_site_type_id	TEXT	Lead Connection Site Type ID	Site type configured on the lead connection.
lead_connection_status_id	TEXT	Lead Connection Status ID	Status configured on the lead connection.
lead_connection_tenant_id	TEXT	Lead Connection Tenant ID	Tenant the lead connection belongs to.
lead_connection_updated_at	TIMESTAMP	Lead Connection Updated At	When the lead connection was last updated.
lead_connection_workflow_id	TEXT	Lead Connection Workflow ID	Workflow the lead connection routes leads into.

Contractors Cloud Leads fields

The Leads report of the Contractors Cloud connector includes 16 fields.

ID	Type	Name	Description
lead_created_at	TIMESTAMP	Lead Created At	When the lead was created.
lead_created_by	TEXT	Lead Created By	User who created the lead.
lead_data	OBJECT	Lead Data	Raw submission data keyed by field-map labels.
lead_derived_data	OBJECT	Lead Derived Data	Data derived from the raw submission for conversion.
lead_id	TEXT	Lead ID	Unique identifier for the inbound lead (UUID).
lead_last_process_ended_at	TIMESTAMP	Lead Last Process Ended At	When the last conversion attempt for the lead ended.
lead_last_process_started_at	TIMESTAMP	Lead Last Process Started At	When the last conversion attempt for the lead started.
lead_lead_connection_id	TEXT	Lead Lead Connection ID	Lead connection that produced the lead.
lead_project_id	TEXT	Lead Project ID	Project the lead was converted into, if any.
lead_received_at	TIMESTAMP	Lead Received At	When the lead was submitted.
lead_status	TEXT	Lead Status	Current pipeline status: queued, processing, converting, needs-review, ready, successful, or error.
lead_status_message	TEXT	Lead Status Message	Human-readable status message for the lead.
lead_tenant_id	TEXT	Lead Tenant ID	Tenant the lead belongs to.
lead_transaction_id	TEXT	Lead Transaction ID	Transaction ID assigned when the lead was submitted (UUID).
lead_updated_at	TIMESTAMP	Lead Updated At	When the lead was last updated.
lead_validation_errors	OBJECT	Lead Validation Errors	Errors preventing the lead from being converted.

Contractors Cloud Projects fields

The Projects report of the Contractors Cloud connector includes 74 fields.

Contractors Cloud Projects fields (project_account_id to project_financials_revenue_approved_amount)

ID	Type	Name	Description
project_account_id	TEXT	Project Customer Account ID	Customer account the project belongs to.
project_account_name	TEXT	Project Customer Account Name	Customer-account name copied onto the project.
project_address_city	CITY	Project Address City	City of the project address.
project_address_description	TEXT	Project Address Description	Free-form description of the project location.
project_address_latitude	TEXT	Project Address Latitude	Latitude of the project address.
project_address_longitude	TEXT	Project Address Longitude	Longitude of the project address.
project_address_state	TEXT	Project Address State	State of the project address.
project_address_street	TEXT	Project Address Street	Street address of the project.
project_address_zip	TEXT	Project Address Zip	ZIP code of the project address.
project_amount_estimated	NUMERIC	Project Amount Estimated	Estimated job amount for the project.
project_appointment_recommended_at	TIMESTAMP	Project Appointment Recommended At	When an appointment was first recommended for the project.
project_callback_at	TIMESTAMP	Project Callback At	Next callback timestamp on the project.
project_cancellation_id	TEXT	Project Cancellation ID	Cancellation reason identifier.
project_company_id	TEXT	Project Company ID	Company that owns the project.
project_companycam_id	TEXT	Project CompanyCam ID	CompanyCam external project identifier.
project_completed_at	TIMESTAMP	Project Completed At	When the project was completed.
project_created_at	TIMESTAMP	Project Created At	When the project was created.
project_current_project_milestone_id	TEXT	Project Current Milestone ID	Current milestone the project is at.
project_deleted_at	TIMESTAMP	Project Deleted At	When the project was soft-deleted.
project_estimated_total_amount	NUMERIC	Project Estimated Total Amount	Estimated total amount on the project.
project_event_id	TEXT	Project Event ID	Event the project is tied to.
project_expenses_approved_amount	NUMERIC	Project Expenses Approved Amount	Expenses approved on the project.
project_expenses_denied_amount	NUMERIC	Project Expenses Denied Amount	Expenses denied on the project.
project_expenses_paid_amount	NUMERIC	Project Expenses Paid Amount	Expenses paid on the project.
project_expenses_pending_amount	NUMERIC	Project Expenses Pending Amount	Expenses pending approval.
project_expenses_total_amount	NUMERIC	Project Expenses Total Amount	Total expenses on the project.
project_financials_all_paid_amount	NUMERIC	Project Financials All Paid Amount	All-paid financial amount on the project.
project_financials_approved_amount	NUMERIC	Project Financials Approved Amount	Approved financial amount on the project.
project_financials_balance_amount	NUMERIC	Project Financials Balance Amount	Outstanding balance on the project.
project_financials_billable_amount	NUMERIC	Project Financials Billable Amount	Billable financial amount on the project.
project_financials_credit_memo_amount	NUMERIC	Project Financials Credit Memo Amount	Credit-memo amount on the project.
project_financials_deductible_paid_amount	NUMERIC	Project Financials Deductible Paid Amount	Deductible-paid financial amount on the project.
project_financials_down_payment_amount	NUMERIC	Project Financials Down Payment Amount	Down-payment financial amount on the project.
project_financials_final_paid_amount	NUMERIC	Project Financials Final Paid Amount	Final paid financial amount on the project.
project_financials_pending_amount	NUMERIC	Project Financials Pending Amount	Pending financial amount on the project.
project_financials_progress_payment_amount	NUMERIC	Project Financials Progress Payment Amount	Progress-payment financial amount on the project.
project_financials_received_amount	NUMERIC	Project Financials Received Amount	Received financial amount on the project.
project_financials_refund_amount	NUMERIC	Project Financials Refund Amount	Refund amount on the project.
project_financials_revenue_amount	NUMERIC	Project Financials Revenue Amount	Revenue amount recognized on the project.
project_financials_revenue_approved_amount	NUMERIC	Project Financials Revenue Approved Amount	Approved revenue amount on the project.

Contractors Cloud Projects fields (project_financials_sold_amount to project_workflow_id)

ID	Type	Name	Description
project_financials_sold_amount	NUMERIC	Project Financials Sold Amount	Sold financial amount on the project.
project_financials_total_amount	NUMERIC	Project Financials Total Amount	Total financial amount on the project.
project_financials_total_paid_amount	NUMERIC	Project Financials Total Paid Amount	Total paid amount on the project.
project_first_appointment_at	TIMESTAMP	Project First Appointment At	When the project's first appointment is scheduled.
project_first_contract_approved_at	TIMESTAMP	Project First Contract Approved At	When the project's first contract was approved.
project_first_contract_at	TIMESTAMP	Project First Contract At	When the project's first contract was created.
project_group_id	TEXT	Project Group ID	Project-group identifier.
project_hash	TEXT	Project Hash	Project hash used in public links.
project_id	TEXT	Project ID	Unique identifier for the project.
project_is_in_collections	BOOLEAN	Project Is In Collections	Whether the project is in collections.
project_is_in_collections_at	TIMESTAMP	Project Is In Collections At	When the project entered collections.
project_last_note_created_at	TIMESTAMP	Project Last Note Created At	When the most recent note on the project was created.
project_lead_id	TEXT	Project Lead ID	Inbound lead the project was converted from.
project_mortgage_company_id	TEXT	Project Mortgage Company ID	Mortgage-company identifier on the project.
project_mortgage_loan_number	TEXT	Project Mortgage Loan Number	Mortgage loan number on file for the project.
project_name	TEXT	Project Display Name	Display name of the project.
project_needs_appointment	BOOLEAN	Project Needs Appointment	Whether the project still needs an appointment.
project_number	TEXT	Project Number	Human-readable project number.
project_original_milestone_id	TEXT	Project Original Milestone ID	Original milestone the project entered the workflow at.
project_overhead_amount	NUMERIC	Project Overhead Amount	Overhead amount on the project.
project_payouts_amount	NUMERIC	Project Payouts Amount	Total payouts on the project.
project_percent_completed	NUMERIC	Project Percent Completed	Completion percentage of the project.
project_percent_sale_close	NUMERIC	Project Percent Sale Close	Sale-close percentage of the project.
project_referred_at	TIMESTAMP	Project Referred At	When the project was referred.
project_referred_by	TEXT	Project Referred By	Referrer for the project.
project_rep_primary_id	TEXT	Project Primary Rep ID	Primary sales rep on the project.
project_rep_primary_name	TEXT	Project Primary Rep Name	Display name of the primary rep on the project.
project_sale_closed_at	TIMESTAMP	Project Sale Closed At	When the sale was closed on the project.
project_site_type_id	TEXT	Project Site Type ID	Site type of the project.
project_status_id	TEXT	Project Status ID	Workflow-status identifier for the project.
project_storm_id	TEXT	Project Storm ID	Storm the project is tied to, if any.
project_tenant_id	TEXT	Project Tenant ID	Tenant the project belongs to.
project_updated_at	TIMESTAMP	Project Updated At	When the project was last updated.
project_workflow_id	TEXT	Project Workflow ID	Workflow the project is using.

Contractors Cloud Storms fields

The Storms report of the Contractors Cloud connector includes 4 fields.

ID	Type	Name	Description
storm_id	TEXT	Storm ID	Unique identifier for the storm.
storm_is_active	BOOLEAN	Storm Is Active	Whether the storm is active.
storm_name	TEXT	Storm Name	Display name of the storm.
storm_tenant_id	TEXT	Storm Tenant ID	Tenant the storm belongs to.

Contractors Cloud Tasks fields

The Tasks report of the Contractors Cloud connector includes 23 fields.

ID	Type	Name	Description
task_assignee_id	TEXT	Task Assignee ID	ID of the assignee.
task_assignee_name	TEXT	Task Assignee Name	Display name of the assignee.
task_assignee_type	TEXT	Task Assignee Type	Type code for the assignee (e.g. 'u' for user).
task_comment	TEXT	Task Comment	Free-form comment on the task.
task_completed_at	TIMESTAMP	Task Completed At	When the task was completed.
task_completed_by	TEXT	Task Completed By	User who completed the task.
task_created_at	TIMESTAMP	Task Created At	When the task was created.
task_created_by	TEXT	Task Created By	User who created the task.
task_created_by_name	TEXT	Task Created By Name	Display name of the task creator.
task_due_at	TIMESTAMP	Task Due At	When the task is due.
task_id	TEXT	Task ID	Unique identifier for the task.
task_is_complete	BOOLEAN	Task Is Complete	Whether the task has been completed.
task_is_high_priority	BOOLEAN	Task Is High Priority	Whether the task is high priority.
task_notifies_on_complete	BOOLEAN	Task Notifies On Complete	Whether to notify the assignee when the task is completed.
task_notifies_on_create	BOOLEAN	Task Notifies On Create	Whether to notify the assignee when the task is created.
task_project_id	TEXT	Task Project ID	Project the task is attached to.
task_project_milestone_id	TEXT	Task Project Milestone ID	Project-milestone the task is associated with.
task_project_milestone_task_id	TEXT	Task Project Milestone Task ID	Project-milestone-task template the task derives from.
task_related_to_id	TEXT	Task Related Entity ID	ID of the related-to entity.
task_related_to_type	TEXT	Task Related To Type	Type code for the related-to entity.
task_subject	TEXT	Task Subject	Subject line of the task.
task_tenant_id	TEXT	Task Tenant ID	Tenant the task belongs to.
task_updated_at	TIMESTAMP	Task Updated At	When the task was last updated.

Contractors Cloud Teams fields

The Teams report of the Contractors Cloud connector includes 6 fields.

ID	Type	Name	Description
team_comment	TEXT	Team Comment	Free-form comment on the team.
team_id	TEXT	Team ID	Unique identifier for the team.
team_is_active	BOOLEAN	Team Is Active	Whether the team is active.
team_leader_id	TEXT	Team Leader ID	User ID of the team leader.
team_name	TEXT	Team Name	Display name of the team.
team_tenant_id	TEXT	Team Tenant ID	Tenant the team belongs to.

Contractors Cloud Users fields

The Users report of the Contractors Cloud connector includes 29 fields.

ID	Type	Name	Description
user_address_city	CITY	User Address City	City of the user's address.
user_address_state	TEXT	User Address State	State of the user's address.
user_address_street	TEXT	User Address Street	Street address of the user.
user_address_zip	TEXT	User Address Zip	ZIP code of the user's address.
user_auto_insured_at	TIMESTAMP	User Auto Insured At	Timestamp when the user's auto insurance was last verified.
user_avatar_thumbnail_url	IMAGE_URL	User Avatar Thumbnail URL	URL of the user's avatar thumbnail.
user_color	TEXT	User Color	Hex color code shown in the UI for the user.
user_default_company_id	TEXT	User Default Company ID	Default company assigned to the user.
user_description	TEXT	User Description	Free-form description of the user.
user_email	TEXT	User Email	Contact email address for the user.
user_employment_type	TEXT	User Employment Type	Employment-type code for the user.
user_first_name	TEXT	User First Name	Given name of the user.
user_id	TEXT	User ID	Unique identifier for the user.
user_initials	TEXT	User Initials	Initials shown in the UI for the user.
user_is_active	BOOLEAN	User Is Active	Whether the user account is active.
user_last_name	TEXT	User Last Name	Surname of the user.
user_phone_cell	TEXT	User Phone Cell	Mobile phone number of the user.
user_phone_direct	TEXT	User Phone Direct	Direct office phone number of the user.
user_phone_direct_ext	TEXT	User Phone Direct Extension	Extension for the user's direct phone line.
user_phone_home	TEXT	User Phone Home	Home phone number of the user.
user_started_at	DATE	User Started At	Employment start date for the user.
user_tax_id	TEXT	User Tax ID	Tax identifier on file for the user.
user_tenant_id	TEXT	User Tenant ID	Tenant the user belongs to.
user_terminated_at	DATE	User Terminated At	Employment end date for the user.
user_theme	TEXT	User Theme	UI theme preference for the user.
user_timezone	TEXT	User Timezone	IANA timezone configured for the user.
user_title	TEXT	User Title	Job title of the user.
user_user_level_id	TEXT	User Level ID	Permission/role level identifier for the user.
user_username	TEXT	User Username	Username used for sign-in.

Contractors Cloud Workflows fields

The Workflows report of the Contractors Cloud connector includes 6 fields.

ID	Type	Name	Description
workflow_comment	TEXT	Workflow Comment	Free-form comment on the workflow.
workflow_company_id	TEXT	Workflow Company ID	Company that owns the workflow.
workflow_id	TEXT	Workflow ID	Unique identifier for the workflow.
workflow_is_active	BOOLEAN	Workflow Is Active	Whether the workflow is active.
workflow_name	TEXT	Workflow Name	Display name of the workflow.
workflow_tenant_id	TEXT	Workflow Tenant ID	Tenant the workflow belongs to.

Contractors Cloud other fields

The Contractors Cloud 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
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

API Connectors