Skip to main content
devarnenis2638
devarnenis2638
May 30, 2024
Question

Export Data Store Entity to Excel Smart Service

  • May 30, 2024
  • 10 replies
  • 0 views

Is ther any limit for number of columns/rows for using this smart service(Export Data Store Entity to Excel Smart Service). Nothing is mentioned in documntation regarding this limits

    10 replies

    sriramk5349
    sriramk5349
    May 30, 2024

    Hi [mention:54dbd0c9e16846aba7aa0ad377e6fba0:e9ed411860ed4f2ba0265705b8793d05] ,

    Limit for columns is 50.

    devarnenis2638
    devarnenis2638Author
    May 30, 2024

    The main concern is about row count, any idea on row limit? 

    venkatrea696188
    venkatrea696188
    May 30, 2024

    Export To Excel , It Says in Documentation there is a limit in number of columns .Only 50 columns. And as for the rows , I don't think there is a certain number. But you need to make sure You don't get Time Out error .

    devarnenis2638
    devarnenis2638Author
    May 30, 2024

    Oh ok

    venkatrea696188
    venkatrea696188
    May 30, 2024
    But you need to make sure You don't get Time Out error .

    Go though the link it holds few design considerations and best practices for the better performance of the smart service.

    karumurua531442
    karumurua531442
    May 30, 2024

    hi [mention:54dbd0c9e16846aba7aa0ad377e6fba0:e9ed411860ed4f2ba0265705b8793d05] may I know how many number of rows you are trying to export

    devarnenis2638
    devarnenis2638Author
    May 30, 2024
    1. Present we had 10000 rows, not sure how many we will have in future, the row count will increase day by day 
    karumurua531442
    karumurua531442
    May 30, 2024

    10000 rows is a solid amount, are you exporting it from a table or view? May I know what the count of your columns to be exported is

    jayaprakashr0001
    jayaprakashr0001
    Participating Frequently
    May 30, 2024

    Hi [mention:54dbd0c9e16846aba7aa0ad377e6fba0:e9ed411860ed4f2ba0265705b8793d05] , 

    You can query the data in batches and export the data while looping make sure are updating the data in the same document which is created at start and  Update the cell starting number each time hope it will solve the issue. 

    mikes0011
    mikes0011
    Brainy
    May 30, 2024
    You can query the data in batches and export the data while looping

    This node handles batching inherently.  There should be no need to do manual looping when using it.  That is one of the original reasons they even made it.

    Terms & ConditionsAccessibility statement