How To Do Data Mapping in Kumologica

Data mapping is a key element in integration. Most of the prominent integration tools provide different capabilities for data mapping. In this article I thought of sharing on how data mapping can be achieved in Kumologica. Kumologica uses JSONata as the base for data mapping. JSONata is a Lightweight query and transformation language for JSON data. It supports complex queries expression which can be achieved with minimal syntax and has a location path semantics of Xpath 3.1.

To understand the Kumologica data mapping lets create an API which will accept a JSON data as an API request which will be mapped to a new JSON data structure and provide as API response. The request JSON data will also be sorted in descending order when mapping is done. Kumologica data mapper node will achieve both mapping and sorting function together.

Pre-requisite

1. Downloaded and Installed Kumologica Designer.(Required)
2. Walkthrough on tutorial.(Optional).

Developing an API

1. Open the Kumologica Designer and create a new project.
2. Drag and drop EventListener node from the palette on to the designer canvas.
3. Configure the EventListener node with the Source as API Gateway. Verb as POST and path as /employee.
4. Drag and drop an datamapper node from the palette on to the designer.
5. On the Sample Input section of the datamapper node paste the following

    [
       {
           "Candidate_Name" : "Arun",
           "Candidate_Age" :  "25"
     
       },
          {
           "Candidate_Name" : "John",
           "Candidate_Age" :  "32"
     
       },
       {
           "Candidate_Name" : "Sarah",
           "Candidate_Age" :  "22"
     
       },
          {
           "Candidate_Name" : "Harry",
           "Candidate_Age" :  "28"
     
       }

    ]

On the Mapping section of the datamapper node paste the following mapping expression.

    $sort(
       $map(
           msg,
           (
               function($l){
                   {
                       "EmpName" : $l.Candidate_Name,
                       "Emp_Age" : $l.Candidate_Age
       
                   }

    }
           )

    ),
       function($l,$r){$l.Emp_Age < $r.Emp_Age}
    )

    [
        {
            "EmpName": "Jhon",
            "Emp_Age": "32"
        },
        {
            "EmpName": "Harry",
            "Emp_Age": "28"
        },
        {
            "EmpName": "Arun",
            "Emp_Age": "25"
        },
        {
            "EmpName": "Sarah",
            "Emp_Age": "22"
        }
    ]

As you can see the Result output shown has mapped the JSON request to a new structure and also sorted the records in descending order.

6. Now Drag and drop the EventListener End node on to the canvas.

7. Open the settings for EventListener End and configure the payload as msg.payload and leave rest of the values as default.

Deployment

Now let’s deploy the flow to AWS lambda. Before deployment select the AWS profile under the cloud tab. Also ensure that your AWS profile selected is having Kumologica Designer Role associated. If proper role is not associated the flow will fail to deploy to AWS.

Now Click Deploy .

Conclusion

References