topic Re: Export Data using RestClient gives forbidden request in Integration, Extension & APIs

Export Data using RestClient gives forbidden request

PGeorge — Thu, 06 Jul 2023 14:15:42 GMT

I am trying to export data in excel using the RestClient approach documented here by Øystein_Kolsrud: https://github.com/kolsrud/qlik_rest_sdk/blob/master/Qlik.Sense.RestClient/Examples/QcsExportExcel

var appId = "app-ID"; var objectId = "object-ID"; var client = new RestClient("wss://test.eu.qlikcloud.com"); client.AsApiKeyViaQcs("API_KEY"); var requestBody = CreateRequestBody(appId, objectId); var httpRsp = client.PostHttpAsync("/api/v1/reports", requestBody); var httpResult = httpRsp.Result; var statusLocation = httpResult.Headers.Location; var dataLocation = AwaitExportCompletion(client, statusLocation.AbsolutePath); var dataLocationUri = new Uri(dataLocation); byte[] exportBytes = await client.GetBytesAsync(dataLocationUri.AbsolutePath); return File(exportBytes, "application/xlsx", "out.xlsx");

When in httpRsp.Result i get the following error:

HttpRequestException: 403: Forbidden, {"code":403,"message":"You are not entitled to perform that operation. Export capability is off.","errors":[{"code":"REP-403026","detail":"Reporting capability is off","meta":{},"title":"You are not entitled to perform that operation. Export capability is off."}

Is there any configuration I might be missing and i get this error?

I have also tried the ExportData approach from .NET SDK which is incompatible from what i read.

Thanks in advance.

Re: Export Data using RestClient gives forbidden request

jprdonnelly — Thu, 06 Jul 2023 19:45:41 GMT

@PGeorge - the error message you are seeing is related to how exportData differs from Client-Managed Qlik Sense and Qlik Cloud.

In Client-Managed Qlik Sense Enterprise, the Engine handles the data exports. In Qlik Cloud, they are handled by the Reporting Service. The error message is indicating that the Reporting capability is off, which most likely indicates that your subscription needs to be updated to support Reporting services.

Re: Export Data using RestClient gives forbidden request

PGeorge — Fri, 07 Jul 2023 09:22:40 GMT

Thanks for your prompt answer.

Are the attached options related to the subscription package you are referring to?

Because I can't find any other details to update to Reporting services level.

Re: Export Data using RestClient gives forbidden request

Dave_Channon — Fri, 07 Jul 2023 12:39:42 GMT

Hi @PGeorge

Replying before @jprdonnelly wakes up...

Here's an example of using the reports API in Qlik Cloud to generate outputs: https://qlik.dev/embed/generate-reports/reporting-api-samples

You are able to generate single object outputs using this method, and the reports API also supports our Reporting Service which helps you generate compositions of objects and sheets into a single file (both are covered in the link above).

Re: Export Data using RestClient gives forbidden request

PGeorge — Fri, 07 Jul 2023 14:43:20 GMT

Very informative and helpful link.

I followed the link's instructions and created a POST request which I sent through Postman and the response remains the same as above.

{ "code": 403, "message": "You are not entitled to perform that operation. Export capability is off.", "errors": [ { "code": "REP-403026", "detail": "Reporting capability is off", "meta": {}, "title": "You are not entitled to perform that operation. Export capability is off." }, { "code": "REP-403026", "detail": "Reporting capability is off", "meta": { "appErrors": [ { "appId": "app-id", "method": "CheckExportCapabilities", "parameters": { "appID": "app-id", "tags": "[api.public]", "taskID": "task-id", "tenantID": "tenant-id", "userID": "user-id" } } ] }, "title": "forbidden request" } ] }

Which part of my subscription package do I have to update, since I am not entitled to perform the operation?

Re: Export Data using RestClient gives forbidden request

PGeorge — Wed, 12 Jul 2023 14:39:03 GMT

@jprdonnelly @Dave_Channon did you have a chance to look into it? Thanks

Re: Export Data using RestClient gives forbidden request

Dave_Channon — Wed, 12 Jul 2023 18:26:05 GMT

@PGeorge , did a little digging, could it be that you're using a Qlik Sense Business, rather than Enterprise subscription? It seems we might restrict which APIs and services the former can access.

Re: Export Data using RestClient gives forbidden request

PGeorge — Thu, 13 Jul 2023 14:24:41 GMT

@Dave_Channon I will check my subscription options and come back to you.