Data Raptor/Data Mapper (Turbo Extract) - omniscript - salesfroce SFI -

1. Data Raptor Turbo Extract

To extract data from Single Salesforce object + fields from related objects

Ex: Extract contact details along with associated Account where AccountId <> null

SOQL: SELECT Id, Name, AccountId from Contact WHERE AccountId <> null

Ex: Extract contact details along with associated Account where AccountId <> null AND contact email <> null

• Order the result in ASC / DESC order
• Limit the number of output records
• Use of Offset in data raptor

 Create new Data Mapper / DataRaptor

click on preview button

Click on execute button to get output

1. But recomended use ''  as '$Vlocity.NULL'  in condition. it should contain single quotes.

2. ORDER BY   ->  Name ASC     here if you have Name then it will automatically display  ascending order

3. ORDER BY   ->  Name DESC     here if you have Name then it will automatically display  descending order.

SOQL :

SELECT Id, AccountId, Name, Email 

FROM Contact 

WHERE AccountId != null 

ORDER BY Name DESC 

1. Limit - previous ly we are getting 11 records if you a

SOQL :

SELECT Id, AccountId, Name, Email 

FROM Contact 

WHERE AccountId != null 

ORDER BY Name DESC 

OFFSET 5

After adding below conditions records will be display 3 obly.

SOQL :

SELECT Id, AccountId, Name, Email 

FROM Contact 

WHERE AccountId != null 

ORDER BY Name DESC 

LIMIT 3 

OFFSET 5

==================================================================

SOQL :

SELECT Id, Name, Email FROM Contact WHERE Account.Name = 'Siva'

below is DM implimentation.

In below image if we are not using '' then it mean it is varible we are passing to this soql - AccountName

If you click on editparams

Add one key like below screen

click on "Execute " button we are able to see contacts that are accosiated with this account name record as below 

Real time examples on Data Raptor Turbo Extract

[Learning from this ex: fetch data from related object with filtering condition]

Ex 1: Extract contact details along with associated Account Name for specific account Name – "Acme"

[Learning from this ex: use of input variable in data raptor]

Ex 2: Extract contact details along with associated Account Name for provided account name as input from other components (IP, Flexcard, etc)

Ex 3: Extract contact details along with associated Account Name for provided account name as input from other components (IP, Flexcard, etc) + display records created by "Loggedin user"