Export SQL to excel Smart Service Not returning first Column

Question

Hi, 
 1. We are suing 'Export SQL to Excel' smart service. however for 2 column and 4 rows data. it is not returning first column in excel. 
 2. But it does returns the header of the first column 
 3. Also the SQL we are using is store procedure 
 
 Thanks 
 Ajinkya

chetany · Answer

Just check a few things: 1. Run the stored procedures with the correct parameters(is your stored proc taking some parameters?) in database (outside Appian). Check if you are getting the results. Check the datatype of each column, you may want to check the stored procedure definition to see what is datatype of each column in resultset being returned. 2. Then in Appian - check that the parameters are being passed correctly to stored proc (assuming your stored proc is taking params as input). 3. Does the smart service need some CDT input? If yes, Check if the CDT being used is having correct column datatypes (these should match the column datatypes in Appian and the database result set mentioned in point 1). By the way, Appian is now recommending that you should use "Export to CSV" smartservice docs.appian.com/.../Export_To_Excel_CSV_Smart_Service.html rather than the "Export to SQL" smart service. This new smart service is provided since 18.1 and is baked into the Appian platform. It has advantages like you can use a!queryEntity on it, specify filters, pagination etc. So - you can control how much data you want to get from it.