Excel Add-In for UMSaaSCloud

Build 24.0.9062

UseBulkAPI

Whether to use the synchronous SOAP API or the asynchronous Bulk API.

データ型

bool

デフォルト値

false

解説

This property determines whether or not the asynchronous Bulk API is used for reads and writes to UMSaaSCloud. For reads, the driver automatically creates bulk query jobs and starts returning results as they are available. Note that queries using a JOIN or aggregation are not supported in the Bulk API and therefore the driver falls back to using the SOAP API for these queries. Jobs are closed automatically once they are complete or if there is a failure.

For writes back to UMSaaSCloud, up to 10000 records can be sent per batch. These requests are processed asynchronously, meaning the driver does not wait for Salesforce to process the results fully. You can query the following table to get information about the jobs and batches that were created:

SELECT * FROM [Info#TEMP]

The ID values returned from this can be used with GetJob, GetBatch, and GetBatchResults to check the status of the job and batches.

Note that when this property is set to false, the default, you can still modify multiple records simultaneously: The 本製品 performs batch processing through the Web Services API, which synchronously returns the status of your operations.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062