Decode Binary from xml data

[former_member715070]

Hello,

I try to get an xml node receiving from an Odata, below is the structure

I would like to get this specific node, then transform it in xml structure.

I use in a content modifier the different properties from the blog

https://blogs.sap.com/2015/04/30/base64decodeconverter-base64-decoding-made-easy/

But infortunatly I can't transform the binary data into xml data

Do you have an idea, do I forget some property into the content modifier in order to transform properly the data ?

Thanks for your help and your answers.

Regards

[former_member715070]

Hello manoj.khavatkopp and Morten Wittrock thank you very much for your answers.

The binary node contains an " excel file " received from BydDesign software. We want to get this excel file from ByDesign decode it then get different data inside in order to map them.

I tried your solutions but infortunatly there is no decode of the file.

Do you have any other ideas to solve this ?

Thanks for your answers

Regards

[manoj_khavatkopp]

Hi Pascal,

Currently, there is no out of box solution to read/write excel file, however you use format conversion bean to read excel and convert into xml . This has to be used after base64 decoding .

https://blogs.sap.com/2018/09/04/formatconversionbean-arrives-in-cpi/

Thanks,

Manoj