Export SQL TO EXCELL Issue

Question

Dears ,

i'm facing an issue when i try to Export from SQL to Excel the code doesn't have any issue but once i clock export thee page 1 appear (check attachment Figure 1)

My Code in attachment in document

the database doesn't contain any Null data also , the plugin installed to My server.

please could you help me to find what is the error.

Thanks....

vijayana · Answer

I have faced the same issue. The workaround I have done and worked for me 
1) Use getdatasubsetdownloadlinkfromprocess 
2) Create a process model 
3) Process Parameter - Input(text) - Unique column value which you can query from table 
4) Add a script task 
5) Create the below mentioned in the Data - Input 
	fieldNames (Better create a constant and update the value) 
	fieldLabels (Better create a constant and update the value) 
	dataSubset (Convert the input using a!fromJson(input) and query using this input 
	fileName (whatever you want) 
6) In the output node, convert the dataSubset data to ExportableDataSubset using the AC input 
7) Create a constant for process model 
8) When calling getdatasubsetdownloadlinkfromprocess 
	give process constant and give input as a!toJson(input) 
 
Note: There is a size limitation of input data. If you get any error try to limit the input size 
 community.appian.com/.../download-datasubset-plugin