I am trying to get a temporary table data by executing a stored procedure. This stored procedure is responsible to create a temporary table, insert some hard cored values (id and name as fields) and then dropping the temporary table. Before dropping Inam using select all statement so to get my data before dropping the table. But somehow I got the data which is similar to this,
{
{ id = 1, name = Abc },
{ id = 1, name = Pqr },
{ id = 1, name = Uvw },
{ id = 1, name = Xyz },
{ id = 1, name = Ijk }
}
It looks like 2D list of map. can anyone help me in binding the data to excel using Export DataStoreEntity to Excel and Execute Stored Procedure smart services.
Discussion posts and replies are publicly visible
If this is the case I would prefer using sql to excel smart service. Since your number of columns are less, you can simply call that procedure in the sql input of the smart service.
https://docs.appian.com/suite/help/23.3/Export_To_Excel_Smart_Service.html
This needs DSE as one of the inputs and I am unable to create a global temporary tables, atleast, to link with a DSE. The only possible approach possible AFAIK is to create a table which is not temporary to use the mentioned smart service.