Example scenario

Order information is published by a third party application as a text file in a header-line detail format. You must transform this information to a Sync.PurchaseOrder XML document and send it to an Infor application. To achieve this:

  1. Create these file format templates in ION:
    • A binary format with the custom noun called 'MyRawData'
    • A Full BOD format with the standard noun 'PurchaseOrder'
  2. Read the text file as 'Sync.MyRawData' BOD using the ION file connector.
  3. Send it to an XSLT mapper step.
  4. Use the decode extension of XSLT mapper to convert the base64 file data to a string.
  5. Use the advanced string manipulation and logical functions of XSLT 2.0 to construct the Sync.PurchaseOrder XML document.

The output of the mapper step is a Sync.PurchaseOrder XML that you can send to the Infor application.