We are using the export from Exact Online as described on Laad Exact Online in Qlik Sense en Tableau. However, for use of loading with SQL Server bulk insert we would prefer a CSV format with customizable record and line separator, and a header row.
The for csv and for excel clause will becomes available in releases 22.0.16 and higher. On Invantive Cloud they should be available in production within two weeks. Another topic forum includes samples: CSV genereren vanuit Invantive Cloud en SQL