Whether or not the bulk API is used for retrieving data.

Possible Values

Auto, False, True

Data Type

string

Default Value

"Auto"

Remarks

Whether or not the bulk API is used for retrieving data. When UseBulkAPI is set to "True", the adapter will always attempt to use the bulk API. However, there are several restrictions to accessible tables and columns. See Data Model for more information.

When set to "False", the adapter will use the REST API for all requests. When set to "Auto", the adapter will use whichever API is most appropriate for the request. For example, consider the following query:

SELECT * FROM Activity_EmailOpen

In this case, the adapter will use the Bulk API (because the ContactId is not specified), whereas the following query will use the REST API:

SELECT * FROM Activity_EmailOpen ContactId='...'

Using the Bulk API starts with the adapter sending a request to Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. BulkPollingInterval and BulkQueryTimeout control the frequency and duration of polling respectively.