问超过2000条记录的salesforce对象的强制cli查询

EN

all_leads <- "SELECT Id FROM Lead WHERE CreatedDate < TODAY"

rforcecom.bulkQuery(rforce_session, all_leads,object="Lead") -> all_leads_df

library(tidyverse)
library(salesforcer)
sf_auth(username, password, security_token)

# get all the fields on the Contact object (remove compound fields which 
# are not queryable via the Bulk API.
# https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/compound_fields.htm
contact_fields <- sf_describe_object_fields('Contact') %>% 
  filter(type != 'address', !grepl('Latitude|Longitude', name))

# build the SOQL
all_soql <- sprintf("SELECT %s FROM Contact", 
                    paste(contact_fields$name, collapse=","))

# query the records and fields
all_records <- sf_query(all_soql, "Contact", api_type="Bulk 1.0")
all_records
#> # A tibble: 2,039,230 x 58
#>   Id                 IsDeleted MasterRecordId AccountId   ...
#>   <chr>              <lgl>     <lgl>          <lgl>    
#> 1 0033s00000wycyeAAA FALSE     NA             NA       
#> 2 0033s00000wycyjAAA FALSE     NA             NA       
#> 3 0033s00000wycyoAAA FALSE     NA             NA
#> # ...