sf_query | R Documentation |
Executes a query against the specified object and returns data that matches the specified criteria.
sf_query(
soql,
object_name = NULL,
queryall = FALSE,
guess_types = TRUE,
api_type = c("REST", "SOAP", "Bulk 1.0", "Bulk 2.0"),
control = list(...),
...,
page_size = deprecated(),
next_records_url = NULL,
bind_using_character_cols = deprecated(),
object_name_append = FALSE,
object_name_as_col = FALSE,
verbose = FALSE
)
soql |
|
object_name |
|
queryall |
|
guess_types |
|
api_type |
|
control |
|
... |
arguments passed to |
page_size |
|
next_records_url |
|
bind_using_character_cols |
|
object_name_append |
|
object_name_as_col |
|
verbose |
|
tbl_df
of records
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.
https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch
## Not run:
sf_query("SELECT Id, Account.Name, Email FROM Contact LIMIT 10")
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.