> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/copper-crm/schema-information.md). # Schema Information ## Tables/APIs The following is the list of tables or APIs associated with the Copper CRM connector: * [People](#people) * [Users](#users) * [Companies](#companies) * [Opportunities](#opportunities) * [Activities](#activities) * [Leads](#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: 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: 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: 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: 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: 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: Replication: Full Replication Replication Key: NA **Fields**
Field NameTarget Datatype
idNumeric
nameSTRING
First_nameSTRING
Last_nameSTRING
AddressRECORD
Assignee_idNUMERIC
DetailsSTRING
EmailRECORD
Interaction_countNUMERIC
SocialsRECORD
StatusSTRING
Status_idNUMERIC
WebsitesRECORD
Custom_fieldsRECORD
Date_createdNUMERIC
Date_ModifiedNUMERIC
Date_Last_ContactedNUMERIC
--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/copper-crm/schema-information.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.