Provides create, update, upsert, query and get integrations for Salesforce via it's REST API (see https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/).
18.104.22.168 Updated to API v45, added bulk update and upsert capabilities, misc other enhancements
22.214.171.124 Fixed bug where expired session was not being re-acquired
Type: Connection Input
An optional URL for the Salesforce instance. This property should only be necessary for Sandbox environments.
The App Consumer Key (See Creating a Connection below)
The App Consumer Secret (See Creating a Connection below)
The Salesforce user username.
The Salesforce user password.
The Salesforce account security token (See Creating a Connection below)
By default, the records in the
Request property will be interleaved in to the records in the
Response property which makes it much easier to correlate records in batch requests. If this setting is turned on, interleaving is skipped - consider using this if you don't need to correlate request records with response records and have a large volume of requests to make (there is a small performance gain if this setting is enabled).
The Connection Property
Type: List Input
Create - creates one or more records
Update - updates one or more records keyed on the
Id field or otherwise the field specified in
Get - retrieves the record specified by the
Id field in the
Query - returns a list of all records matching the specified SQL filter
Upsert - updates or creates one or more records. If
Id or the field name specified in
ExternalIdField is present, an update is performed otherwise a create is performed
The Action to perform against the object in
Type: String Input
The name of the object to be acted upon.
Type: String Input
Upsert , records can be updated by keying them on the
Id field or, if a value is provided for
ExternalIdField , by keying them on that field instead.
Type: Xml Output
The ResponseXml returned by the Salesforce API.
This Nodes uses the composite API in batch mode to provide create/update/upsert, see https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_composite_batch.htm for more information.
Creating a Connection
Register an app in your Salesforce account
- After signing in to Salesforce, click the Setup cog (top, right of screen), then click Setup.
- In the menu on the left, click Apps, then click App Manager.
- Click New Connected App.
- Provide a name for your app and API name (eg. Flowgear for both) as well as a contact email and name.
- Tick the Enable OAuth Settings checkbox.
- Provide a secure URL (eg. your website) in Callback URL (eg. https://yourcompany.com).
- Under Selected OAuth Scopes, click Full access (full) then click the Add button.
- Click Save, then Continue.
- In the page that loads next, the value in Consumer Key should be copied and pasted into the ConsumerKey property in your Flowgear Salesforce Connection while the Consumer Secret (click Click to reveal) should be used in the ConsumerSecret property.
Obtain a security token for your Salesforce account
- After signing in to Salesforce, click the Person Icon (top, right of screen), then click Settings.
- In the menu on the left, click Reset my Security Token under My Personal Information.
- Click the Reset Security Token button to have a new token emailed to you (note that this will invalidate any previously used tokens).
- In the email you receive, copy the security token into the SecurityToken property in your Flowgear Salesforce Connection.
Using a Sandbox Account
- If you are using a Sandbox Salesforce account, you need to set the URL property of the Connection as https://test.salesforce.com