-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Optimizing Salesforce Industries Solutions on the Vlocity OmniStudio Platform
By :

The QUERY
function in DataRaptors in Integration Procedures allows us to run a SOQL query and returns a list of values in its response JSON node. It is just as if we were to run a separate Extract DataRaptor right inside a formula. While this function is very powerful, it’s also easy to abuse by calling it multiple times to retrieve more than one field, using it in Transform-type DataRaptors, and so on.
Note
The QUERY
function only selects a single field, so if we need to extract multiple fields with it, we will need to create multiple formulas.
Try to avoid using the QUERY
function in DataRaptor Transforms. This introduces new data; thus, input and output will no longer match, making the DataRaptor difficult to debug.
Let’s put the QUERY
function to the test to see how it affects the performance of our OmniStudio apps. The following DataRaptor extracts data from the Contact object and then uses three QUERY
formulas to...
Change the font size
Change margin width
Change background colour