In the prior exercise, you ran a Salesforce Custom Report and uploaded the CSV format to Anaplan. In this exercise, you will do something very similar but substitute the custom report command for a Salesforce SOQL Query. SOQL queries are indeed more complex than reports but also provide added flexibility in how the data is extracted
Step 1: Copy the Chain
Some of the setup of the Chain "Upload Salesforce Report to Anaplan" can be reused and in this case, it is easier to copy the Chain.
From OneCloud Home select the DEV environment.
Copy the chain "Upload Salesforce Report to Anaplan".
Step 2: Edit the Chain
Select the "Upload Salesforce Report to Anaplan -- Copy" and edit the Chain by selecting the ellipse on the right side.
Edit the Chain properties and rename the Chain to "Upload Salesforce Query to Anaplan".
Save the Chain properties.
Step 3: Delete the First Command
Drag the "Salesforce Opportunity Report" from the Start.
Hover your mouse over the Command and select the trash can icon to delete the Command.
Step 4: Add Salesforce SOQL Query
Add the first Command and select Salesforce-->SOQL Query operation. (Hint: use the Find tool to search for "Salesforce" and then search for "SOQL".)
Add the Command by dragging on to the pallet.
Select the new Command and drag it to the Start. The Chain Start will show a plus icon indicating that you can use that command as the start of the Chain.
Edit the new Command SOQL Query.
Copy the following query and paste it into the field Query.