Export SQL to Excel plug in

Certified Associate Developer

Good morning,

I'm trying to obtain a report from a grid. I obtain that grid via an SQL query so I thought of using the SQL to Excel Smart Service included in a plug in for Appian Community Edition, but i haven't been able to obtain the desired result due to "java.lang.reflect.UndeclaredThrowableException". My configuration is the following (I filled the fields marked with * as I guess they are the only required ones and also a couple of the not required ones):

-Add as a new sheet=true

-Jndi Name= (I copied and pasted the connection url I'm using in the connected system)

-sheet_name="output"

-sheet number=0

-sql= "EXEC dbo.spRepRevenues '', ''" (which I know works due to the grid showing in the interface using .results)

-document name to create (not required): "probandoplugin" 

-document save directory (not required): "PM Artifacts"

My only guesses are that either the jndi name is wrong (I also tried using the name of the connected system object without success) or some of the not required fields need data. The other fields of that node are:

 Cell keys, cell values, document to overwrite, excel base template, include header row, sheet number to clone and starting cell

  Discussion posts and replies are publicly visible