We are trying to use "Export SQL to Flat File" smart service to run a sql query and export a CSV file.
But this smart service has been deprecated, and there is no similar smart service which can take sql query and output the CSV file as per our findings.
Please guide us, Is there any smart service does the same kind of operation?(with no much changes on configuration).
or What is the best way to replace this smart service with any available/suitable smart service? .
(Note: There is a smart service "Export SQL To Excel" but we need output as "CSV" , moreover we can't see any option to change file extension here.)
Thanks
Discussion posts and replies are publicly visible
Hi vasanthar,
Not sure if this suits your requirement.
If you already have Data store entity or can create one, we can use Export Data Store Entity to CSV Smart Service. https://docs.appian.com/suite/help/20.3/Export_To_CSV_Smart_Service.html
This allows you to have Selection, Aggregation and Filters as well.