Allows querying a Salesforce instance using the Salesforce Object Query Language. For more information on SOQL, refer to Salesforce SOQL reference documentation.
a!sfcQuery( scsExternalSystemKey, usePerUserCredentials, endpoint, query)
scsExternalSystemKey: (Text) The key from the Third Party Credentials admin console page that corresponds to the set of credentials that should be used to authenticate.
usePerUserCredentials: (Boolean) If
true the credentials set in the Third-Party Credentials settings page by the current user running the expression will be used. If
false the site-wide credential values will be used.
endpoint: (Text) The Salesforce endpoint URL to use for authentication. Possible values are
"https://login.salesforce.com/services/Soap/u/27.0", which is used for production and development environments, and
"https://test.salesforce.com/services/Soap/u/27.0", which is used for the Salesforce "sandbox" test environment. Update the
27.0 portion of the endpoint URL to match the version of the API that you are accessing. As a best practice, create a constant for this value.
query: (Text) The SOQL query to send to Salesforce
The function returns the standard connector result dictionary described in the main Connectors page.
If successful, the function returns a dictionary representation of the Salesforce QueryResult within the
result field. Refer to Salesforce documentation for details regarding the contents of QueryResult.
Retrieve a List of Opportunities
Copy and paste the expression into the Interface Designer, save it, then call the interface in a Tempo Report to test.