ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Pipedrive の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにPipedrive から関連するレスポンスデータを返します。

CData Excel Add-In 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.