I want to export grid data obtained from stored procedures to Excel without the need to create any CDTs (I have different tables from different stored procedures)
I'm trying to use Export SQL to Excel in a Process Model in order to do this. I can provide it the query (which, once again, contains a stored procedure in almost all cases).
However, when I debug it, I always get the same error, java.lang.reflect.UndeclaredThrowableException
My configuration at this momento is the following:
-Node inputs
Cell_Keys (empty)
Cell_Values (empty)
Add_as_new_sheet=true
Document_name_to_create="SQL_Excel"
Document_save_directory="PM Artifacts"
Document_to_overwrite (empty)
Excel_base_template="PM_blankexcel" (a blank Excel file created following a kind of step by step made for this situation some years ago in Appian community discussions)
Include_header_row=true
Jndi Name= (here I literally pasted the Connection URL I used in the Connection System objects, which works)
Sheet_name="holaquetal"
Sheet_number=0
Sheet_number_to_clone (empty)
Sql=pv!query (which I know works)
Starting_cell="B2"
-Node outputs
Output_document: Result AC!output_document is stored as output_document
Any help would be greatly appreciated.
Thank you,
Francisco
Discussion posts and replies are publicly visible