Hi Timothy,

Where is the XML stored? You can convert the XML data to CSV using SQL and let that data return as Output of a subroutine (procedure) or Task for example. These can have an API endpoint inside Indicium which you can call. I'm unaware of a native feature for this. We do have the Export API but that is for table data itself, not for stored XML.

@Mark Jongeling The API receives XML as an input variable via the external application. Do i need to return the csv data in an output variable?

Hi Timothy,

That may be an option yes. I think you could also simply use a Select statement for the CSV data. That should result in a single CSV string that the procedure returns.

I'm not so familiar on this topic but I do hope my reply gives some inspiration.

This might also benefit your situation: Case: A message protocol-independent web service (part 1 of 2) | Thinkwise Community (thinkwisesoftware.com)

Hi @Timothy Mentowidjojo,

Did Mark his previous replies help you out?