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
You'll need to use the Export DSE to Excel node prior to dropping the temporary table. Assuming the temporary table looks like what you're wanting, that should be sufficient.
How to create a DSE for a Temporary table which we created using stored procedure execution?
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.
Instead of dropping and recreating the table why not just create it once and map the CDT and just truncate and re-insert the data?
I think Neelesh asking the same question how to map a temporary table with DSE. If you are saying to create a normal table then how he will manage session specific transactions.
This smart service is also deprecated
https://docs.appian.com/suite/help/23.3/Export_To_Excel_Smart_Service.html
Not possible to map a DSE to a temp table AFAIK.
I would simply add a column for the username in the table and use that as a filter for the export. Delete the data linked to the user after the export.
Of course this approach would depend on the amount of users in the system as well as the quantity of data we are talking about but it is pretty much the only approach I can think of that could work.
There is a new version of this plugin, which is not deprecated.
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.