Skip to main content
arjuns0001
Participating Frequently
July 27, 2022
Question

Export Data store entity to CSV

We are trying to use the Export Data store entity to CSV smart service to generate a CSV which then gets SFTP'ed to an external location. We have a scenario where if there datastore entity doesnt return any rows, the CSV automatically generates a CSV with the header rows and the second row contains the text - "No data available due to empty data source, applied filter/selection criteria, or fields visibility". Is there any way we can have the CSV exported without this text in the second row? I dont find any options in the smart service setup, but if any of you have a non hacky way of working around this scenario it would be great.

    7 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 27, 2022

    Why not just query the DB before the export to check whether there is any data?

      marcelor0001
      marcelor0001
      New Participant
      June 17, 2024

      I have the exact same problem. Querying the DB before, would mean "duplicate" code for the query, and querying twice for the same data. I would like a better solution, ..... but it is what it is.

      konduruc733182
      konduruc733182
      Inspiring
      June 17, 2024

      How is the process being triggered? Is it fine to disable the button/link used to generate this CSV based on a null check performed with minimized query in a local?

      Terms & ConditionsAccessibility statement