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
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.
a completely new (different) plug-in, that is.