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.
Yes I completely agree with you, there are few limitations with this plugin. I see for this use case this plugin is the only option. If the number of columns are more than 50 and row count is more than 20k(this totally depends on the heap memory of your env), i wont recommend using this plugin
Somehow I am able to get the data in json or map format which I can use connected systems to generate an excel file based on the data provided but my concern is with the smart services only.
It is appreciated if you can share the corresponding document or the reference url of the plugin you specified. Thanks.