topic Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS in Integration, Extension & APIs

Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

master_t — Fri, 28 Apr 2023 14:13:09 GMT

I have an application that uses the .NET SDK (latest version, 16.3.0) that extracts data from some Qlik Sense objects, using the following code:

var obj = app.GetObject<GenericObject>("my-object-id"); var result = obj.ExportData(format, "/qHyperCubeDef", "out.xlsx", NxExportState.EXPORT_POSSIBLE);

This works perfectly with Qlik Sense Enterprise on-premise, however it fails in Qlik Sense SaaS, throwing an exception that says:

Qlik.Engine.MethodInvocationException: Access denied [5]:Access denied(ExportData) at Qlik.Engine.Communication.QlikConnection.AwaitResponseTask[T](T task, String methodName, CancellationToken cancellationToken) at Qlik.Engine.Communication.QlikConnection.AwaitResponse[T](Task`1 task, String methodName, CancellationToken cancellationToken) at Qlik.Engine.GenericObject.ExportData(NxExportFileType fileType, String path, String fileName, NxExportState exportState, Boolean serveOnce)

Any idea why this isn't working? I tested exporting the same object manually from the browser (right click -> download) while connected with the same user I'm using with the SDK and it works correctly, so it doesn't seem to be a permission problem like the error message seems to imply...

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

Øystein_Kolsrud — Fri, 28 Apr 2023 14:31:38 GMT

That method is not available in QCS. May not be obvious at first sight, but there's a actually a remark in the documentation that states so:

https://help.qlik.com/en-US/sense-developer/May2022/Subsystems/NetSDKAPIref/Content/Qlik.Engine.GenericObject.ExportData.htm

It's somewhat more visible in the raw engine API documentation:

https://help.qlik.com/en-US/sense-developer/May2022/Subsystems/EngineJSONAPI/Content/service-genericobject-exportdata.htm

The flow for exporting data is handled differently in QCS, and you need to go through REST APIs to do so. There's a small example illustrating how to utilize the reporting service available here:

https://github.com/kolsrud/qlik_rest_sdk/blob/master/Qlik.Sense.RestClient/Examples/QcsExportExcel/Program.cs

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

master_t — Fri, 28 Apr 2023 16:02:23 GMT

As always, thanks for your quick and precise answers 👍

I'll study the API and see if I can re-implement the same flow. From what I can see from the docs, compared to the Enterprise Edition:

This only supports exporting in XLSX format, not CSV (not a big problem I guess)
This is not synced with the SDK session, so creating a temporary bookmark is required to keep the current selections and variables

Will post my findings when I've tested it. Thanks again for your support 👍

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

master_t — Tue, 02 May 2023 10:55:11 GMT

I've tried this solution and it works, thank you again.

One more question though: I noticed in the documentation that the "type" property in the OutputItem definition supports various values, including csv.

However, it doesn't seem to work, if I try to use "csv" instead of "xlsx" I get the following error:

{ "code": 400, "errors": [ { "code": "REP-400000", "detail": "unsupported output type csv for sense-data-1.0 template", "title": "bad or malformed http request" } ], "message": "bad or malformed http request" }

Is CSV output just not supported at all? Or am I just not building the request correctly?

The documentation is quite strange, because it states:

csv doesn't have csv output

Maybe I'm dumb, but what is that sentence even supposed to mean?

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

Øystein_Kolsrud — Fri, 05 May 2023 12:34:18 GMT

Hmm... I do seem to remember that CSV export wasn't supported, but I don't remember the status of it. And that documentation could use some love and attention I guess...

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

master_t — Fri, 05 May 2023 13:07:07 GMT

Thanks for the confirmation, I suspected it wasn't supported but the "csv" type in the docs made me doubt.

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

AkshayBheda — Wed, 14 Jun 2023 18:25:21 GMT

I am getting when I followed https://github.com/kolsrud/qlik_rest_sdk/blob/master/Qlik.Sense.RestClient/Examples/QcsExportExcel/Program.cs

One or more errors occurred. (400: Bad Request, {"code":400,"message":"Query string not allowed","errors":[{"code":"REP-400000","title":"Query string not allowed"}]} error when authenticate with Session.

Instead of client.AsApiKeyViaQcs(apiKey); I used client.AsExistingSessionViaQcs(qcsSessionInfo); since I have different section access for different users, i want to export only data related to those users. Also, is there any documentation of bookmarks?

Also if I use AsJsonWebTokenViaQCS

i am getting One or more errors occurred. (400: Bad Request, {"code":400,"message":"bad or malformed http request","errors":[{"code":"REP-400020","detail":"The issuer is not compatible with a non browser like request" .. Error.

We currently moved from Qlik On-prem to Qlik Cloud and that has resulted in Broken export functionality, We were using genericObject.ExportData(NxExportFileType.EXPORT_OOXML) but for that i am getting Access Denied Error.

Re: Exporting data with the .NET SDK doesn't work in Qlik Sense SaaS

DBIT — Mon, 07 Apr 2025 14:01:51 GMT

Just FYI your examples no longer appear to exist or the links are broken.