SOURCE MESSAGEJMS Message In : <?xml version="1.0" encoding="UTF-8" standalone="yes"?><> A001 59619 94 579 2018-08-05T23:55:18 2018-08-05T23:55:18 2018-08-05 pmanagb8 USD 480 2018-08-05T23:55:18 pcms:PCMSTransaction pcms:BuildNumber3.106.0.0</pcms:BuildNumber> pcms:OnlineStatus0</pcms:OnlineStatus> pcms:TransactionType52</pcms:TransactionType> pcms:WorkstationLocationDT</pcms:WorkstationLocation> pcms:ExternalSystem pcms:SequenceNumber59619940480018080552</pcms:SequenceNumber> </pcms:ExternalSystem> wag:RFN59619940480018080552</wag:RFN> wag:CashierEmployeeID090909</wag:CashierEmployeeID> wag:CashierNumber131</wag:CashierNumber> </pcms:PCMSTransaction>
above is an xml in which i need the whole xml under one name like IN_MESSAGE and then i need seperate 3 line having RetailStoreID, ReceiptNumber,UnitID seperately.
Like below
"In_Message":
[ ["<?xml version="1.0" encoding="UTF-8" standalone="yes"?><> A001 59619 94 579 2018-08-05T23:55:18 2018-08-05T23:55:18 2018-08-05 pmanagb8 USD 480 2018-08-05T23:55:18 pcms:PCMSTransaction pcms:BuildNumber3.106.0.0</pcms:BuildNumber> pcms:OnlineStatus0</pcms:OnlineStatus> pcms:TransactionType52</pcms:TransactionType> pcms:WorkstationLocationDT</pcms:WorkstationLocation> pcms:ExternalSystem pcms:SequenceNumber59619940480018080552</pcms:SequenceNumber> </pcms:ExternalSystem> wag:RFN59619940480018080552</wag:RFN> wag:CashierEmployeeID090909</wag:CashierEmployeeID> wag:CashierNumber131</wag:CashierNumber> </pcms:PCMSTransaction> " ]
]
,
"RetailStoreID": [
[
"59619"
]
],
"ReceiptNumber": [
[
"480"
]
],
"UnitID": [
[
"A001"
]
], }