- Dataraptor extract can be used to fetch data from the Salesforce system in a similar way to SOQL queries.
- If you want to retrieve data from Salesforce using Dataraptor extract, by specifying a parameter or utilizing the Setvalue function, and that Set value can be obtained from the upper steps of the omniscript (OS), you can utilize the following approach.
- In the provided Omniscript (OS) example, we have established a SetValue named AccountId, where a specific value is assigned to the Account Record Id.
- Now, proceeding from this set value, our objective is to retrieve data from Salesforce using Dataraptor extraction. In the DR Extract process, pass the parameter in the Input Parameter section.
Data Source: Parameter from SetValue
Filter Value: This variable is used in the DR extract to retrieve data from the Salesforce
system. like below
Note: There is no requirement to pass the variable in %VaribaleName% form.
- Similar to the AccountId, which is set using the SetValue operation obtained from the Parent OS, the IDFromSetValue variable is employed as the Filter Value.
Note: No need to IDFromSetValue in double-quotes.
- This Filter Value will be used in the Data Raptor to fetch the desired results, as illustrated below. The output of DR will be "AccountName" & "AccountNumber"
Take a look at this as well: DR and Integration Procedures' Environmental Variables
Thank You!