topic Re: .NET SDK: downloading exported data in Integration, Extension & APIs

.NET SDK: downloading exported data

master_t — Mon, 16 Apr 2018 10:10:11 GMT

Hello

I'm using the .NET SDK to connect to QlikSense server using certificate authentication, like this:

//Connect to QlikSense server

senseServerLocation.AsDirectConnection(

"myuserdir", //User directory

"administrator", //UserID (this user is RootAdmin)

false,

x509collection //Certificate

);

all goes correctly, and I can manipulate apps and objects. However, later, I'm trying to export data from an object, like this:

var exportResult = table.ExportData(NxExportFileType.EXPORT_OOXML, @"/qHyperCubeDef", "out.xlsx", NxExportState.EXPORT_ALL);
var downloadUrl = "https://mysenseserver/" + exportRes.Url.ToString();

However, if I download the url using WebClient (or similar class) it just returns the QlikSense login page, since I'm not authenticated. But since I'm using certificate to authenticate, I don't have username/pass to authenticate properly. How do I download the exported file in this case??

Re: .NET SDK: downloading exported data

Øystein_Kolsrud — Tue, 17 Apr 2018 07:39:35 GMT

I'm not sure if this will work, but I have this rather experimental project for connecting to the QRS:

https://github.com/kolsrud/qlik_rest_sdk

There you can configure a connection using an "AsDirectConnection" approach similar to the one used for the SDK:

https://github.com/kolsrud/qlik_rest_sdk/blob/master/Qlik.Sense.RestClient/RestClient.cs#L38

I've never tried if it works when you just want to download that URL, but if you're lucky, then it might at least give you some clues as to how it can be done.

Re: .NET SDK: downloading exported data

YuroB — Tue, 15 Sep 2020 06:04:41 GMT

Hi to all !!

After 2 years I have the same issue.

Connected with QlikSense using AsNtlmUserViaProxy method ....I can manage hypercubes data with no problem.

But ...when I try to export data from a GenericObject (a sheet's table) using WebClient (with certificate generated with QMC) "it just returns the QlikSense login page" as master_t said.

Any help ...please ?

Re: .NET SDK: downloading exported data

bramkn — Tue, 15 Sep 2020 06:32:17 GMT

master_t exports using the engine SDK. And then he downloads the export using the Rest SDK @Øystein_Kolsrud provided.

You can use the same form of authentication for both. So In your case you kan use Ntlm authentication method with the Rest, you don't need to use the certificate.

Re: .NET SDK: downloading exported data

YuroB — Tue, 15 Sep 2020 07:20:20 GMT

Thank you for your reply.

So...are you talking about the Qlik.Sense.RestClient ?

Re: .NET SDK: downloading exported data

YuroB — Tue, 15 Sep 2020 09:04:02 GMT

This is the test I made:

Dim Nc As New Net.NetworkCredential(<user>, <password>, <domain>)
Dim Rc As New RestClient(<server url>)
Rc.AsNtlmUserViaProxy(Nc, False)

If Rc.Authenticate Then

Txb.Text = Rc.Get("/qrs/about")

End If

Rc = Nothing

....then Txb (is a textbox) text property contais the html source of the image GetError.

Why ?

Thank you.

Re: .NET SDK: downloading exported data

YuroB — Tue, 15 Sep 2020 13:09:54 GMT

Sorry guys .....I forget to add the virtual proxy.

Instead of

Dim Rc As New RestClient(<server url>)

I have to use

Dim Rc As New RestClient(<server url>/<virtual proxy name>)

Now Rc.Get("/qrs/about") returns the right infos !!

Now I have the ExportDataResult of ExportData method ...and I suppose that I have to run a RestClient Get method: what's the parameters to use to dowload exported data into a file ?

Thank you again !!!

Re: .NET SDK: downloading exported data

Øystein_Kolsrud — Tue, 15 Sep 2020 13:20:01 GMT

The latest version of the RestClient contains a method called "GetBytes" for downloading binary data. So try something like this:

var result = obj.ExportData(NxExportFileType.EXPORT_OOXML); var data = client.GetBytes(result.Url); File.WriteAllBytes("myfile.xlsx", data);

Re: .NET SDK: downloading exported data

YuroB — Tue, 15 Sep 2020 14:00:42 GMT

That's the reason why ....I don't have the latest one !!!

I downloaded some days ago the 1.2 release (for .Net)...it's not the latest one ...I suppose.

Re: .NET SDK: downloading exported data

Øystein_Kolsrud — Tue, 15 Sep 2020 14:02:46 GMT

No, I uploaded that one earlier today 🙂 Fresh off the press!

Re: .NET SDK: downloading exported data

YuroB — Tue, 15 Sep 2020 15:00:52 GMT

Upgrade to 1.3 and....now the file is inside my folder !!!

Great.

Now I have to work with filters ...

Thank you Yko !!!

Re: .NET SDK: downloading exported data

YuroB — Mon, 21 Sep 2020 12:16:01 GMT

'still here 😞 !!!

Opening (with Ms Excel) the file generated by:

Edr = Go.ExportData(NxExportFileType.EXPORT_OOXML, "/qHyperCubeDef")
Data = Rc.GetBytes(Edr.Url)
File.WriteAllBytes("c:\temp\myfile.xls", Data)

it returns an " ...format and extension don't match ..." alert.

If I reply Yes Excel opens file with all data inside.

Is there a workaround ?

Thank you !!!

Re: .NET SDK: downloading exported data

YuroB — Mon, 21 Sep 2020 13:21:42 GMT

Since I have Excel 2016 ....just use xlsx extension !!!
I works !!!

Re: .NET SDK: downloading exported data

ar5 — Tue, 01 Oct 2024 14:25:03 GMT

Any insight into how can I export current selections while exporting a dataset (like tables)? We are using capability API. But was wondering if I can accomplish the goal with other APIs if not possible with capability. Thank you.

app.visualization.get(attrs.id).then(function (vis) {

vis.exportData().then(function (link) {

console.log("Excel Download link", link);

window.open(link);

var title = modal.layout.qMeta.title;

$("#download_file").attr("href", link);

$("#download_file").show();

});

The output should be like:

Field : Dim1 Selected values: a, c

{dataset}

Re: .NET SDK: downloading exported data

Øystein_Kolsrud — Tue, 01 Oct 2024 14:53:39 GMT

I think you will have a better chance of getting a good answer to this question if you post it in a new thread.