sf_submit_query_bulk {salesforcer} | R Documentation |
Submit Bulk Query Batch to a Bulk API Job
Description
This function takes a SOQL text string and submits the query to an already existing Bulk API Job of operation "query"
Usage
sf_submit_query_bulk(job_id, soql, api_type = c("Bulk 1.0"), verbose = FALSE)
Arguments
job_id |
|
soql |
|
api_type |
|
verbose |
|
Value
A list
parameters of the batch
Note
Bulk API query doesn't support the following SOQL:
COUNT
ROLLUP
SUM
GROUP BY CUBE
OFFSET
Nested SOQL queries
Relationship fields
Additionally, Bulk API can't access or query compound address or compound geolocation fields.
References
Examples
## Not run:
my_query <- "SELECT Id, Name FROM Account LIMIT 1000"
job_info <- sf_create_job_bulk(operation = 'query', object = 'Account')
query_info <- sf_submit_query_bulk(job_id = job_info$id, soql = my_query)
## End(Not run)