How can I make XML messages readable?

OmeLuuk · #1 8th September 2022, 17:16

In our ION database I find the table ION_BOD_MESSAGE.

Code:

SELECT top 1000 *
  FROM [Infor_OSTest_ION].[dbo].[ION_BOD_MESSAGE]
  order by C_DATE desc

In it there is a BLOB field C_BOD with a HEX representation of the BOD.
Like C_BOD:

Quote:

Originally Posted by C_BOD

0x785EC5564B73E23810BEEFAFF0FA329789E5F01A42094F1120C435131E
31F3482E2A610BF044963C921C427EFDB66D48583207933D2C45A96CA91F
5FB7BEEE36FEFC9470EB91291D4BD1B5CF1DD7B6980865148B55D7FE36BF
...
5DD9EC66CDD40976DFDCE40BAFACAEF561774AA64AAE14349E0FD5014B05
83C55A6CAD371E8E585739B27204140D7DD7C50F7660F0FEBBF9BFBCEEC7
2A48C0202E5718CAE8F5FB03BD7E94A0C3EF4EEF1F6F76DB36

Now I would like to "grep Trigger *.xml" on the files in this BLOB, but as you can see they are HEX based encode somehow.

In OneView I can see these messages one by one, and in the "grid view" they are shown as a clickable icon where you can read the content. But when exporting to Excel CSV that column is not in the CSV.

What is the way to read the XML in the C_BOD field?