Stored Procedures
Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
CData SSIS Components for FinancialForce 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 SOQL query. |
| 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. |