SoqlQuery
Run SOQL query and fetch rows
Enterprise Edition Talk to us
SoqlQuery
Run SOQL query and fetch rows
yaml
type: "io.kestra.plugin.ee.salesforce.SoqlQuery"Examples
yaml
id: query_salesforce_contacts
namespace: company.sales
tasks:
- id: query_contacts
type: io.kestra.plugin.ee.salesforce.SoqlQuery
connection:
username: "{{ secret('SALESFORCE_USERNAME') }}"
password: "{{ secret('SALESFORCE_PASSWORD') }}"
authEndpoint: "{{ secret('SALESFORCE_AUTH_ENDPOINT') }}"
query: "SELECT Id, FirstName, LastName, Email FROM Contact WHERE CreatedDate = LAST_WEEK"
fetchType: STORE
Properties
connection *RequiredNon-dynamic
Definitions
io.kestra.plugin.ee.salesforce.SalesforceConnection
accessTokenstring
authEndpointstring
Default
https://login.salesforce.com/services/Soap/u/63.0/instanceUrlstring
passwordstring
usernamestring
query *Requiredstring
batchSize integerstring
Default
2000fetchType string
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEqueryMore booleanstring
Default
trueOutputs
row object
rows array
SubTypeobject
size integer
total integer
uri string
Format
uri