Skip to main content
A
arjuns0001
July 27, 2022
Question

Export Data store entity to CSV

  • July 27, 2022
  • 7 replies
  • 0 views

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
    July 27, 2022

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

      marcelor0001
      marcelor0001
      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
      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