XML to Flat File OSB using MFL and Xquery

XML to Flat File in OSB using MFL and XQuery Tranformation

We will use the previous example and continue from there. Link to the previous exercise

1. We will use ECLIPSE to create the MFL and the XQuery file.

2. Right click on the Project > New > MFL. The MFL file should result to the flat file. Below are the snapshots.

VehicleCollection will be the root element. Vehicle will have group Occurance Unlimited.

vin, model, year, cost will have ; as delimiter and status will have \n as delimiter.

3. Now the next step is to create a xQuery Transformation. Source will be XML, Target will be non-XML

4. Now let us create a new Business Service

In General Configuration select Messaging Service.

In Messaging tab, select the MFL file that we created. Save, deploy and test the service.

The content of the file will be as below.

126;Honda;2010;10000;AVAIL