Skip to main content
Solved

API| Export XML as CSV format


Forum|alt.badge.img+4

Hey all,

is it possible to make an api(procesflow) request and export a xml and get a csv file back?

Best answer by Mark Jongeling

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.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

5 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23

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.


Forum|alt.badge.img+4

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


Mark Jongeling
Administrator
Forum|alt.badge.img+23

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
Administrator
Forum|alt.badge.img+23

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Hi @Timothy Mentowidjojo,

Did Mark his previous replies help you out?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings