Solved

API| Export XML as CSV format

  • 17 May 2023
  • 5 replies
  • 99 views

Userlevel 1
Badge +4

Hey all,

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

icon

Best answer by Mark Jongeling 6 June 2023, 19:31

View original

This topic has been closed for comments

5 replies

Userlevel 7
Badge +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.

Userlevel 1
Badge +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?

Userlevel 7
Badge +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.

Userlevel 7
Badge +23

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

Userlevel 5
Badge +8

Hi @Timothy Mentowidjojo,

Did Mark his previous replies help you out?