Hi @Timothy Mentowidjojo,

Did Mark his previous replies help you out?

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

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.

@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,

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.