Export SQL to Excel @sathya.srinivasan I have been trying to use the

Hi, can you provide me with details of the SQL that you are trying to execute? Appian tries to automatically recognize the data type and typecast the output for Excel sheet.
Couple of things to check. Are you running a Select on a table or a view? what is the description of the table (desc <table/view name>)
Can you also try executing an sql on a simple table (say, create one with 3 or 4 columns of different types such as int, date, varchar etc) and see if you are able to successfully able to export.

Lastly, I would also recommend you enable debugging to see if you get more info on the log about what's happening.

Hi Sathya

I stripped the SQL right down to just return 2 columns as below
="SELECT [AccountNumber], DateOpened FROM vw_CustomerInformation"
The SQL is executing on a view. The AccountNumber column is an nvarchar(20) and the dateOpened is a datetime.

The values for dateOpened returns but the AccountNumber remains blank.
Thanks

right, can you try providing an alias for AcountNumber and see if that populates the data?

Hi Sathya,
I have just managed to get this to work using CAST and this has worked (example below)

="SELECT CAST(AccountNumber AS varchar(20)), DateOpened FROM vw_CustomerInformation"

Thanks for updating. The plugin depends on the information the JDBC driver provides. I have seen the same issue where not able to get the correct type-cast fails to return values.

Thanks for you help with this Sathya

Hi hayleyw,
I had observed the similar issue with this service in the past wherein the varchar field sometimes doesn't populate in excel using this service.

As a workaround, I changed the type of that field from varchar to nvarchar, and then tried to run this service and it successfully populated my excel !
Hope it helps.