IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only
Expand all | Collapse all

WTX Typetrees for JSON form for X12 Data

  • 1.  WTX Typetrees for JSON form for X12 Data

    Posted Sat March 09, 2019 02:27 PM

    Originally posted by: carao2020


    Hi,

    Could you please clarify whether there are any type trees for generating JSON format data from X12 837, 835 documents. 

    Are there any ways that we can generate type trees for JSON format of X12 data?

     

    Thanks


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: WTX Type trees for JSON form for X12 Data

    Posted Mon March 18, 2019 05:56 AM

    Originally posted by: PaulBrett


    I recommend you do NOT use Typetrees on the JSON side.  Assuming you're using ITX 9.0.0 or higher, you can use the JSON data directly as metadata.

    My suggestion.... mock-up an example JSON data file, containing an example of how you would like the data to look, verify that it is valid JSON using one of the many online parsers available and finally, use this file instead of a Typetree, using the root JSON object in your output card.

    Thank you.

    Paul

    Follow me on Twitter


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: WTX Type trees for JSON form for X12 Data

    Posted Wed June 05, 2019 08:46 AM

    Originally posted by: MarieWallace


    This is what I do and it works well most of the time, although there are some really annoying bugs in how the JSON is generated, where you can frequently get invalid JSON generated by ITX. The biggest causes for invalid output JSON relates to empty loops in the input EDI and/or invalid characters (which isn't really an EDI issue and is more of an issue when generating JSON from other data sources).


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender