Leads
Lead records from Copper CRM with filtering
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Primary identifier for lead record | |
| Name | String | False |
Lead name | |
| FirstName | String | False |
First name if provided | |
| MiddleName | String | False |
Middle name if provided | |
| LastName | String | False |
Last name if provided | |
| Prefix | String | False |
Name prefix | |
| Suffix | String | False |
Name suffix | |
| AssigneeId | Integer | False |
User ID assigned to this lead | |
| CompanyName | String | False |
Associated company name | |
| CustomerSourceId | Integer | False |
Source of the lead | |
| DateCreated | Datetime | True |
Unix timestamp of creation | |
| DateModified | Datetime | True |
Unix timestamp of last modification | |
| DateLastContacted | Datetime | True |
Unix timestamp of last contact | |
| Details | String | False |
Additional lead details | |
| Title | String | False |
Job title | |
| Status | String | True |
Lead status name (New, Open, Qualified, etc.) | |
| StatusId | Integer | False |
Lead status identifier | |
| Address | String | False |
Complete address object with street, city, state, postal_code, country fields | |
| Street | String | True |
Street address | |
| City | String | True |
City from address | |
| State | String | True |
State from address | |
| PostalCode | String | True |
Postal code from address | |
| Country | String | True |
Country from address | |
| String | False |
Primary email address | ||
| PhoneNumbers | String | False |
Array of phone number objects with number and category fields | |
| Websites | String | False |
Array of website objects with url and category fields | |
| SocialLinks | String | False |
Array of social media links with url and category fields | |
| CustomFields | String | False |
Array of custom field objects with custom_field_definition_id and value fields | |
| Tags | String | False |
Array of tag strings | |
| InteractionCount | Integer | True |
Number of interactions recorded | |
| MonetaryValue | Integer | False |
Associated monetary value |