Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Salesforce.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Salesforce, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Salesforce Stored Procedures
| Name | Description |
| AbortJob | Aborts a Salesforce job. |
| CloseJob | Closes a Salesforce job. |
| CloseJobV2 | Closes or aborts a Salesforce job. |
| ConvertLead | Converts a Lead into an Account, Contact, or (optionally) an Opportunity. |
| CreateBatch | Creates a Salesforce batch. |
| CreateCustomField | Adds a new custom field component to your organization. |
| CreateJob | Add a Salesforce object entry. |
| CreateJobV2 | Creates a job, which represents a bulk operation (and associated data) that is sent to Salesforce for asynchronous processing. Provide job data via an Upload Job Data request, or as part of a multipart create job request. |
| 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 Salesforce. |
| DownloadContentDocument | Downloads the content document or documents in Salesforce. |
| DownloadDocument | Downloads the document or documents in Salesforce. |
| GetBatch | Gets information about a Salesforce batch. |
| GetBatchResults | Gets the results of a Salesforce batch. |
| GetDeleted | Retrieves the list of individual records that have been deleted within the given timespan for the specified object. |
| GetJob | Gets information about a Salesforce job. |
| GetJobBatchIds | Get batch id for all batches in a Job. |
| GetJobInfoV2 | Gets information about a Salesforce job. |
| GetLimitInfo | Retrieves limit information for the organization. Use this stored procedure to monitor your SOAP API limits as you make calls against the organization. |
| 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. |
| MetadataDeploy | Deploys file representations of components into an org by creating, updating or deleting the components they represent. To be used after executing MetadataRetrieve Stored Procedure. |
| MetadataDeployDetails | Used to retrieve additional details about MetadataDeploy job. Can be used after executing MetadataDeploy Stored Procedure. |
| MetadataRetrieve | Retrieve file representations of components in an organization. |
| QueryBatch | Gets data from Salesforce using query batch. Only batches created in CSV format are supported. Note that the outputs of this stored procedure are dynamic and depend on the Query input. |
| QueryResultsV2 | Gets the results for a query job. The job must have the state JobComplete. |
| RefreshOAuthAccessToken | Refreshes the OAuth token or session id after the session has expired. Your OAuth application must have the refresh_token scope enabled. |
| Undelete | Restores from Salesforce's RecycleBin a deleted record. |
| UploadAttachment | Uploads an attachment and associates it with an entity in Salesforce. |
| UploadContentDocument | Uploads a content document in Salesforce. |
| UploadDocument | Uploads a document in Salesforce. |
| UploadJobDataV2 | Upload the CSV file to Salesforce. |