Xml to Json using File Adapter

[former_member338476]

Hi Experts,

we have a requirement is to create the Json format data in .txt file in the target system. The data is flowing from Source SAP System.

The Source Structure is show in below screen short.

My Target structure is

{

    "header": {

                     "file_Name": "test.txt",

                     "file_generation_time": "yyyy-MM-dd HH:mm:ss",

                     "no_of_records": "2",

                      "version": "1.1"

                    },

      "Records_data": [

                {

                "Field_1" :" test 1",

                 "Field_2" :" test 2",

               "Field_3" :" test 3",

               "Field_4" :" test 4",

                },

                {

                 "Field_1" :" test 1",

                 "Field_2" :" test 2",

               "Field_3" :" test 3",

               "Field_4" :" test 4",

                }

        ],

     "footer":{

        "file_Name": "test.txt",

        "no_of_records": "2"

                    }

}

Can anybody provide suggestions to convert the above source structure xml  into Json format.

[anupam_ghosh2]

Hi Raghava,

                     Please can you provide a sample xml .

Regards

Anupam

[former_member338476]

Hi Anupam

Sample xml structure is provided in above screenshot.

[former_member182412]

Hi Raghava,

Check this document.

Regards,

Praveen.

[former_member338476]

Hi Praveen,

Thank you for your valuable reply.

I tried to deploy custom adapter module into PI server through adapter module. But It throwing some error after deploying.

Exception has been returned while the [equalize.com/com.equalize.xpi.af.modules.app] was starting. Warning/Exception :[

][[ERROR CODE DPL.DS.6193] Error while ; nested exception is:

  com.sap.engine.services.deploy.exceptions.ServerDeploymentException: [ERROR CODE DPL.DS.5030] Clusterwide exception: [server ID 28175050:com.sap.engine.services.deploy.exceptions.ServerDeploymentException: [ERROR CODE DPL.DS.5029] Exception in operation [startApp] with application [equalize.com/com.equalize.xpi.af.modules.app].

  at com.sap.engine.services.deploy.server.application.ApplicationTransaction.rollbackPart(ApplicationTransaction.java:496)

  at com.sap.engine.services.deploy.server.application.ParallelAdapter.rollbackPart(ParallelAdapter.java:324)

  at com.sap.engine.services.deploy.server.application.StartTransaction.rollbackPart(StartTransaction.java:557)

  at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:380)

  at com.sap.engine.services.deploy.server.application.ParallelAdapter.makeAllPhases(ParallelAdapter.java:434)

  at com.sap.engine.services.deploy.server.application.StartTransaction.makeAllPhases(StartTransaction.java:526)

  at com.sap.engine.services.deploy.server.DeployServiceImpl.makeGlobalTransaction(DeployServiceImpl.java:1487)

  at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:806)

  at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:788)

  at com.sap.engine.services.deploy.server.DeployServiceImpl.startApplicationAndWait(DeployServiceImpl.java:776)

  at com.sap.engine.services.dc.lcm.impl.J2EELCMProcessor.doStart(J2EELCMProcessor.java:105)

  at com.sap.engine.services.dc.lcm.impl.LifeCycleManagerImpl.start(LifeCycleManagerImpl.java:78)

  at com.sap.engine.services.dc.lcm.impl.RemoteLCMImpl.start(RemoteLCMImpl.java:45)

  at com.sap.engine.services.dc.lcm.impl.RemoteLCMImplp4_Skel.dispatch(RemoteLCMImplp4_Skel.java:233)

  at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:384)

  at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:81)

  at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:67)

  at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:41)

  at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:1018)

  at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:57)

  at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:55)

  at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

  at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

  at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:327)

Caused by: java.lang.UnsupportedClassVersionError: com/equalize/xpi/af/modules/SetCorrelationBean has been compiled by a more recent version of the Java Runtime (class file version 50.0), this version of the Java Runtime only recognizes class file versions up to 49.0

  at java.lang.ClassLoader.defineClass1(Native Method)

  at java.lang.ClassLoader.defineClass(ClassLoader.java:699)

  at com.sap.engine.boot.loader.ResourceMultiParentClassLoader.loadClassLocal(ResourceMultiParentClassLoader.java:183)

  at com.sap.engine.boot.loader.MultiParentClassLoader.findClassInLoaderGraph(MultiParentClassLoader.java:312)

  at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:271)

  at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:243)

  at com.sap.engine.services.ejb3.runtime.impl.Actions_BeanClassesInitialization.loadApplicationClass(Actions_BeanClassesInitialization.java:54)

  at com.sap.engine.services.ejb3.runtime.impl.Actions_BeanClassesInitialization.loadApplicationClasses(Actions_BeanClassesInitialization.java:41)

  at com.sap.engine.services.ejb3.runtime.impl.Actions_ComponentInterfacesProviderClassesInitialization.loadApplicationClasses(Actions_ComponentInterfacesProviderClassesInitialization.java:20)

  at com.sap.engine.services.ejb3.runtime.impl.Actions_SessionBeanClassesInitialization.loadApplicationClasses(Actions_SessionBeanClassesInitialization.java:20)

  at com.sap.engine.services.ejb3.runtime.impl.Actions_StatelessBeanClassesInitialization.loadApplicationClasses(Actions_StatelessBeanClassesInitialization.java:18)

  at com.sap.engine.services.ejb3.runtime.impl.Actions_BeanClassesInitialization.perform(Actions_BeanClassesInitialization.java:27)

  at com.sap.engine.services.ejb3.container.CompositeAction.perform(CompositeAction.java:81)

  at com.sap.engine.services.ejb3.container.ApplicationStarter.perform(ApplicationStarter.java:59)

  at com.sap.engine.services.ejb3.container.ContainerInterfaceImpl$Actions.perform(ContainerInterfaceImpl.java:1115)

  at com.sap.engine.services.ejb3.container.ContainerInterfaceImpl.prepareStart(ContainerInterfaceImpl.java:568)

  at com.sap.engine.services.deploy.server.utils.container.ContainerWrapper.prepareStart(ContainerWrapper.java:363)

  at com.sap.engine.services.deploy.server.application.StartTransaction.prepareCommon(StartTransaction.java:369)

  at com.sap.engine.services.deploy.server.application.StartTransaction.prepare(StartTransaction.java:300)

  at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:374)

  ... 20 more

]]