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 |
| AccountContacts | Usage information for the operation AccountContacts.rsd. |
| AccountCustomFieldData | Create, modify, delete and query the available deal custom field data in ActiveCampaign. |
| Accounts | View many or all contacts by including their ID's or various filters. |
| ContactCustomFieldData | Create, modify, delete and query the available contact custom field data in ActiveCampaign. |
| Contacts | View many or all contacts by including their ID's or various filters. |
| DealCustomFieldData | Create, modify, delete and query the available deal custom field data in ActiveCampaign. |
| DealGroups | Lists all existing accounts. |
| Deals | Usage information for the operation Deals.rsd. |
| DealStages | Usage information for the operation DealStages.rsd. |
| Tasks | Lists all existing accounts. |