API Data Provider - Online Help
OnePageCrm Profile
Connecting to OnePageCrm
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
Actions
ActionStream
CallResults
Calls
Companies
CompanyActions
CompanyCalls
CompanyEmailMessages
CompanyFields
CompanyLinkedContacts
CompanyDeals
CompanyNotes
ContactActions
ContactCalls
ContactDeals
ContactEmailMessages
ContactNotes
ContactRelationships
Contacts
CustomFields
DealFields
Deals
EmailMessages
Filters
LeadSources
Notes
Notifications
Pipelines
PredefinedActions
PredefinedItemGroups
PredefinedItems
RelationshipTypes
Statuses
TeamStream
Users
Webhooks
PredefinedActions
Retrieve the list of predifined actions.
Columns
Name
Type
References
Id [KEY]
String
Text
String
Days
Integer