Schema Information

This topic provides a structured reference to assist you in working with Daton's Copper CRM connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Copper CRM connector:

• People

• Users

• Companies

• Opportunities

• Activities

• Leads

People

A Person is an individual with whom you communicate. The People API allows you to create, view, delete, and update your People. You can retrieve an individual Person, list all People, or use search filters to view subsets of your People.

Source API Documentation: https://developer.copper.com/people/overview.html

Replication: Key-Based Replication

Replication Key: Created_Date

Fields

Field Name	Target Datatype
id	NUMERIC
Name	STRING
First_name	STRING
Last_name	STRING
Address	RECORD
Assignee_id	NUMERIC
Contact_type_id	NUMERIC
Email	RECORD
phone_numbers	RECORD
Socials	RECORD
Websites	RECORD
Custom_fields	RECORD
Date_created	NUMERIC
Date_Modified	NUMERIC
Date_Last_Connected	NUMERIC
Interaction_count	NUMERIC
Company_id	NUMERIC
Company_name	STRING
Middle_name	STRING

Users

The users API allows you to list the users with their IDs, name, and email.

Source API Documentation: https://developer.copper.com/account-and-users/overview.html

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Target Datatype
Id	NUMERIC
Name	STRING
Email	STRING

Companies

A Company is an organization with which you communicate. The Companies API allows you to create, view, delete, and update your Companies. You can retrieve individual Companies, list all Companies, or use search filters to view subsets of your Companies

Source API Documentation: https://developer.copper.com/companies/overview.html

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Target Datatype
Id	Numeric
Name	STRING
Assignee_id	NUMERIC
Contact_type_id	NUMERIC
Details	STRING
Email_Domain	STRING
Socials	RECORD
Websites	RECORD
Custom_Fields	RECORD
Interaction_Count	NUMERIC
Date_Created	NUMERIC
Date_Modified	NUMERIC

Opportunities

An Opportunity is a potential business deal. The Opportunities API allows you to create, view, delete, and update your Opportunities.

Source API Documentation: https://developer.copper.com/opportunities/overview.html

Replication: Key-Based Replication

Replication Key: Modified_Date

Fields

Field Name	Target Datatype
Id	NUMERIC
Name	STRING
Assignee_id	NUMERIC
Close_Date	STRING
Pipeline_id	NUMERIC
Pipeline_stage_id	NUMERIC
Primary_Contact_id	NUMERIC
Priority	STRING
Status	STRING
Interaction_count	NUMERIC
Monetary_unit	STRING
Monetary_Value	NUMERIC
Win_Probability	NUMERIC
Date_Stage_Changed	NUMERIC
Date_Last_Contacted	NUMERIC
Date_Created	NUMERIC
Date_Modified	NUMERIC
Custom_Fields	RECORD
Company_id	NUMERIC
Company_Name	STRING
Loss_Reason_id	NUMERIC

Activities

Copper keeps a record of activities for People, Leads, Opportunities, and Companies. The Activities API allows you to view, create, edit, and delete activities

Source API Documentation: https://developer.copper.com/activities/overview.html

Replication: Key-Based Replication

Replication Key: Activity_Date

Fields

Field Name	Target Datatype
Id	NUMERIC
Parent	RECORD
Type	RECORD
user_id	NUMERIC
Details	STRING
Activity_Date	NUMERIC
Old_value	RECORD
New_value	RECORD
Date_Created	NUMERIC
Date_Modified	NUMERIC
Old_value_st	STRING
New_value_st	STRING

Leads

A Lead is an individual or a company that's interested in your products or services.

Source API Documentation: https://developer.copper.com/leads/overview.html

Replication: Full Replication

Replication Key: NA

Fields

Field Name	Target Datatype
id	Numeric
name	STRING
First_name	STRING
Last_name	STRING
Address	RECORD
Assignee_id	NUMERIC
Details	STRING
Email	RECORD
Interaction_count	NUMERIC
Socials	RECORD
Status	STRING
Status_id	NUMERIC
Websites	RECORD
Custom_fields	RECORD
Date_created	NUMERIC
Date_Modified	NUMERIC
Date_Last_Contacted	NUMERIC