This OneCloud Salesforce BizApp provides the functionality to interact with the data inside Salesforce, including loading, extracting and deleting data via SOQL and bulk operations. There are also functions for creating and managing Salesforce objects and updating and creating records.
OneCloud connects to Salesforce via the REST API. The OneCloud Salesforce BizApp is compatible with all versions of Salesforce’s Sales Cloud (Salesforce Essentials, Lightning Professional, Lightning Enterprise, and Lightning unlimited).
To automate functionality within your Salesforce environment from OneCloud, you’ll need to navigate to the connection manager to create a connection.
From here, choose Salesforce from the service drop-down, select the appropriate Runner, and use the Salesforce Connection Parameters to complete the setup.
Note the when you change the password to your Salesforce account, your security token will change and you will need to update your Security Token in the OneCloud connection manager.
The following is an example of a working connection. Please substitute your own values.
In order for the OneCloud Salesforce connection to work properly, you will need to grant the selected user the proper permissions. The API Enabled permission is an absolute requirement, but from here, your Salesforce administrator may decide which objects can be accessed. Navigate to Administer -> Manage Users -> Profiles, select the relevant profile, and ensure that this permission is enabled.
At a minimum, objects must have "read" permission enabled in order for the OneCloud BizApp to perform the appropriate functions, and you may add more permissions at your discretion. For example, if you wanted to make bulk changes to Salesforce objects of a certain type, that object must have the "update" permission enabled. See below for an example of standard object permissions, and note that this also applies to any custom objects.
One of the easiest ways to extract data from Salesforce is by using SOQL. The syntax is very similar to SQL, and users can create a SOQL query in OneCloud to extract the results into a CSV.
OneCloud's SOQL Query command can extract large volumes of data, and it can be used to return data sets of 1 million or more records at a time. If a command fails because the SOQL query is incorrect or references objects that do not exist, OneCloud will notify users via the command's outputs.
Users can take advantage of Bulk Jobs to insert, update, upsert, or delete records. Bulk jobs take a CSV as an input and will return information on how many records were processed correctly.
If all records were processed correctly, the command will have completed successfully. Upon any records failing, OneCloud will return a CSV listing the row numbers of the failed records, along with the reason for the failure. Users can take advantage of OneCloud's branching logic to perform actions when the job fails, or simply upload the failures to Google Drive to be examined later.
Lastly, bulk jobs can be performed synchronously or asynchronously. When checking the "Wait for completion" checkbox, OneCloud will poll Salesforce and only move onto the next command once all records have been processed. In cases where you may not need the result of the job to perform the next action in your chain, users can leave "Wait for completion" blank. This will allow OneCloud to trigger the bulk job and immediately move onto the next action in the chain.
For documentation on all available commands, see the Salesforce command reference.