topic Re: Error in exporting chart to Image or PDF using Qlik Sense API in Integration, Extension & APIs

Error in exporting chart to Image or PDF using Qlik Sense API

ajaykakkar93 — Sat, 16 Nov 2024 06:46:37 GMT

Hello Everyone,

i am facing a issue in November 2018,

i am not able to export as PDF or IMAGE, but i am able to export the data to excel i need to implement other export feature as well it will be great if you and others can help me on this issue.

Same error is coming for IMG also

My simple test code

var prefix = window.location.pathname.substr(0, window.location.pathname.toLowerCase().lastIndexOf("/extensions") + 1);
var config = {
	host: window.location.hostname,
	prefix: prefix,
	port: window.location.port,
	isSecure: window.location.protocol === "https:"
};
require.config({
	baseUrl: (config.isSecure ? "https://" : "http://") + config.host + (config.port ? ":" + config.port : "") + config.prefix + "resources"
});
require(["js/qlik"], function(qlik) {
	qlik.setOnError(function(error) {
		$('#popupText').append(error.message + "<br>");
		$('#popup').fadeIn(1000);
	});
	$("#closePopup").click(function() {
		$('#popup').hide();
	});
	//callbacks -- inserted here --
	//open apps -- inserted here --
	var app = qlik.openApp('APP-ID', config);
	//get objects -- inserted here --
	// test
	app.getObject('QV01', 'OBJID').then(function(visual) {
		//console.log(visual);
		$("#exportChart").show().click(function() {
			//Working Good
			/*
			visual.exportData().then(function(result) {
				console.log('Data download link: ', result);
			});
			*/
			//Not Working IMG
			/*
				var Imgsettings = {
					imageType: 'png',
					height: 200,
					width: 300
				};
				visual.exportImg(Imgsettings).then(function(result) {
					console.log('Image download link: ', result);
				});
			*/
			//Not Working PDF
			var Pdfsettings = {
				documentSize: "A4",
				aspectRatio: 2,
				orientation: "landscape"
			};
			visual.exportPdf(Pdfsettings).then(function(result) {
				console.log('Pdf download link: ', result);
			});
			console.log("Exporting");
		});
	});
	//create cubes and lists -- inserted here --
});

Can some one help me on this & please if i am wrong please explain me what was wrong.

Regards,

Ajay Kakkar

Re: Error in exporting chart to Image or PDF using Qlik Sense API

gamaltawaf — Fri, 25 Jan 2019 13:35:21 GMT

I am facing the same issue.

Thanks Ajay for Explaining it in plenty of details.

Can anyone help with this?

Thanks

Re: Error in exporting chart to Image or PDF using Qlik Sense API

gamaltawaf — Fri, 25 Jan 2019 15:22:46 GMT

Hello Ajay,

I found a solution for this. So the issue is you need to ask the visulatisation api to get the object take a look at code below.

var app = qlik.openApp('app-id');
app.visualization.get('object-id').then( function(vis) { 
   vis.exportPdf().then(function (result) {
        console.log('PDF download link: ', result);
    }); 
});

Re: Error in exporting chart to Image or PDF using Qlik Sense API

ajaykakkar93 — Tue, 29 Jan 2019 07:17:20 GMT

Still getting this error

Re: Error in exporting chart to Image or PDF using Qlik Sense API

gamaltawaf — Tue, 29 Jan 2019 14:43:30 GMT

This seems to have to do with your access origin.

Sorry, I can't help with that.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

lambdaman — Tue, 27 Apr 2021 10:27:04 GMT

Hi,

I do manage to get a PDF export link, but the URL is not accessible.

app.visualization.get('aYtxmq').then(function(vis){ vis.exportPdf().then(function (result) { console.log('Image download link: ', result); }); });

This results in

Image download link: https://my-qlik.website.com:443/openproxy/tempcontent/50481ec5-4c17-4d53-ac36-6f7dfbc68b4f/fd6e31961187425bbb3bc3648e4988f6.pdf?serverNodeId=8372dd45-3070-4263-ad62-ca1926459c18

But when I open that URL I simply get the message

The requested resource cannot be found.

Any idea what might be going wrong?

Please note that "https://my-qlik.website.com:443/openproxy" does indeed work and 'openproxy' is a virtual proxy set up with anonymous access that functions correctly.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Thu, 03 Apr 2025 14:35:50 GMT

Trying to do the same thing. Hoping you can help. What language is this please? Can this be done in C# .Net?

Thanks.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

Øystein_Kolsrud — Fri, 04 Apr 2025 10:28:36 GMT

Do you want to export to a PDF? Is it for cloud or a client managed solution? There's an example for how to do that for QCS in C# here:

https://github.com/kolsrud/qlik_rest_sdk/blob/master/Qlik.Sense.RestClient/ExamplesQcs/ExportPdf/Program.cs

The library is available on NuGet:

https://www.nuget.org/packages/QlikSenseRestClient/

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Sun, 06 Apr 2025 00:13:53 GMT

