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('PreAlert','_',process/BProcessID/text(),'.json')"></assign> <assign to="Prealert_filename" from="concat('PreAlert','_',process/BProcessID/text(),'.json')"></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