Tables
The adapter models the data in into a list of tables that can be queried using standard SQL statements.
Generally, querying 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.
Adapter Tables
| Name | Description |
| Activities | Get all Activities assigned to a particular User. |
| ActivityTypes | Get all ActivityTypes. |
| CallLogs | Returns all call logs assigned to a particular user. |
| DealFields | Returns data about all deal fields. |
| Deals | Get all deals |
| DealsFollowers | Get details of deals followers. |
| DealsParticipants | Get details of deals participants. |
| DealsProducts | Get details of deals products. |
| Files | Returns data about all files. |
| Filters | Returns data about all filters. |
| Goals | Goals help your team meet your sales targets. |
| LeadLabels | Returns details of all Lead Labels. |
| Leads | Returns lead data. |
| Notes | Returns all notes. |
| OrganizationFields | Returns data about all organization fields. |
| OrganizationRelationships | Gets all of the relationships. |
| Organizations | Get details of organizations |
| OrganizationsFollowers | Get details of organizations followers. |
| OrganizationsInternal | Get details of organizations. |
| PersonFields | Returns data about all person fields. |
| PersonFollowers | Get details of persons followers. |
| Persons | Get all details of persons |
| PersonsInternal | Get all details of persons. |
| Pipelines | Get all Pipelines. |
| ProductFields | Returns data about all product fields. |
| Products | Get details of Products |
| ProductsFollowers | Get details of products followers. |
| Roles | Returns all the role. |
| RolesAssignments | List assignments for a role. |
| RolesSetting | Returns all the roles settings. |
| Stages | Returns data about all stages. |
| Subscriptions | Returns details of an installment or a recurring Subscription |
| Teams | Returns data about teams within the company |
| TeamsUsers | Usage information for the operation TeamsUsers.rsd. |
| Users | Returns data about all users within the company |