I will have a look at this thanks!

We have Qliksense Enterprise, so client. PDF may work but ideally PNG anything that can be used in a report. Is this possible in C# as a PNG or JPG? I have seen others say they have done it but no code examples or descriptions of how.

Thanks again!

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Sun, 06 Apr 2025 17:17:23 GMT

Tried using this method and I'm getting a response saying "403: The initial authentication request must be a "GET" request in order to be redirected to the authentication module."

Bit stumped.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

Øystein_Kolsrud — Mon, 07 Apr 2025 09:25:38 GMT

When you are not authenticated, only GET requests are accepted. They will redirect you to the right authentication flow and after successful authentication you valid get a valid cookie. Once you have that, you can do other request. The QlikSenseRestClient library should do that automatically though. Maybe you can share your code and I can have a look at what goes wrong? If you are calling the printing service, then it might be that you simply need to call the qrs service with a GET request first. You could try adding something like this:

client.Get("/qrs/about");

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Tue, 08 Apr 2025 10:26:03 GMT

var baseAddress = new Uri("https://<senseserverURL>/qrs/about"); var cookieContainer = new CookieContainer(); using (var handler = new HttpClientHandler() { UseCookies = true, AllowAutoRedirect = true, CookieContainer = cookieContainer }) using (var client = new HttpClient(handler) { BaseAddress = baseAddress}) { X509Certificate2 Cert = new X509Certificate2("C:\\client.pfx"); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Add("User-Agent", "Windows"); client.DefaultRequestHeaders.Add("X-Qlik-User", @"UserDirectory=internal;UserId=sa_repository"); client.DefaultRequestHeaders.Add("X-Qlik-xrfkey", xrfkey); handler.ClientCertificates.Add(SenseCert); var getResult = await client.GetAsync(baseAddress);

Now using the HTTPClient in c# instead.

I have replaced the actual server URL with <senseserverURL> for security.

Currently getting a 401: unauthorised response back from the server.
Thanks.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

Øystein_Kolsrud — Tue, 08 Apr 2025 10:53:16 GMT

Getting all those headers and everything right is quite hard when you use the HttpClient class directly. And since you are doing a direct connection using certificates, you should specify the port for the repository which is 4242.

I'd really recommend you try out some library to do this for you though. That way you don't have to worry about all the nitty gritty details of the authentication flow which can be quite convoluted. With the QlikSenseRestClient library your code would look like this:

var client = new RestClient("https://<senseserverURL>/");
var certs = RestClient.LoadCertificateFromDirectory("C:\\client.pfx");
client.AsDirectConnection("internal", "sa_repository", certificateCollection: certs);

var getResult = await client.GetAsync("/qrs/about");

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Wed, 09 Apr 2025 14:25:11 GMT

Great. How can I add a custom header to a rest client object using this? Seems to be the only thing not provided for in examples?

Re: Error in exporting chart to Image or PDF using Qlik Sense API

Øystein_Kolsrud — Thu, 10 Apr 2025 10:46:29 GMT

You should be able to do like this:

client.CustomHeaders["myheader"] = "value";

But what do you need a custom header for? Just curious.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Thu, 10 Apr 2025 11:05:06 GMT

That's great thanks! It's been a while since I did any C# so I'm more than a bit rusty. I don't really recall assigning values this way.

Why do I need to? The API I'm interacting with requires additional headers as above. I can't work out how to get them in any other way. I have been able to establish a connection with POSTMAN but was getting the same error as my C# program without the headers being added, so this should hopefully resolve the issue!

Thank you again for the help and direction.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

Øystein_Kolsrud — Thu, 10 Apr 2025 11:42:19 GMT

I'm not sure what you mean here. How would you have preferred to set the header?

Or do you mean the language construct used? The CustomHeader property is a dictionary. So it's assigning a value in the dictionary.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Thu, 10 Apr 2025 12:13:53 GMT

Yes. Only real compiled language I have worked with in the last decade is objective C, and a little Java. Still getting used to C# again.

Thanks again.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

DBIT — Fri, 11 Apr 2025 13:23:05 GMT

After scratching my head, getting 405 errors (method not allowed) from server when requesting export of the PDF after finally getting this together, it seems this only works for Qlik Cloud? I'm interacting with Enterprise installed on an on premises server, so seems like I've been going down the wrong rabbit hole.

Do you know any way to interact with the Enterprise APIs in a similar way? I'd have thought the APIs would have been fairly close in terms of functionality across the board being extremely similar products but apparently not.

Re: Error in exporting chart to Image or PDF using Qlik Sense API

Øystein_Kolsrud — Sat, 12 Apr 2025 09:11:07 GMT

You mean that library? Or the APIs for printing? The library handles both Client Managed and QCS. You can find examples for both in the repo for that library:

https://github.com/kolsrud/qlik_rest_sdk/tree/master/Qlik.Sense.RestClient

Printing is handled very differently in the two though, so the flow for exporting a PDF will require usage of two totally different sets of APIs. The APIs for doing this in Client Managed are not public.