Tables
The connector models the data in Act! CRM as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Act! CRM Tables
| Name | Description |
| Activities | [DEPRECATED] Create, update, delete and query the Activities in your Act! CRM database. |
| CompaniesInternal | Create, update, delete and query the Companies created in your Act! CRM database. |
| CompanyContactsInternal | Query, delete the Contacts belonging to a Company. |
| ContactNotes | Query and delete the Notes for a given Act! CRM Contact. |
| ContactsInternal | Create, update, delete and query the Contacts in your Act! CRM database. |
| GroupContactsInternal | Query and delete the Contacts belonging to a Group. |
| GroupsInternal | Create, update, delete and query the Groups participating in your Act! CRM database. |
| Histories | Get, Create, Update or Delete all history items. |
| Notes | Create, update, delete and query the Notes in your Act! CRM database. |
| OpportunitiesInternal | Create, update, delete and query the Opportunities in your Act! CRM database. |
| OpportunityCompaniesInternal | Query and delete the Companies related to an Act! CRM opportunity. |
| OpportunityContacts | Query and delete the Contacts associated with an Opportunity. |
| OpportunityGroupsInternal | Query and delete the Act! CRM Groups associated with an Opportunity. |
| OpportunityProductsInternal | Update, delete and query the Products associated with an Opportunity. |
| ProductsInternal | Create, update, delete and query the Products in your A ct! CRM database. |