FireDAC Components for FinancialForce

Build 20.0.7654

Use Bulk API

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

Syntax


property UseBulkAPI: Boolean;

Data Type

Boolean

Default Value

false

Remarks

This property determines whether or not the asynchronous Bulk API is used for reads and writes to FinancialForce. For reads, the driver will automatically create bulk query jobs and start 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 will fall 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 FinancialForce, up to 10000 records can be sent per batch. These requests will be processed asynchronously meaning the driver will not wait for FinancialForce 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 component will perform batch processing through the Web Services API, which will synchronously return the status of your operations.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654