Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
catalin
Partner - Contributor III
Partner - Contributor III

.NET SDK: ExportDataAsync method to CSV not working

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

Labels (2)
1 Reply
Øystein_Kolsrud
Employee
Employee

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-ExportDa...

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