Skip to main content
S
sairupak7222
February 8, 2022
Question

Limitations of Export data store entity to excel

  • February 8, 2022
  • 12 replies
  • 0 views

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

    12 replies

    gopalk2865
    gopalk2865
    Participating Frequently
    February 8, 2022

    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.

    S
    sairupak7222Author
    February 8, 2022

    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.

    gopalk2865
    gopalk2865
    Participating Frequently
    February 8, 2022

    Yes , you can do that , but you would need to create an expression rule where you can configure your filter and paging.

    Terms & ConditionsAccessibility statement