sf_run_bulk_query | R Documentation |
This function is a convenience wrapper for submitting and retrieving query API jobs from the Bulk 1.0 and Bulk 2.0 APIs.
sf_run_bulk_query(
soql,
object_name = NULL,
queryall = FALSE,
guess_types = TRUE,
bind_using_character_cols = deprecated(),
interval_seconds = 3,
max_attempts = 200,
control = list(...),
...,
api_type = c("Bulk 2.0", "Bulk 1.0"),
verbose = FALSE
)
sf_query_bulk(
soql,
object_name = NULL,
queryall = FALSE,
guess_types = TRUE,
bind_using_character_cols = deprecated(),
interval_seconds = 3,
max_attempts = 200,
control = list(...),
...,
api_type = c("Bulk 2.0", "Bulk 1.0"),
verbose = FALSE
)
soql |
|
object_name |
|
queryall |
|
guess_types |
|
bind_using_character_cols |
|
interval_seconds |
|
max_attempts |
|
control |
|
... |
other arguments passed on to |
api_type |
|
verbose |
|
A tbl_df
of the recordset returned by the query
Bulk 1.0 documentation and Bulk 2.0 documentation
## Not run:
# select all Ids from Account object (up to 1000)
ids <- sf_query_bulk(soql = 'SELECT Id FROM Account LIMIT 1000')
# note that, by default, bulk queries are executed using the Bulk 2.0 API, which
# does not required the object name, but the Bulk 1.0 API can be still be invoked
# for queries by setting api_type="Bulk 1.0".
# alternatively you can specify as:
ids <- sf_query(soql = 'SELECT Id FROM Account LIMIT 1000',
api_type = "Bulk 2.0")
ids <- sf_query(soql = 'SELECT Id FROM Account LIMIT 1000',
object_name = 'Account',
api_type = "Bulk 1.0")
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.