Hi Everyone,
Currently there are a total of 100 columns in a table and I am using export data store entity to excel smart service to export data into excel.
Since we cannot export more than 50 columns, I am using 3 sheets in same excel to get export data.
Is there any other way to export entire 100 columns data into excel without splitting them.
Thanks
Discussion posts and replies are publicly visible
Hi, There is a way where you can create a web api to generate csv file and yes you can use 100 columns . After creating web api , you can use the url of web api to download the link.
Hi, Thanks for the response, I tried using web API it worked. But, Can we pass rule inputs to web API and also can we implement batching here because we have a large data over here.
Yes , you can do that , but you would need to create an expression rule where you can configure your filter and paging.
Okay, so I need to pass filters data from interface to webAPI. Is that possible?
yes, create an exp rule first and then call this exp rule in the web api. that's how you can do
That's fine, but when we call the expression rule into API where can we give the values, the values should come from an interface to API, API to expression rule.
yes , that's correct . how do you want to use this export?
I want to download this in an interface. The interface will have filters, based on selected filters, I want the data to be exported.
okay, in this case you would need to pass the filter parameters into web api and construct a downloadable link out of it .some thing like below,
"https://example.appiancloud.com/suite/webapi/example?queryParameter="
Okay, How can we pass rule input from interface? Can you please guide us?