We have a scenario of converting an .xml file to .csv file in OSB.
Can we use the MFL transform for the conversion of XML to CSV? we also need the Headers in CSV file generated.
Please let me know if any one have used this or suggest me an approach if any?
Yes you can convert xml payoad to CSV format using mfl transformation.
It would be better if you can elaborate your scenario.
I have done the reverse a year back !!
My case is we have an xsd with some simple and complex types in it, we want to convert this into CSV along with the headers from the XML.
It could be helpful for me , if you can provide me any example using the MFL.
Find below samples
http://www.javamonamour.org/2010/06/oracle-mfl-tutorial.html It is considered good etiquette to reward answerers with points (as "helpful" - 5 pts - or "correct" - 10pts).
Thanks for the references.
We have created a MFL transformation out of an XSD and developed one proxy service which is having the MFL transformation in the request stage and assign the $body/* to a temp variable.
Now when we tried to test this , we are getting an error as below:
Binary to XML mfl transformation failed for the MFL Resource XX/Resources/XXXXXXX : null
I am able to test the MFL created successfully with comma(,) as a delimiter but when we are trying to test it from proxy service we are getting the above error.
Could you please help us in resovling this?