You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by contactreji <co...@gmail.com> on 2015/03/22 13:30:09 UTC
Camel XML-JSON marshalling : camel-xmljson dataFormat
Hey
Is there any way to configure this component to explicitely specify the
array elements in resultant json string from an xml in xmljson mashalling
process.Can you carefully notice the placement of square brackets on the
output and the expected result.
Attaching my camel route towards the end of this post.
I am marshalling the following xml.
*
<?xml version="1.0" encoding="UTF-8"?>
<HemsData>
<root>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x028701</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:47+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC0</Epc>
<Edt>0x837875F3</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC1</Epc>
<Edt>0x7464932F</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC2</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x028801</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:48+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x97</Epc>
<Edt>0x0101</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x98</Epc>
<Edt>0x07DE0101</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xD7</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE0</Epc>
<Edt>0x837875F3</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE1</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE3</Epc>
<Edt>0x7464932F</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE5</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE7</Epc>
<Edt>0x77777777</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE8</Epc>
<Edt>0x66666666</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xEA</Epc>
<Edt>0x07DE010100000077777777</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xEB</Epc>
<Edt>0x07DE010100000077777777</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x027901</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:49+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x0A808182888A9D9E9FE0E1</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE0</Epc>
<Edt>0x03E3</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE1</Epc>
<Edt>0x07076363</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x027D01</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:50+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x0D808182888A9D9E9FDAE2E3E4E6CF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xDA</Epc>
<Edt>0x43</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE2</Epc>
<Edt>0xEEEEEEEE</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE3</Epc>
<Edt>0x3456</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE4</Epc>
<Edt>0x44</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE6</Epc>
<Edt>0xFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xCF</Epc>
<Edt>0x43</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x027C01</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:51+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x0A808182888A9D9E9FC4C5</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC4</Epc>
<Edt>0xFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC5</Epc>
<Edt>0x65432345</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x027E01</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:52+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC0</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC1</Epc>
<Edt>0x2222</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC2</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC3</Epc>
<Edt>0x2222</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC4</Epc>
<Edt>0x53</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC5</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC6</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC7</Epc>
<Edt>0x41</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC8</Epc>
<Edt>0x8888888888888888</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC9</Epc>
<Edt>0x8888888888888888</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xCA</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xCB</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xD0</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xD1</Epc>
<Edt>0x2222</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xDA</Epc>
<Edt>0x41</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE2</Epc>
<Edt>0x44444444</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE3</Epc>
<Edt>0x2222</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE4</Epc>
<Edt>0x11</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x013001</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:53+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x0C808182888A9D9E9FB0B38FBBA0</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xB0</Epc>
<Edt>0x44</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xB3</Epc>
<Edt>0x32</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8F</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xBB</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xA0</Epc>
<Edt>0x31</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x029001</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:44+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x09808182888A9D9E9FB6</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xB6</Epc>
<Edt>0x45</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x026B01</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:45+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x0B808182888A9D9E9FB0C0C3</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xB0</Epc>
<Edt>0x41</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC0</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xC3</Epc>
<Edt>0x41</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
<HemsDatum>
<HemsId>SVC0000000000ABCxxxxxx1234560005</HemsId>
<SequenceNo>1</SequenceNo>
<Nodes>
<Node>
<NodeId>782BCB95E7CE</NodeId>
<Instances>
<Instance>
<Eoj>0x027201</Eoj>
<Esv>0x72</Esv>
<Timestamp>data2024-03-19T22:36:46+09:00</Timestamp>
<CollectProperties>
<CollectProperty>
<Epc>0x80</Epc>
<Edt>0x30</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x81</Epc>
<Edt>0x01</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x82</Epc>
<Edt>0x00004500</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x88</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x8A</Epc>
<Edt>0xFFFFFF</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9D</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9E</Epc>
<Edt>0x00</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0x9F</Epc>
<Edt>0x0B808182888A9D9E9FB0C0C3</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xD0</Epc>
<Edt>0x41</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE2</Epc>
<Edt>0x42</Edt>
</CollectProperty>
</CollectProperties>
<CollectProperties>
<CollectProperty>
<Epc>0xE3</Epc>
<Edt>0x41</Edt>
</CollectProperty>
</CollectProperties>
</Instance>
</Instances>
</Node>
</Nodes>
</HemsDatum>
</root>
</HemsData>
*
The resultant json which i get is
{"HemsData":{"root":[{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x028701","Esv":"0x72","Timestamp":"data2024-03-19T22:36:47+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"}},{"CollectProperty":{"Epc":"0xC0","Edt":"0x837875F3"}},{"CollectProperty":{"Epc":"0xC1","Edt":"0x7464932F"}},{"CollectProperty":{"Epc":"0xC2","Edt":"0x00"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x028801","Esv":"0x72","Timestamp":"data2024-03-19T22:36:48+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x97","Edt":"0x0101"}},{"CollectProperty":{"Epc":"0x98","Edt":"0x07DE0101"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"}},{"CollectProperty":{"Epc":"0xD7","Edt":"0x01"}},{"CollectProperty":{"Epc":"0xE0","Edt":"0x837875F3"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x00"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x7464932F"}},{"CollectProperty":{"Epc":"0xE5","Edt":"0x01"}},{"CollectProperty":{"Epc":"0xE7","Edt":"0x77777777"}},{"CollectProperty":{"Epc":"0xE8","Edt":"0x66666666"}},{"CollectProperty":{"Epc":"0xEA","Edt":"0x07DE010100000077777777"}},{"CollectProperty":{"Epc":"0xEB","Edt":"0x07DE010100000077777777"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027901","Esv":"0x72","Timestamp":"data2024-03-19T22:36:49+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0A808182888A9D9E9FE0E1"}},{"CollectProperty":{"Epc":"0xE0","Edt":"0x03E3"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x07076363"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027D01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:50+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0D808182888A9D9E9FDAE2E3E4E6CF"}},{"CollectProperty":{"Epc":"0xDA","Edt":"0x43"}},{"CollectProperty":{"Epc":"0xE2","Edt":"0xEEEEEEEE"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x3456"}},{"CollectProperty":{"Epc":"0xE4","Edt":"0x44"}},{"CollectProperty":{"Epc":"0xE6","Edt":"0xFF"}},{"CollectProperty":{"Epc":"0xCF","Edt":"0x43"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027C01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:51+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0A808182888A9D9E9FC4C5"}},{"CollectProperty":{"Epc":"0xC4","Edt":"0xFFFF"}},{"CollectProperty":{"Epc":"0xC5","Edt":"0x65432345"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027E01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:52+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"}},{"CollectProperty":{"Epc":"0xC0","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC1","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xC2","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC3","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xC4","Edt":"0x53"}},{"CollectProperty":{"Epc":"0xC5","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC6","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC7","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xC8","Edt":"0x8888888888888888"}},{"CollectProperty":{"Epc":"0xC9","Edt":"0x8888888888888888"}},{"CollectProperty":{"Epc":"0xCA","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xCB","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xD0","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xD1","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xDA","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xE2","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xE4","Edt":"0x11"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x013001","Esv":"0x72","Timestamp":"data2024-03-19T22:36:53+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0C808182888A9D9E9FB0B38FBBA0"}},{"CollectProperty":{"Epc":"0xB0","Edt":"0x44"}},{"CollectProperty":{"Epc":"0xB3","Edt":"0x32"}},{"CollectProperty":{"Epc":"0x8F","Edt":"0x42"}},{"CollectProperty":{"Epc":"0xBB","Edt":"0x01"}},{"CollectProperty":{"Epc":"0xA0","Edt":"0x31"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x029001","Esv":"0x72","Timestamp":"data2024-03-19T22:36:44+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x09808182888A9D9E9FB6"}},{"CollectProperty":{"Epc":"0xB6","Edt":"0x45"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x026B01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:45+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0B808182888A9D9E9FB0C0C3"}},{"CollectProperty":{"Epc":"0xB0","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xC0","Edt":"0x42"}},{"CollectProperty":{"Epc":"0xC3","Edt":"0x41"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027201","Esv":"0x72","Timestamp":"data2024-03-19T22:36:46+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0B808182888A9D9E9FB0C0C3"}},{"CollectProperty":{"Epc":"0xD0","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xE2","Edt":"0x42"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x41"}}]}}}}}]}}
But my target system accepts json in following format
*
{"HemsData":[{"HemsDatum":{"HemsId": "tkktsb0001418379900","SequenceNo":
"1","Nodes": [{"Node":{"NodeId": "00-00-00-00-00-01","Instances":
[{"Instance":{"Eoj": "0x028701","Esv": "0x72","Timestamp":
"2015-01-22T12:00:00+09:00","CollectProperties": [{"CollectProperty":{"Epc":
"0xC0","Edt": "0x0D1"}},{"CollectProperty":{"Epc": "0xC1","Edt":
"0x0A2"}},{"CollectProperty":{"Epc": "0xC2","Edt":
"0x03"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x02"}},{"CollectProperty":{"Epc":
"0xEA","Edt":
"0x07de0c120d1e00000002d7"}},{"CollectProperty":{"Epc":"0xEB","Edt":"0x07de0c19121e0000000056"}}]}}]}}]}},{"HemsDatum":{"HemsId":
"tkktsb0001418379899","SequenceNo": "1","Nodes": [{"Node":{"NodeId":
"00-00-00-00-00-01","Instances": [{"Instance":{"Eoj": "0x028701","Esv":
"0x72","Timestamp": "2015-01-22T12:00:00+09:00","CollectProperties":
[{"CollectProperty":{"Epc": "0xC0","Edt":
"0x0D1"}},{"CollectProperty":{"Epc": "0xC1","Edt":
"0x0A2"}},{"CollectProperty":{"Epc": "0xC2","Edt":
"0x03"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x02"}},{"CollectProperty":{"Epc":
"0xEA","Edt":
"0x07de0c120d1e00000002d7"}},{"CollectProperty":{"Epc":"0xEB","Edt":"0x07de0c19121e0000000056"}}]}}]}}]}}]}
*
Camel Routes
--------------
<camelContext xmlns="http://camel.apache.org/schema/spring">
<camel:dataFormats>
<camel:xmljson id="xmljsonWithOptions"
forceTopLevelObject="true" trimSpaces="true" rootName="newRoot"
skipNamespaces="true" removeNamespacePrefixes="true"
expandableProperties="d e" />
<camel:xmljson id="xmljson"
forceTopLevelObject="true" trimSpaces="true" rootName="newRoot"
skipNamespaces="true" removeNamespacePrefixes="true"
/>
</camel:dataFormats>
<route id="jsontoxml">
<from uri="file:C:/Users/rmathews/Desktop/testin/in" />
<convertBodyTo type="java.lang.String" />
<unmarshal ref="xmljsonWithOptions"/>
<log message="${body}" loggingLevel="INFO" logName="Log" />
<to uri="xquery:xquery/Untitled1.xq"/>
<log message="After Transformation ${body}" loggingLevel="INFO"
logName="Log" />
<to uri="file:C:/Users/rmathews/Desktop/testin/nttXML" />
</route>
<route id="xmltojson">
<from uri="file:C:/Users/rmathews/Desktop/testin/nttXML" />
<convertBodyTo type="java.lang.String" />
<marshal ref="xmljson" />
<log message="TOSHIBA JSON is ${body}" loggingLevel="DEBUG"
logName="Json2XML" />
<log message="${body}" loggingLevel="INFO" logName="Log" />
<to uri="file:C:/Users/rmathews/Desktop/testin/out" />
</route>
</camelContext>
-----
Reji Mathews
Sr. Developer - Middleware Integration / SOA ( Open Source - Apache Camel & Jboss Fuse ESB | Mule ESB )
LinkedIn - http://in.linkedin.com/pub/reji-mathews/31/9a2/40a
Twitter - reji_mathews
--
View this message in context: http://camel.465427.n5.nabble.com/Camel-XML-JSON-marshalling-camel-xmljson-dataFormat-tp5764562.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Camel XML-JSON marshalling : camel-xmljson dataFormat
Posted by Willem Jiang <wi...@gmail.com>.
It looks camel has some trouble to remove the root element, maybe you need to find other way to process the XML first.
--
Willem Jiang
Red Hat, Inc.
Web: http://www.redhat.com
Blog: http://willemjiang.blogspot.com (English)
http://jnn.iteye.com (Chinese)
Twitter: willemjiang
Weibo: 姜宁willem
On March 22, 2015 at 8:30:39 PM, contactreji (contactreji@gmail.com) wrote:
> Hey
>
> Is there any way to configure this component to explicitely specify the
> array elements in resultant json string from an xml in xmljson mashalling
> process.Can you carefully notice the placement of square brackets on the
> output and the expected result.
>
> Attaching my camel route towards the end of this post.
>
> I am marshalling the following xml.
>
> *
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x028701
> 0x72
> data2024-03-19T22:36:47+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
>
>
>
>
> 0xC0
> 0x837875F3
>
>
>
>
> 0xC1
> 0x7464932F
>
>
>
>
> 0xC2
> 0x00
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x028801
> 0x72
> data2024-03-19T22:36:48+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x97
> 0x0101
>
>
>
>
> 0x98
> 0x07DE0101
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
>
>
>
>
> 0xD7
> 0x01
>
>
>
>
> 0xE0
> 0x837875F3
>
>
>
>
> 0xE1
> 0x00
>
>
>
>
> 0xE3
> 0x7464932F
>
>
>
>
> 0xE5
> 0x01
>
>
>
>
> 0xE7
> 0x77777777
>
>
>
>
> 0xE8
> 0x66666666
>
>
>
>
> 0xEA
> 0x07DE010100000077777777
>
>
>
>
> 0xEB
> 0x07DE010100000077777777
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x027901
> 0x72
> data2024-03-19T22:36:49+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x0A808182888A9D9E9FE0E1
>
>
>
>
> 0xE0
> 0x03E3
>
>
>
>
> 0xE1
> 0x07076363
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x027D01
> 0x72
> data2024-03-19T22:36:50+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x0D808182888A9D9E9FDAE2E3E4E6CF
>
>
>
>
> 0xDA
> 0x43
>
>
>
>
> 0xE2
> 0xEEEEEEEE
>
>
>
>
> 0xE3
> 0x3456
>
>
>
>
> 0xE4
> 0x44
>
>
>
>
> 0xE6
> 0xFF
>
>
>
>
> 0xCF
> 0x43
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x027C01
> 0x72
> data2024-03-19T22:36:51+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x0A808182888A9D9E9FC4C5
>
>
>
>
> 0xC4
> 0xFFFF
>
>
>
>
> 0xC5
> 0x65432345
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x027E01
> 0x72
> data2024-03-19T22:36:52+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
>
>
>
>
> 0xC0
> 0x44444444
>
>
>
>
> 0xC1
> 0x2222
>
>
>
>
> 0xC2
> 0x44444444
>
>
>
>
> 0xC3
> 0x2222
>
>
>
>
> 0xC4
> 0x53
>
>
>
>
> 0xC5
> 0x44444444
>
>
>
>
> 0xC6
> 0x44444444
>
>
>
>
> 0xC7
> 0x41
>
>
>
>
> 0xC8
> 0x8888888888888888
>
>
>
>
> 0xC9
> 0x8888888888888888
>
>
>
>
> 0xCA
> 0x44444444
>
>
>
>
> 0xCB
> 0x44444444
>
>
>
>
> 0xD0
> 0x44444444
>
>
>
>
> 0xD1
> 0x2222
>
>
>
>
> 0xDA
> 0x41
>
>
>
>
> 0xE2
> 0x44444444
>
>
>
>
> 0xE3
> 0x2222
>
>
>
>
> 0xE4
> 0x11
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x013001
> 0x72
> data2024-03-19T22:36:53+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x0C808182888A9D9E9FB0B38FBBA0
>
>
>
>
> 0xB0
> 0x44
>
>
>
>
> 0xB3
> 0x32
>
>
>
>
> 0x8F
> 0x42
>
>
>
>
> 0xBB
> 0x01
>
>
>
>
> 0xA0
> 0x31
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x029001
> 0x72
> data2024-03-19T22:36:44+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x09808182888A9D9E9FB6
>
>
>
>
> 0xB6
> 0x45
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x026B01
> 0x72
> data2024-03-19T22:36:45+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x0B808182888A9D9E9FB0C0C3
>
>
>
>
> 0xB0
> 0x41
>
>
>
>
> 0xC0
> 0x42
>
>
>
>
> 0xC3
> 0x41
>
>
>
>
>
>
>
>
> SVC0000000000ABCxxxxxx1234560005
> 1
>
>
> 782BCB95E7CE
>
>
> 0x027201
> 0x72
> data2024-03-19T22:36:46+09:00
>
>
> 0x80
> 0x30
>
>
>
>
> 0x81
> 0x01
>
>
>
>
> 0x82
> 0x00004500
>
>
>
>
> 0x88
> 0x42
>
>
>
>
> 0x8A
> 0xFFFFFF
>
>
>
>
> 0x9D
> 0x00
>
>
>
>
> 0x9E
> 0x00
>
>
>
>
> 0x9F
> 0x0B808182888A9D9E9FB0C0C3
>
>
>
>
> 0xD0
> 0x41
>
>
>
>
> 0xE2
> 0x42
>
>
>
>
> 0xE3
> 0x41
>
>
>
>
>
>
>
>
>
> *
>
>
> The resultant json which i get is
>
> {"HemsData":{"root":[{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x028701","Esv":"0x72","Timestamp":"data2024-03-19T22:36:47+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"}},{"CollectProperty":{"Epc":"0xC0","Edt":"0x837875F3"}},{"CollectProperty":{"Epc":"0xC1","Edt":"0x7464932F"}},{"CollectProperty":{"Epc":"0xC2","Edt":"0x00"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x028801","Esv":"0x72","Timestamp":"data2024-03-19T22:36:48+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x97","Edt":"0x0101"}},{"CollectProperty":{"Epc":"0x98","Edt":"0x07DE0101"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"}},{"CollectProperty":{"Epc":"0xD7","Edt":"0x01"}},{"CollectProperty":{"Epc":"0xE0","Edt":"0x837875F3"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x00"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x7464932F"}},{"CollectProperty":{"Epc":"0xE5","Edt":"0x01"}},{"CollectProperty":{"Epc":"0xE7","Edt":"0x77777777"}},{"CollectProperty":{"Epc":"0xE8","Edt":"0x66666666"}},{"CollectProperty":{"Epc":"0xEA","Edt":"0x07DE010100000077777777"}},{"CollectProperty":{"Epc":"0xEB","Edt":"0x07DE010100000077777777"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027901","Esv":"0x72","Timestamp":"data2024-03-19T22:36:49+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0A808182888A9D9E9FE0E1"}},{"CollectProperty":{"Epc":"0xE0","Edt":"0x03E3"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x07076363"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027D01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:50+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0D808182888A9D9E9FDAE2E3E4E6CF"}},{"CollectProperty":{"Epc":"0xDA","Edt":"0x43"}},{"CollectProperty":{"Epc":"0xE2","Edt":"0xEEEEEEEE"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x3456"}},{"CollectProperty":{"Epc":"0xE4","Edt":"0x44"}},{"CollectProperty":{"Epc":"0xE6","Edt":"0xFF"}},{"CollectProperty":{"Epc":"0xCF","Edt":"0x43"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027C01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:51+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0A808182888A9D9E9FC4C5"}},{"CollectProperty":{"Epc":"0xC4","Edt":"0xFFFF"}},{"CollectProperty":{"Epc":"0xC5","Edt":"0x65432345"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027E01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:52+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"}},{"CollectProperty":{"Epc":"0xC0","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC1","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xC2","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC3","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xC4","Edt":"0x53"}},{"CollectProperty":{"Epc":"0xC5","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC6","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xC7","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xC8","Edt":"0x8888888888888888"}},{"CollectProperty":{"Epc":"0xC9","Edt":"0x8888888888888888"}},{"CollectProperty":{"Epc":"0xCA","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xCB","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xD0","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xD1","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xDA","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xE2","Edt":"0x44444444"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x2222"}},{"CollectProperty":{"Epc":"0xE4","Edt":"0x11"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x013001","Esv":"0x72","Timestamp":"data2024-03-19T22:36:53+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0C808182888A9D9E9FB0B38FBBA0"}},{"CollectProperty":{"Epc":"0xB0","Edt":"0x44"}},{"CollectProperty":{"Epc":"0xB3","Edt":"0x32"}},{"CollectProperty":{"Epc":"0x8F","Edt":"0x42"}},{"CollectProperty":{"Epc":"0xBB","Edt":"0x01"}},{"CollectProperty":{"Epc":"0xA0","Edt":"0x31"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x029001","Esv":"0x72","Timestamp":"data2024-03-19T22:36:44+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x09808182888A9D9E9FB6"}},{"CollectProperty":{"Epc":"0xB6","Edt":"0x45"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x026B01","Esv":"0x72","Timestamp":"data2024-03-19T22:36:45+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0B808182888A9D9E9FB0C0C3"}},{"CollectProperty":{"Epc":"0xB0","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xC0","Edt":"0x42"}},{"CollectProperty":{"Epc":"0xC3","Edt":"0x41"}}]}}}}},{"HemsId":"SVC0000000000ABCxxxxxx1234560005","SequenceNo":"1","Nodes":{"Node":{"NodeId":"782BCB95E7CE","Instances":{"Instance":{"Eoj":"0x027201","Esv":"0x72","Timestamp":"data2024-03-19T22:36:46+09:00","CollectProperties":[{"CollectProperty":{"Epc":"0x80","Edt":"0x30"}},{"CollectProperty":{"Epc":"0x81","Edt":"0x01"}},{"CollectProperty":{"Epc":"0x82","Edt":"0x00004500"}},{"CollectProperty":{"Epc":"0x88","Edt":"0x42"}},{"CollectProperty":{"Epc":"0x8A","Edt":"0xFFFFFF"}},{"CollectProperty":{"Epc":"0x9D","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9E","Edt":"0x00"}},{"CollectProperty":{"Epc":"0x9F","Edt":"0x0B808182888A9D9E9FB0C0C3"}},{"CollectProperty":{"Epc":"0xD0","Edt":"0x41"}},{"CollectProperty":{"Epc":"0xE2","Edt":"0x42"}},{"CollectProperty":{"Epc":"0xE3","Edt":"0x41"}}]}}}}}]}}
>
>
>
>
>
> But my target system accepts json in following format
>
> *
> {"HemsData":[{"HemsDatum":{"HemsId": "tkktsb0001418379900","SequenceNo":
> "1","Nodes": [{"Node":{"NodeId": "00-00-00-00-00-01","Instances":
> [{"Instance":{"Eoj": "0x028701","Esv": "0x72","Timestamp":
> "2015-01-22T12:00:00+09:00","CollectProperties": [{"CollectProperty":{"Epc":
> "0xC0","Edt": "0x0D1"}},{"CollectProperty":{"Epc": "0xC1","Edt":
> "0x0A2"}},{"CollectProperty":{"Epc": "0xC2","Edt":
> "0x03"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x02"}},{"CollectProperty":{"Epc":
> "0xEA","Edt":
> "0x07de0c120d1e00000002d7"}},{"CollectProperty":{"Epc":"0xEB","Edt":"0x07de0c19121e0000000056"}}]}}]}}]}},{"HemsDatum":{"HemsId":
> "tkktsb0001418379899","SequenceNo": "1","Nodes": [{"Node":{"NodeId":
> "00-00-00-00-00-01","Instances": [{"Instance":{"Eoj": "0x028701","Esv":
> "0x72","Timestamp": "2015-01-22T12:00:00+09:00","CollectProperties":
> [{"CollectProperty":{"Epc": "0xC0","Edt":
> "0x0D1"}},{"CollectProperty":{"Epc": "0xC1","Edt":
> "0x0A2"}},{"CollectProperty":{"Epc": "0xC2","Edt":
> "0x03"}},{"CollectProperty":{"Epc":"0xE1","Edt":"0x02"}},{"CollectProperty":{"Epc":
> "0xEA","Edt":
> "0x07de0c120d1e00000002d7"}},{"CollectProperty":{"Epc":"0xEB","Edt":"0x07de0c19121e0000000056"}}]}}]}}]}}]}
> *
>
>
> Camel Routes
> --------------
>
>
>
>
>
> > forceTopLevelObject="true" trimSpaces="true" rootName="newRoot"
> skipNamespaces="true" removeNamespacePrefixes="true"
> expandableProperties="d e" />
> > forceTopLevelObject="true" trimSpaces="true" rootName="newRoot"
> skipNamespaces="true" removeNamespacePrefixes="true"
> />
>
>
>
>
>
>
>
>
> > logName="Log" />
>
>
>
>
>
>
>
> > logName="Json2XML" />
>
>
>
>
>
>
>
>
>
> -----
> Reji Mathews
> Sr. Developer - Middleware Integration / SOA ( Open Source - Apache Camel & Jboss Fuse
> ESB | Mule ESB )
> LinkedIn - http://in.linkedin.com/pub/reji-mathews/31/9a2/40a
> Twitter - reji_mathews
> --
> View this message in context: http://camel.465427.n5.nabble.com/Camel-XML-JSON-marshalling-camel-xmljson-dataFormat-tp5764562.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>