Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Pipedrive.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Pipedrive, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Pipedrive Stored Procedures
| Name | Description |
| AddAudioFile | Adds an audio recording to the call log. |
| AddChannel | Adds a new messaging channel, only admins are able to register new channels. |
| AddFile | Upload a file and associate it with Deal, Person, Organization, Activity or Product. |
| AddPersonPicture | Add Person Picture. |
| CancelRecurringSubscription | Cancels a recurring subscription. |
| CreateRemoteFile | Creates a new empty file in the remote location (googledrive). |
| DealsDuplicate | Duplicate deals.It will create new record for the particular deal. |
| DeleteChannel | Deletes an existing messenger’s channel and all related entities (conversations and messages). |
| DeletePersonPictures | Delete person picture. |
| DownloadFile | Adds an audio recording to the call log. |
| GetOAuthAccessToken | Gets an authentication token from PipeDrive. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| LinkRemoteFile | Links an existing remote file (googledrive). |
| MergeDeals | Merge two deals in one deal. |
| MergeOrganizations | Merges an organization with another organization. |
| MergePersons | Adds an audio recording to the call log. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Pipedrive. |