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.

Need help with something?

Talk to data expert

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