Question Re: Decode Binary from xml data in Technology Q&A

Decode Binary from xml data

former_member715070 — Fri, 28 May 2021 15:42:37 GMT

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

Re: Decode Binary from xml data

manoj_khavatkopp — Fri, 28 May 2021 16:21:02 GMT

Hi Pascal ,

You can achieve this using standard steps provided by CPI :

Your Data --->Filter-->Base64Decoder

In Filter:

Xpath : //Binary

Value Type: String.

Thanks,

Manoj

Re: Decode Binary from xml data

MortenWittrock — Sat, 29 May 2021 14:02:45 GMT

Hi Pascal

As manoj.khavatkopp points out, you can accomplish this easily using only the built-in steps. You need a Filter step to extract the Base64 encoded content and then a Base64 Decoder step. So like this:

After the first step, the payload consists of the Base64 encoded XML. After the second step, the payload is the decoded XML. This is assuming, of course, that the Base64 encoded stuff is actually XML. You refer to it as binary, but XML is text, right.

Configure the Filter step like this:

Have fun with CPI!

Regards,

Morten

Re: Decode Binary from xml data

former_member715070 — Mon, 31 May 2021 07:04:37 GMT

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

Re: Decode Binary from xml data

manoj_khavatkopp — Mon, 31 May 2021 09:54:37 GMT

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