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