ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Pipedrive の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにPipedrive から関連するレスポンスデータを返します。
CData JDBC Driver for Pipedrive ストアドプロシージャ
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. |