B2B Integration

 View Only
Expand all | Collapse all

xmljsontransformer - XML to JSON transform

  • 1.  xmljsontransformer - XML to JSON transform

    Posted Thu March 19, 2020 12:35 AM
    Edited by System Wed March 22, 2023 11:44 AM
    Hi Team ,

    Is there a restriction or limitation on using xmljsontransformer in the Business process when we are trying to transform a xml document to json format ? I was told that the output json file is not available in the primary document and rather we have to use a file system adapter followed by xmljsontransformer to collect the output json file from file system for further processing. This is for ISBI 6.0.2 version. 

    Code snippet currently being used -

    <assign to="Prealert_filename" from="concat(&apos;PreAlert&apos;,&apos;_&apos;,process/BProcessID/text(),&apos;.json&apos;)"></assign> <assign to="Prealert_filename" from="concat(&apos;PreAlert&apos;,&apos;_&apos;,process/BProcessID/text(),&apos;.json&apos;)"></assign> <operation name="Request">          <participant name='xmljsontransformer'/>  <output message='xout'> <assign to='.' from='PrimaryDocument/@SCIObjectID'></assign> <assign to='inputtype'>XML</assign>   <assign to='outputpath' from='//Prealert_filename/text()'></assign> <assign to='.' from='*'/>  </output> <input message="xin"> <assign to='.' from='*'/> </input> </operation>               

    <operation name="File System Adapter">          <participant name="Json_Prealerts_FSA"/>         <output message="FileSystemInputMessage">          <assign to="." from="*"/>          <assign to="Action">FS_COLLECT</assign>  <assign to="filter" from="//Prealert_filename/text()"></assign>         <assign to="appendOnExtract">false</assign>  <assign to="deleteAfterCollect">true</assign> </output>  <input message="Xin">  <assign to="." from="*"/>  </input> </operation>

    The whole idea is to check if we can eliminate the FSA step 

    Thanks,
    Pranjit

    ------------------------------
    Pranjit Biswas
    ------------------------------
    #SupplyChain
    #B2BIntegration


  • 2.  RE: xmljsontransformer - XML to JSON transform

    Posted Tue May 12, 2020 09:45 AM
    Hi Pranjit,

    Did you refer below link on Knowledge Center. All information about the service is documented there.
    https://www.ibm.com/support/knowledgecenter/SS3JSW_6.0.2/integrating/integrating/integrator/XML-JSON_service.html

    Thanks
    Manoj

    ------------------------------
    Manoj Bansal
    ------------------------------