
SoqlQuery
Enterprise Edition Talk to us
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-dynamic
Definitions
io.kestra.plugin.ee.salesforce.SalesforceConnection
password*Requiredstring
username*Requiredstring
authEndpointstring
Default
https://login.salesforce.com/services/Soap/u/63.0/query*Requiredstring
batchSizeintegerstring
Default
2000fetchTypestring
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEqueryMorebooleanstring
Default
trueOutputs
rowobject
rowsarray
SubTypeobject
sizeinteger
totalinteger
uristring
Format
uri