Hey all,
is it possible to make an api(procesflow) request and export a xml and get a csv file back?
Solved
API| Export XML as CSV format
- Vanguard
- 22 replies
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.
This topic has been closed for comments
+23Hi 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.
- Vanguard
- 22 replies
+23Hi 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.
+23This might also benefit your situation: Case: A message protocol-independent web service (part 1 of 2) | Thinkwise Community (thinkwisesoftware.com)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.