Vlocity Facts #41 || Custom Function to Convert List of Values into Array of Values in DataMapper Formula

In one of the post we used SPLIT() function [Reference -  DataMapper - Function and Formulas] to split the string. In response we received list of values.

Consider one scenario where you have selected multiple values from multi select picklist called Products.

In json we will get the response of the multiple select picklist with combination of semi colon[;]. If we need to create child records for those values it is not directly possible, so to divide those values we will use SPLIT() function with splitToken as semicolon [;].

Now will split those products SPLIT(%Products%,";")

Response: 

Now we need to use custom function - apex class to convert list of values into array of values.

[Similar post where we used custom function to calculate the difference between datatime fields: Using Custom Function in DataMapper]

By referring above mentioned post we will create one more method in the same apex class by writing logic in it.

I have made some changes to invokemethod by adding 'else If'

And added 'listToArray' Method logic to same apex class.


If we are using Function() in fomula tab and passing List() as input we need to use 'VLOCITY-FORMULA-LIST' to get the list of values in apex class.
FUNCTION('dateTimeDiffFinder','lsitToArrayConverter',LIST(%Products%))
If you observe I'm using same apex class but method name and input are different.
Response: 

In response you can observe node name with Products is related to SPLIT() function and ListTOArrayProducts [list to array of values with keys] is related to the custom function which we implemented through apex class and we can pass that json to DataMapper Post to create records.






Comments

Post a Comment

Popular posts from this blog

Vlocity Facts #01 | OmniStudio DataRaptors

DataRaptor is a mapping tool that  you can use to read, transform, and write Salesforce data. For Example. In each interaction with a digital customer  or business process, the system needs to extract the data in order to display it. If the user modifies this data or enters new data, they also need to be saved. This is where we use OmniStudio DataRaptors.  Where to use DataRaptors? Retrieving Data:   OmniScript calls  DataRaptor Extract (via the integration procedure) to read the data from Salesforce. For example, OmniScript editing an account should display data such as account name, phone number, website, and so on. Manipulating data: OmniScript captures modified and new data based on user input. For example, an agent changes the  phone number of an account. Save Data:   OmniScript calls DataRaptor Load (via the integration procedure) to write the data back to Salesforce. For example, the updated account phone number is saved back to the Account rec...
Read more

Vlocity Facts #34 || Getting the details from the URL in a FlexCard and an Omniscript

Image
 1.The parameters in the URL must be in the format c__Node, followed by their values, in order to extract the parameters from the URL. For example: If you need to show different layout or different set of actions for community users and salesforces users you can pass different parameters in URL. For Community Portal Pass Community or any other reference value in ' c__Type '. https://salesforce.lightning.force.com/lightning/cmp/ omnistudio__vlocityLWCOmniWrapper?c__target=c%3ApHXTestFlexCard&c__tabIcon=custom%3Acustom18& c__Type =Community  For Salesforce Users Pass Salesforce or any other reference value in ' c__Type '. https://salesforce.lightning.force.com/lightning/cmp/ omnistudio__vlocityLWCOmniWrapper?c__target=c%3ApHXTestFlexCard&c__tabIcon=custom%3Acustom18& c__Type =Salesforce  2. We can get the value as {Params.c__Parameter} from the FlexCard and we can execute different actions based on the input. 3. From the omniscript,  we can retrieve ...
Read more

Vlocity Facts #44 || Communication between Omniscript and Flexcard [Pub/Sub]

Image
Flexcards have the ability to trigger and listen to two kinds of events: Custom and Pubsub events . Custom Events: Facilitate the transmission of information between a child and its parent. This can occur between a child Flexcard and its parent Flexcard, or between an element and the Flexcard to which it belongs. Pubsub Events: Allows communication between two separate components. This could occur between two separate Flexcards on the same Lightning page, known as sibling Flexcards, or between a Flexcard and an Omniscript.  In this post I will discuss about Pub/Sub event. Consider we have omniscript and flexcard individually on home page when an update happens we need to show those details in flexcard. To achieve this we can use pub/sub event. Step 1: Create a omniscript according to your requirement. I'm trying to create Contact record by using Step element and data raptor post action. Now to trigger the flexcard we need to configure the messaging frame work when an update happen...
Read more