Stored Procedures

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

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

CData Python Connector for Certinia Stored Procedures


Name	Description
AbortJob	Terminates an active Salesforce job before completion.
CloseJob	Closes a Salesforce job to indicate it is complete and no longer accepting new data.
CloseJobV2	Closes or aborts a Salesforce job based on its current state.
ConvertLead	Converts a Lead record into an Account, Contact, and optionally an Opportunity.
CreateBatch	Creates a batch job in Salesforce for bulk processing of records.
CreateCustomField	Adds a new custom field to a specified Salesforce object.
CreateJob	Initiates a new Salesforce job for processing bulk data operations.
CreateJobV2	Creates a new job for asynchronous data processing in Salesforce, supporting bulk API operations.
CreateSchema	Generates a schema file for a specified Salesforce table, defining field structure and types.
DeleteJobV2	Deletes a job in Salesforce, provided it has a status of UploadComplete, JobComplete, Aborted, or Failed.
DownloadAttachment	Downloads attachments related to a specific Salesforce entity.
DownloadContentDocument	Retrieves documents stored in Salesforce Content Library.
DownloadDocument	Downloads documents from Salesforce for offline access or external use.
GetBatch	Retrieves details about a specific Salesforce batch job.
GetBatchRecords	Fetches the original submitted records of a completed Salesforce batch job.
GetBatchResults	Fetches the results of a completed Salesforce batch job.
GetDeleted	Returns a list of records deleted within a specified timeframe for a given object.
GetJob	Retrieves details about a specific Salesforce job, including its status and associated records.
GetJobBatchIds	Fetches batch IDs for all batches associated with a specific Salesforce job.
GetJobInfoV2	Retrieves details of a Salesforce job, including its processing status and metadata.
GetLimitInfo	Fetches API usage and limit details for the Salesforce organization.
GetOAuthAccessToken	Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Salesforce APIs.
GetOAuthAuthorizationUrl	Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process.
GetUpdated	Returns a list of records updated within a specified timeframe for a given object.
GetUserInformation	Fetches personal details of the authenticated Salesforce user.
Merge	Combines up to three records of the same type into a single record while preserving relevant data.
MetadataDeploy	Deploys metadata components to a Salesforce organization, enabling changes to object structures and configurations.
MetadataDeployDetails	Retrieves additional details about a metadata deployment job in Salesforce.
MetadataRetrieve	Retrieves metadata components from a Salesforce organization for backup or modification.
QueryBatch	Executes a batch query in Salesforce, allowing large dataset retrieval in multiple chunks.
QueryParallelResultsV2	Fetches the results locators in parallel for a query job once the job has completed processing.
QueryResultsV2	Fetches results for a query job once the job has completed processing.
RefreshOAuthAccessToken	Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Salesforce resources without requiring reauthorization from the user.
Undelete	Restores records previously deleted and stored in Salesforce's Recycle Bin.
UploadAttachment	Uploads an attachment and associates it with a specific Salesforce record.
UploadContentDocument	Uploads a document to Salesforce Content and associates it with relevant records.
UploadDocument	Uploads a document to Salesforce, making it available in the document repository.
UploadJobDataV2	Uploads a CSV file as job data for processing within Salesforce bulk operations.