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:
- 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'
- Read the text file as 'Sync.MyRawData' BOD using the ION file connector.
- Send it to an XSLT mapper step.
- Use the decode extension of XSLT mapper to convert the base64 file data to a string.
- 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.