Boomi Mapping - User Defined function based on list of elements in a collection

Recently I came across a requirement to validate all the elements in a collection and return an output based on that. Let me explain it with an example. I have a XML document containing information about users including a collection to indicate the roles of the person.


Source Document

<users>
<user>
<first_name></first_name>
<roles>
<role>admin</role>
<role>subscriber</role>
<role>creator</role>
</roles>
</user>
</users>

Destination Document

I want to map this into a destination profile which has elements to indicate whther the user is an admin or a subsriber.


<users>
<user>
<isAdmin>true</isAdmin>
<isSubscriber>true</isSubscriber>
<user>
<users>
</users>

In order to achieve this I have to write a map funtion. But for a map funtion, we can't input a collection. If we map the "roles" collection into the map fuction, it creates multiple output documents, one per element in the collection. 

So I came up with a solution with the help of dynamic document property. Here, all the elements in the collection are concatanated into a single string while using the dynamic document property as a 
temporary variable. Then this dynamic document property is validated to derive relevant elements in the destination profile. 

Function 1 - Accumulating all the values in the collection into a single property. 

  1. Write a User define funtion with "role" as the input (The individual element inside the collection).
  2.  Add a function step with a scripting function (Javascript). This should take 2 inputs. 
    • new_role - contains single role.
    • all_roles - contains comma separated roles. 
    • The script should concatanate new_role into all_roles. Then return the result - all_roles_result. 
  3. Add the second function step to set a dynamic document property (DDP_roles) to hold roles result. Map the output of above function step into this one. 
  4. Now add the third function step to get above document property(DDP_roles) and map that into "all_roles" input of scripting function step. 
    User Defined Function 1
What above will do is, accumulate all the values in the collection into a dynamic document property as a comma separated string. 

Function 2 - Validate the property containing all the values

  1. Write a user deine function with no input.
  2. As the first step get the dynamic document proerty abdefined above "DDP_roles"
  3.  Add another step for Scripting with one input variable - roles_list. Map above property as the input into it. 
  4. Validate the roles_list using Javascript and return isAdmin and isSubscriber as output.
  5. Now above output variables can be mapped to the destination profile. 
    User Defined Function 2

Enable map function ordering

Since Function 1 must run before the Function 2, we have to enable ordering of them. For that, click on "Order the function execution" option in the top right corner of the functions 
section in the mapcomponent. Then enable "Enable map function ordering?" option and make sure order is correctly listed. 
Map Component with 2 functions

Split documents

If you have multiple records in the XML document (multiple elements), it will accumulate the document property with values in all the user records. In order to stop that, you have to process send each user record separately into the Map. So we have to place "data-process" shape and split the document by users/user element before the map shape. 
Split Document configuration
Place Data Process shape before the Map

Thank you!

Comments

Post a Comment

Popular posts from this blog

PHP-SOAP web service with out a WSDL

This article is going to describe how to create a simple web service with php-soap step by step. Requirements     Server to run php (apache, xampp , wamp)     PHP-SOAP extension Steps Let's write a simple web service to find the length of a given string. So here is the code for StringLengthServer.php   <?php # StringLengthServer.php # Copyright (c) 2011 by Lakmali Baminiwatta #     function findLength($string) {            return "Length of the string " . $string . "is : ".strlen($string);     }            $server = new SoapServer(null,               array('uri' => "urn://www.lakmali.lk"));        $server->addFunction("findLength");        $server->handle();  ?> First thing done here is to write a function to perform the action done by the service. So here function findLength($string) takes a string as the argument and prints back the length of it. Then SoapServer is created. First argument
Keep reading

Boomi Mapping - Removing special chars from an input

Image
Dell Boomi mapping shape provides numerous ways to modify/enrich an input via functions. In this post I am going to show how I validated and removed special chars from an input using Scripting and do it along with another string function. The user defined functions available with mapping, allows us to apply sequence of functions to the input. In this example, I am going to use it. Use Case: I have two input strings coming from the source profile (first_name and last_name), which I want to first concatanate together and then remove non-alphanumeric characters if present. Solution In your map, add an User Defined function and add two inputs; first_name, last_name.  Add User Defined function into the map Added inputs to the user defined function As the first step, add a function "String Concat" under the  "String" category.  Specify first_name and last_name as the inputs. Also set a delimiter, if you need a one. In my case, I want to concatena
Keep reading

How to add Maven dependency from a relative path referencing a local jar

When you want to add a dependency which is not stored in maven repositories to your project this is the way!! You can manually download it and include inside the project and refer it from the pom.xml through a relative path. This example assumes that you have downloaded and stored the jar inside ${project}/src/test/resources/lib.  <dependency> <groupId>ojdbc</groupId> <artifactId>ojdbc6</artifactId> <scope>system</scope> <version>6</version> <systemPath>${basedir}/src/test/resources/lib/ojdbc6.jar</systemPath> </dependency> Here we must specify the scope of the dependency  as 'system'. There is another way which is to manually install the maven dependency to your local repository. You can find out how from here .
Keep reading