# 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: <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.&#x20;

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

<table><thead><tr><th width="375">Field Name</th><th>Target Datatype</th></tr></thead><tbody><tr><td>id</td><td>Numeric</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>First_name</td><td>STRING</td></tr><tr><td>Last_name</td><td>STRING</td></tr><tr><td>Address</td><td>RECORD</td></tr><tr><td>Assignee_id</td><td>NUMERIC</td></tr><tr><td>Details</td><td>STRING</td></tr><tr><td>Email</td><td>RECORD</td></tr><tr><td>Interaction_count</td><td>NUMERIC</td></tr><tr><td>Socials</td><td>RECORD</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>Status_id</td><td>NUMERIC</td></tr><tr><td>Websites</td><td>RECORD</td></tr><tr><td>Custom_fields</td><td>RECORD</td></tr><tr><td>Date_created</td><td>NUMERIC</td></tr><tr><td>Date_Modified</td><td>NUMERIC</td></tr><tr><td>Date_Last_Contacted</td><td>NUMERIC</td></tr></tbody></table>