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

Syntax

Connect-OracleEloqua -UseBulkAPI string

Possible Values

Auto, False, True

Data Type

cstr

Default Value

"Auto"

Remarks

Whether or not the bulk API is used for retrieving data. When UseBulkAPI is set to "True", the cmdlet 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 cmdlet will use the REST API for all requests. When set to "Auto", the cmdlet will use whichever API is most appropriate for the request. For example, consider the following query:

SELECT * FROM Activity_EmailOpen

In this case, the cmdlet 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 cmdlet 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.