topic Re: QlikSense .NET SDk: how to retrieve filtered data from a table? in Integration, Extension & APIs

QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Sat, 16 Nov 2024 05:46:22 GMT

I am using a QLIK table within a sheet. It has 20 records. The user filters the data now and it has 5 records now.

Can I use QLIK API from .net to get this 5 records? I am able to get 20 records using genericObject.GetHyperCubeData methods, but not sure it is possible to get filtered data?

If this is possible, can I get filtered data for any object (pivot-table, filter-pane etc) ?

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

Øystein_Kolsrud — Thu, 23 May 2019 08:37:19 GMT

Selections only exists with a session, so to make selections visible for your SDK access, you need to make sure you connect to that same session as the one the user was connected to when doing the filtering. This is a related thread here on Community that might be of interest to you:

https://community.qlik.com/t5/Qlik-Sense-Integration/NET-SDK-Sharing-session/m-p/1520370

An example of how to connect to the session used by the Qlik Sense Client can be found in this comment:

https://community.qlik.com/t5/Qlik-Sense-Integration/NET-SDK-Sharing-session/m-p/1520370/highlight/true#M9698

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Wed, 05 Jun 2019 16:06:14 GMT

I am able to connect to Qlik, but unable to see the same data that the user can see. Can you please guide me to any code sample that I see?

I tried using AsNtlmUserViaProxy and AsDirectConnection. I am also attempting setting cookies , but no success.

location.CustomUserCookies.Add("X-Qlik-Session-dev", "XXXXXX");

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

Øystein_Kolsrud — Fri, 07 Jun 2019 10:29:21 GMT

You'll have to connect through the proxy to be able to share session with the Qlik Sense client, so a direct connection won't work.

If you post the code you use for doing the connection then perhaps we might be able to identify if there is anything missing.

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Fri, 07 Jun 2019 15:46:34 GMT

See below the code I have.

I am able to get rowCount = 21. But I am looking for rowCount = 3 because I applied the filters on a partcular field. This means that the .Net client is unable to share the same session as the web browser.

private static ILocation SetupConnection()
{

_qlikSenseServerUri = new Uri("https://qlik.myserver");

ILocation location = Location.FromUri(_qlikSenseServerUri);

location.AsNtlmUserViaProxy(true, null, false);

return location;
}

private HttpResponseMessage GetQlikData(ILocation location)
{
try
{

IAppIdentifier appId = location.AppWithIdOrDefault("1786433e-8c76-4c24-a21d-2d51c9888ba0");
ISession session = Session.WithApp(appId, SessionType.Default);
IHub hub = LocationExtensions.Hub(location, session);
App app = hub.OpenApp(appId.AppId);

var objectList = app.GetObjects(new NxGetObjectOptions() { IncludeSessionObjects = true, Types = new List<string>() { "table" } });

var genericObject = app.GetGenericObject("YpBmJAY");

var cellsPage = new NxPage { Top = 0, Height = 100, Left = 0, Width = 100 };

IEnumerable<NxDataPage> pages = genericObject.GetHyperCubeData("/qHyperCubeDef", (new[] { cellsPage }));
var rows = pages.FirstOrDefault().Matrix;

int rowCount = rows.Count();

}

catch (CommunicationErrorException cex)
{
Console.WriteLine("Can not connect to Qlik Sense instance, check that Qlik Sense is running." + Environment.NewLine + cex.Message);
}
catch (Exception ex)
{
Console.WriteLine("General error." + Environment.NewLine + ex.Message);
}
return null;
}

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

Øystein_Kolsrud — Tue, 11 Jun 2019 06:52:05 GMT

Are you using .Net Core or .Net Framework? I think there was an issues with the session setup in the .Net Core version that was fixed recently, so if you are using .Net Core then you might want to see if it works for you using .Net Framework. The fix should be out in the next release of the SDK.

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Tue, 11 Jun 2019 20:28:53 GMT

I am using .Net framework not Core. Can you please review my code and see what I am missing? It is always creating a new session and not use a existing one.

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

Øystein_Kolsrud — Wed, 12 Jun 2019 06:06:07 GMT

I tried the code and (modifying the IDs obviously) it works just fine. I can see the selections I do in the client through those calls. The only error I saw in the code was that you are printing the cell rows enumerable directly instead of concatenating it into a string first, but I assume that is not the issue you are seeing.

Are the selections you do in the client getting cleared when you run your program? Perhaps you have "extended security environment" enabled on your virtual proxy?

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Wed, 12 Jun 2019 13:23:10 GMT

Are you using Google chrome? the selections still stay there and is not cleared. I will check regarding "extended security environment"

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Wed, 12 Jun 2019 17:44:02 GMT

I checked. Extended security environment is unchecked on the virtual proxy. Just to be clear. I am trying to make changes on the chrome web browser and see those same changes on the .net side.

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

Øystein_Kolsrud — Mon, 17 Jun 2019 12:02:30 GMT

Hmm... Well, then I'm afraid I'm running out of ideas. What type of authentication are you using on the virtual proxy you are connecting to?

And, yes, I've tried with Chrome.

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Mon, 17 Jun 2019 14:32:44 GMT

Proxy uses ticket based authentication.

Re: QlikSense .NET SDk: how to retrieve filtered data from a table?

mel78 — Thu, 20 Jun 2019 17:02:49 GMT

What version of QLIK sense are you using ?