Transform XML to JSON for PI 7.4 java single stack

[Former Member]

Dear All,

As you know, the Module Name of communication channel JSONTransformBean is available to transform XML to JSON. BUT for  PI7.4 SP13 java single stack, whether there is better solution to transform XML to JSON? JSONTransformBean is available for java single stack?

I have two scenarios,one is  from third-party system to SAP ECC. The sender third-party system is the data format of JSON. The other one is from SAP ECC to third-party system. The receiver third-party system need the data format of JSON. 

Could you please to share some good advice?

Thank you for your support in advance.

Many thanks & best regards,

Hubery

[Former Member]

Dear All,

I test the data format from ,

But failed. The output format is not JSON. Maybe it is because of PI version?

Many thanks & best regards,

Hubery

[bhavesh_kantilal]

Hello Hubery,

The Blog you are referring to is a Custom Adapter Module developer by Eng Swee Yeoh.

You would need to download the Adapter Module from here: Release Excel2XMLTransformer - new parameters for configurable header row position and stripping of ...

Once you have dowbloaded this EAR you need to then deploy it on to your server.

This is something you need to thank for/

[Former Member]

Dear Bhavesh,

Thank you for your response. You mean that I need to download and deploy the EAR file ,and then refer to the ? If so, I will test it .

Many thanks & best regards,

Hubery

[bhavesh_kantilal]

Hello Hubery,

yes - you would need to download the EAR and then deploy the same on your server. Only post the same would you be able to use this module in your PI configuration.

Regards

Bhavesh

[Former Member]

Dear Bhavesh,

For SCA file, basis could deploy it. But for EAR file, I ask for the basis consultant, he is not sure how install or deploy the file. Do you have any advice or material to deploy the EAR file?

Thank you for your input.

Many thanks & best regards,

Hubery

[bhavesh_kantilal]

You may use NWDS to deploy a EAR file :

Regards,

Bhavesh

[Former Member]

Dear Bhavesh,

I have deployed the EAR file. I have a test scenario where it is asynchronous interface. The receiver adapter is SOAP. I  configure the below according to the . But there is no change.

there is no change.

Hubery

[manoj_khavatkopp]

Hubery,

The module sequence is wrong first you need to call the custom module then the later one XISOAPAdapter.

Br,

Manoj