SoqlQuery
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-dynamicSalesforceConnection
query *Requiredstring
batchSize integerstring
Default
2000
fetchType string
Default
NONE
Possible Values
STORE
FETCH
FETCH_ONE
NONE
queryMore booleanstring
Default
true
Outputs
row object
rows array
SubType object
size integer
total integer
uri string
Format
uri
Definitions
io.kestra.plugin.ee.salesforce.SalesforceConnection
password *Requiredstring
username *Requiredstring
authEndpoint string
Default
https://login.salesforce.com/services/Soap/u/63.0/