i am getting data from external system which is being displayed on UI(example: 2342;34324;3441), i want to export this data by clicking on button in the form of CSV.
please suggest the right steps.
Thanks in advance.
Discussion posts and replies are publicly visible
Did you already try to search in the documentation or here? This is a very common requirement.
Hi Stefan - i search in the documentation but really dont find this scenario.
please suggest the steps.
Thanks.
Well, then ... I need you to answer a few questions.
Did you search here in the forum and what did you find?
What experience do you have with Appian?
What is the overall use case?
Where is that data coming from?
How much data is that and do you plan to do that export frequently?
yes, i search in forum-
i can see the smartservice called writedatastoretoentity, as per my requirement data is already populated from external service and the same data should be downloaded.
- i am new to appian
- searching with account that return few ids.
- data is coming from external system.
- 50+ rows of data for each account search.
OK. This is still lacking the important level of detail. I recommend to visit these websites to see how to ask a question in a way that allows the community to answer in a efficient way.
https://stackoverflow.com/help/how-to-ask
https://codeblog.jonskeet.uk/2012/11/24/stack-overflow-question-checklist/
I see two options. As I have no idea how much experience you have with Appian and other things, I will try to outline both.
You can trigger a process in the background (a!startProcess) that fetches the data based on the search, and writes that into a text file based on a simple CSV file using the smart service "Text Doc From Template". Then display a link to the user to download that file. And no, there is no way to do this in one step only.
Another option is, to create a GET web API that returns a CSV file. There is a template for this. Pass the search parameter to the API, fetch the data and create text output. The header configuration from the template makes the browser download the file. Use a safeLink component to create a link the user can click to get the data.
Beware! Both options are only good for very small amounts of data and will NOT scale!
Hi, can you please tell me if the data from the external system is being stored in database?
If it is being stored in the database you can use this smart service: https://docs.appian.com/suite/help/23.2/Export_To_CSV_Smart_Service.html
Thanks Stefan for the inputs.
i will try above suggested options.
Hi Harshitha - the data is not being stored in the database. the data is coming from external system.
this is where, i belive ExportToCSV will not the option in this scenario.
Yes, we can not use the Export to CSV smart service. you have to try using https://docs.appian.com/suite/help/23.1/Text_Doc_From_Template_Smart_Service.html
If there is a chance of high volume of data coming in future, I would suggest to use staging table for dumping and then use Export DSE to CSV smart service to generate the output file.You need to perform cleanup activity once export is completed.