How to transform XML TO FLATFILE IN WEBMETHOD IO INTEGRATION?

How to transform XML TO FLATFILE IN WEBMETHOD IO

@kranshi123
There is a Flat File Connector you can use in a webMethods.io Integration FlowService.
Look for documentation here; Custom Connectors - webMethods.io Integration.
If you have XML you can first convert it to an IS Document using the built in service xmlNodeToDocument, then convert the Document to an outbound flat file using convertDocumentToFlatFile.
This is mentioned in the above documentation.
I’d also like to point on the new webMethods.io Integration Developer Guidelines. Start here: webMethods.io Integration Developer Guidelines - Knowledge base / Blog - Software AG Tech Community & Forums
The tech community article wlll take you to a GitHub repo. There is a note in the guidelines about the FlatFile connector: large files ( > 250MB) will cause issues and you will need to use the ffIterator so the data can be processed in “chunks”.

Wayne

1 Like

Here’s a quick example FlowService:

It downloads a sample XML from: https://www.w3schools.com/xml/cd_catalog.xml, converts this to CSV.
You’ll need to configure the account on the http connector when you import before it will run. Its anonymous and you can use the URL above in the account setup

xmlToCSV.zip (9.2 KB)

added the sample here also:
webmethods-io-integration-guidelines/samples.md at main · SoftwareAG/webmethods-io-integration-guidelines (github.com)

2 Likes

Hi Wayne Leishman,

   Thanks for resolution.

Thanks,
Kranshi