Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the adapter beyond simple SELECT/INSERT/UPDATE/DELETE operations with FinancialForce with SSO.
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from FinancialForce with SSO, along with an indication of whether the procedure succeeded or failed.
FinancialForce with SSO Adapter Stored Procedures
Name | Description |
AbortJob | Aborts a FinancialForce job. |
CloseJob | Closes a FinancialForce job. |
CloseJobV2 | Closes or aborts a FinancialForce job. |
ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
CreateBatch | Creates a FinancialForce batch. |
CreateJob | Add a FinancialForce object entry. |
CreateJobV2 | Creates a job, which represents a bulk operation (and associated data) that is sent to FinancialForce for asynchronous processing. Provide job data via an Upload Job Data request, or as part of a multipart create job request. |
CreateReportSchema | Creates a schema file based on the specified report. |
CreateSchema | Creates a schema file for the specified table. |
DeleteJobV2 | Deletes a job. To be deleted, a job must have a state of UploadComplete, JobComplete, Aborted, or Failed. |
DownloadAttachment | Downloads the attachment or attachments associated with a specific entity in FinancialForce. |
DownloadDocument | Downloads the document or documents in FinancialForce. |
GetBatch | Gets information about a FinancialForce batch. |
GetBatchResults | Gets the results of a FinancialForce batch. |
GetCustomReport | Get the custom report by report Id. |
GetDeleted | Retrieves the list of individual records that have been deleted within the given timespan for the specified object. |
GetJob | Gets information about a FinancialForce job. |
GetJobBatchIds | Get batch id for all batches in a Job. |
GetOAuthAccessToken | If using a Windows application, set Authmode to App. If using a Web app, set Authmode to Web and specify the Verifier obtained by GetOAuthAuthorizationUrl. |
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. |
GetUpdated | Retrieves the list of individual records that have been updated within the given timespan for the specified object. |
GetUserInformation | Retrieves personal information for the user associated with the current session. |
Merge | Combines up to 3 records of the same type into 1 record. |
QueryBatch | Get data from FinancialForce using query batch. Only batches created with content type CSV can be queried with this stored procedure. |
RefreshOAuthAccessToken | Refreshes the OAuth token or session id after the session has expired. Your OAuth application must have the refresh_token scope enabled. |
UploadAttachment | Uploads an attachment and associates it with an entity in FinancialForce. |
UploadDocument | Uploads a document in FinancialForce. |
UploadJobDataV2 | Upload the CSV file to FinancialForce. |