API Data Provider - Online Help
Copper Profile
Connecting to Copper
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Activities
Companies
ConnectFields
CustomActivityTypes
CustomFieldDefinitions
FileAttachments
Leads
Opportunities
People
Pipelines
Projects
RelatedItems
Tasks
Account
ActivityTypes
CompanyActivities
ContactTypes
CustomerSources
FieldLayouts
FileAttachmentSignedS3URL
LeadActivities
LeadStatuses
LossReasons
PeopleActivities
PipelineStages
Tags
Users
Users
User records from Copper CRM with filtering
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
Email
String
Groups
String