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
Account
Activities
ActivityTypes
Companies
CompanyActivities
ConnectFields
ContactTypes
CustomActivityTypes
CustomerSources
CustomFields
LeadActivities
Leads
LeadStatuses
LossReasons
Opportunities
People
PeopleActivities
Pipelines
PipelineStages
Projects
RelatedItems
Tasks
Users
Webhooks
RelatedItems
View all records related to an Entity
Columns
Name
Type
References
Id
Int
Type
String
Entity
String
EntityId
String