Connect directly to your Salesforce instance

Production or Sandbox / Staging

You can either connect to your production instance or to a sandbox instance. The only exception are custom-domain instances. They cannot be connected to currently. As a workaround you can use OAuth 2 .

API Access

Make sure your edition of Salesforce has access to the API. See this overview of editions with and without access to the API

Authentication

When you click on Authenticate with Salesforce a popup will open where you can login with your salesforce instance. After logging in you will be shown a consent screen asking for permissions. Allowing that permission will finish the authentication and close the popup afterwards. In case you have issues authenticating with Salesforce you can find a list of possible error messages and their meaning here.

Revoking Access

You can at any time revoke the access by clicking on Revoke Access.

URL with SOQL Query

After authentication with salesforce the URL field will be populated with an SOQL query that fetches all account names. The query can be changed to fetch the data you need for your use case. See the API documentation of Salesforce for more details.

https://yourinstance.salesforce.com/services/data/v45.0/query/?q=Select name from account
CODE

If you want to make parts of the query flexible or dependant on other custom fields the following approach is suitable

https://xxx/services/data/v45.0/query/?q=Select name from account where id='{accountID}'
CODE

That way you can fill the variable accountID later with for example $.issue.fields.customfield_10XXX

In case you want to use the Salesforce data source with different queries you can define a variable and set the query in the field configuration later

https://yourinstance.salesforce.com/services/data/v45.0/query/?q={query}
CODE

Example Queries

Select Account Name and Lastname of the creator. If the account is active and ordered by name ascending

SELECT Name, CreatedBy.LastName FROM Account WHERE Active__c='YES' ORDER BY Name ASC
CODE

For more information about how to build SOQL queries please visit the documentation.

Limitations

Salesforce allows a maximum of 5 refresh tokens per user. Each additional token will revoke one of the existing. So you can at max create 5 Salesforce data sources with the same user account.

The maximum number of rows returned by SOQL over the REST API is 2.000 per request. You can workaround this limitation by using Salesforce Pagination