Stardust/Knowledge Base/Integration/Camel/Json File To Structured Data

Requirements

1. Need to write a process which should be triggered when a file arrives at a particular folder.
2. It should pick the file content (which happens to contain JSON Strings).
3. Need to convert the JSON string into IPP Data Structure and present it to users for editing the IPP data.
4. Once edited, need to convert the IPP data back to JSON string.

Steps:

1. Create a RAD project and copy the xpdl into it.
2. Copy all the source files as per its package structure.
3. Download jackson-core-asl-1.9.10.jar and jackson-mapper-asl-1.9.10.jar and put it in WEB-INF/lib of the RAD project.
4. Build the project, deploy the model.
5. Place a file with itxt as extension in the designated folder which is being monitored by Camel Trigger (in this case its C:\temp).

File Content is:

{"Name":"Tanmoy Roy","EmpID":"1002345","DoJ":1376332200000,"Salary":54433.0,
"Phones":[{"Home":"11111111","Mobile":"111111111","Office":"33333333333"},
{"Home":"2222222","Mobile":"2222222","Office":"34444444"}],
"dependents":[{"Name":"T1","Relation":"TR1","Age":21},
{"Name":"T2","Relation":"TR2","Age":43}]}

To achieve this we will be using IPP's Camel Trigger to monitor the arrival of the file. We will also use Camel Application Type to route the request to the required beans (in this case DataToJSON). The aim to use Camel Application Type is to enable extendibility of the solution to be routed to other Camel/IPP supported endpoints. The model:

Results:

As soon as the file is placed the process gets started and You will see it as below after completing Display File Contents activity:

Next activity screen will present the data for read/write, make changes to it and complete the activity.

You will get JSON String out of edited data as shown below:

{"Phones":[{"Home":"11111111","Mobile":"111111111","Office":"33333333333"},
{"Home":"2222222","Mobile":"2222222","Office":"34444444"},
{"Home":"6666666","Mobile":"6666666","Office":"66666666"}],
"Name":"Tanmoy Roy","dependents":[{"Name":"T1","Relation":"TR1","Age":21},
{"Name":"T2","Relation":"TR2","Age":43},
{"Name":"T3","Relation":"TR3","Age":56}],
"EmpID":"1002345","DoJ":1376332200000,"Salary":54433.0}

Artifacts:

Please get the required artifacts from here