Question Re: Decode Base64 at field level! in Technology Q&A

Decode Base64 at field level!

Former Member — Tue, 20 Aug 2013 13:19:49 GMT

Hi,

I am getting a soap response from webservice where one particular field will be encoded in base64 format.

While mapping I would like to decode this into binary format.

Please advise the procedures.

Regards

Anandh

Re: Decode Base64 at field level!

Former Member — Tue, 20 Aug 2013 14:02:55 GMT

Hi Anandh,

You need to implement a UDF or Java-Mapping to do the decoding. Please search on SDN, you will find some discussions.

Best Regards

Re: Decode Base64 at field level!

subhro_de — Tue, 20 Aug 2013 14:09:20 GMT

Hi Anandha,

If you are using the sap util libraries i.e. aii_utilxi_misc.jar - import this in imported archive - import/mention this in the Archives Used tab in the screenshot below. In the Import Instructions mention - com.sap.aii.utilxi.base64.api.Base64 and create a udf as shown below (add exception handling).

This udf can then be used in your mapping for decoding :

If you want to use apache libraries - Go to the functions tab and add the import - org.apache.commons.codec.binary.Base64.

Create a udf in similar lines - where encoded is the input field value :

byte[] decoded = Base64.decodeBase64(encoded);

String decodedout = String(decoded);

return decodedout;

Regards

Subhro

Re: Decode Base64 at field level!

praveenkva — Wed, 13 Apr 2022 11:08:26 GMT

HI,

How to get the com.sap.aii.utilxi.base64.api.* in the Import instructions of functions in SAP PI.

and also please let us know where to get this jar or class file.