API Data Provider - Online Help
Mazrica Profile
Connecting to Mazrica
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
ContactCustoms
Contacts
ContactsActions
ContactSetting
CustomerCustoms
Customers
CustomerSetting
DealCustoms
Deals
DealSettingDealTypes
DealSettingDealTypesActionsPurposes
DealSettingDealTypesChannels
DealSettingDealTypesDealCustomItems
DealSettingDealTypesDealProductDetailTypes
DealSettingDealTypesEndPhaseReasons
DealSettingDealTypesPhases
DealSettingDealTypesProbabilities
DealSettingDealTypesProducts
DealsProductDetails
Roles
Users
DealSettingDealTypesChannels
Returns a list of Channels
Columns
Name
Type
References
DealTypeId [KEY]
Integer
DealSettingDealTypes
.Id
Id [KEY]
Integer
Name
String