Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Act! CRM.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Act! CRM, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Act! CRM Stored Procedures
| Name | Description |
| AddCompanyToOpportunity | Associate the company (if it is not already present) to an opportunity |
| AddContactToGroup | Associate the contact (if it is not already present) to a group |
| AddContactToNote | Associate the contact (if it is not already present) to a note |
| AddContactToOpportunity | Associate the contact (if it is not already present) to an opportunity |
| AddGroupToOpportunity | Associate the group (if it is not already present) to an opportunity |
| AddOpportunityProduct | Creates a new Opportunity Product |
| AddOrRemoveCompaniesToContact | Associate or dissociate one or more companies to a contact. |
| AddOrRemoveContactToActivity | Add or remove the contact to an activity |
| AddOrRemoveContactToCompany | Associate the contact (if it is not already present) to a company. |
| AddOrRemoveContactToHistory | Associate or dissociate a contact to a history record. |
| AddOrRemoveGroupsToContact | Associate or dissociate one or more groups to a contact. |
| AddOrRemoveOpportunitiesToCompany | Associate or dissociate one or more opportunities to a company. |
| AddOrRemoveOpportunitiesToContact | Associate or dissociate one or more opportunities to a contact. |
| AddOrRemoveOpportunitiesToGroup | Associate or dissociate one or more opportunities to a group. |
| ClearActivity | Clears an activity. |
| ClearActivityAlarms | Clears an activity alarms |
| ClearOrUnclearTasks | Clear or unclear one or more tasks in bulk. |
| ClearTaskAlarms | Clear alarms for one or more tasks in bulk. |
| ConvertContactToUser | Convert an existing contact to a user. |
| DeleteAttachment | Delete an attachment from an Act! CRM entity. |
| DownloadAttachment | Download an attachment from an Act! CRM entity. |
| DuplicateContacts | Duplicate one or more contacts. |
| DuplicateTasks | Duplicate one or more tasks in bulk. |
| PromoteSecondaryContact | Promote a secondary contact to primary. |
| SubscribeContactToHotLeads | Subscribes a contact to hot-leads |
| UnclearActivity | Unclears an activity. |
| UpdateContactAccessLevel | Updates access level of an already existing contact. |
| UploadAttachment | Upload an attachment to an Act! CRM entity. |