Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT operations with Outreach.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Outreach, along with an indication of whether the procedure succeeded or failed.

CData Excel Add-In for Outreach Stored Procedures


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.