Senses Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Senses Tables
| Name | Description |
| Actions | Returns a list of Actions |
| ContactCustoms | Returns a list of ContactCustoms |
| Contacts | Returns a list of Contacts |
| ContactsActions | Returns a list of ContactsActions |
| ContactSetting | Returns a list of Users |
| CustomerCustoms | Returns a list of CustomerCustoms |
| Customers | Returns a list of Customers |
| CustomerSetting | Returns a list of Users |
| DealCustoms | Returns a list of DealCustoms |
| Deals | Returns a list of Deals |
| DealSettingDealTypes | Returns a list of Users |
| DealSettingDealTypesActionsPurposes | Returns a list of ActionsPurposes |
| DealSettingDealTypesChannels | Returns a list of Channels |
| DealSettingDealTypesDealCustomItems | Returns a list of DealCustomItems |
| DealSettingDealTypesDealProductDetailTypes | Returns a list of DealProductDetailTypes |
| DealSettingDealTypesEndPhaseReasons | Returns a list of EndPhaseReasons |
| DealSettingDealTypesPhases | Returns a list of Phases |
| DealSettingDealTypesProbabilities | Returns a list of Probabilities |
| DealSettingDealTypesProducts | Returns a list of Products |
| DealsProductDetails | Returns a list of DealsProductDetails |
| Roles | Returns a list of Users |
| Users | Returns a list of Users |