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
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
id
NUMERIC
Name
STRING
First_name
STRING
Last_name
STRING
Address
RECORD
Assignee_id
NUMERIC
Contact_type_id
NUMERIC
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
Id
NUMERIC
Name
STRING
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
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
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
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
id
Numeric
name
STRING
First_name
STRING
Last_name
STRING
Address
RECORD
Assignee_id
NUMERIC
Details
STRING
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
Last updated