.NET SDK: ExportDataAsync method to CSV not working

catalin — Sat, 16 Nov 2024 02:45:36 GMT

Hello, dear Qlikers!

I have a rather odd behaviour and maybe I am missing something out. I have a generic object ( a pivot table ) for which I want to export its data in CSV_C format.

If I export its data as OOXML, everything works as expected. But when I try to export it as a CSV_C, it outputs an empty file, just with headers.

The seemingly empiric code is as follows:

Dim gen_obj As IGenericObject = Await app.GetGenericObjectAsync(objectid) Dim result As ExportDataResult = Await gen_obj.ExportDataAsync(NxExportFileType.EXPORT_CSV_C, "/qHyperCubeDef", NxExportState.EXPORT_POSSIBLE)

Someone has any idea why?

I appreciate it!

Catalin

Re: .NET SDK: ExportDataAsync method to CSV not working

Øystein_Kolsrud — Wed, 15 Apr 2020 11:52:47 GMT

My guess is that this is a limitation of the CSV export functionality that relates to the type of the hypercube being exported. There are some note on this in the top section of the documentation for the endpoint:

https://help.qlik.com/en-US/sense-developer/April2020/APIs/EngineAPI/services-GenericObject-ExportData.html

It doesn't specifically list pivot tables though, but I think they are problematic to export to CSV format.

topic Re: .NET SDK: ExportDataAsync method to CSV not working in Integration, Extension & APIs

.NET SDK: ExportDataAsync method to CSV not working

Re: .NET SDK: ExportDataAsync method to CSV not working