ストアドプロシージャ

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

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

CData JDBC Driver for Outreach ストアドプロシージャ


Name	Description
CustomDuties	Creates or Finds profile with provided Specialid
Finish	Finishes an active sequence state.
GetOAuthAccessToken	Gets an authentication token from Outreach.
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.
MarkComplete	Creates or Finds the profile with provided Specialid
Pause	Finishes an active sequence state
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Outreach.
Resume	Finishes an active sequence state
SpecialProfileExists	Creates or finds profile with provided Specialid
TaskAdvance	Advances the sequence state associated with the task to the next step in the sequence
TaskDeliver	Schedules the mailing associated with the task for delivery, if possible.
TaskReassignOwner	Schedules the mailing associated with the task for delivery, if possible
TaskReschedule	Reschedules a task by setting a new task due time
TaskSnooze	Snooze the task.
TaskUpdateNotes	Creates or finds profile with provided Specialid.
TestSend	Test if sending emails works from this mailbox.
TestSync	Test if sending emails works from this mailbox.
UpdateOpportunityAssociation	Updates opportunity association of a task.