As of now, I have Qlik Sene Desktop. I have a Student Statement App, and i have created a straight table in the format they need. Now, using Qlik Engine API can I connect to this app and get that table data from using .net or JS. So, I can use the data in my custom app for other purposes.
Is this Possible? If yes, what's the best method? I see Qlik Engine API, Capability APIs.
Please anyone help me on this at your earliest convenience.
I guess your solution depends on how you want to use the extracted data. But here is a simple example of how to use the .NET SDK in C# to connect to an app in Qlik Sense Desktop, extract data from a table, and write it to standard output:
static void Main(string[] args)
{
var objId = "<objectId>";
var location = Location.FromUri("http://localhost:4848");
location.AsDirectConnectionToPersonalEdition();
var appId = location.AppWithNameOrDefault("MyApp");
using (var app = location.App(appId))
{
var obj = app.GetGenericObject(objId);
var pager = obj.GetHyperCubePager("/qHyperCubeDef");
foreach (var cellRow in pager.GetAllData())
{
Console.WriteLine(string.Join("\t", cellRow.Select(c => c.Text)));
}
}
}
The above solution I tried, and it worked for me in Qlik Sense Desktop. I'm developing .NET app, so the desktop/console app supports the Qlik. Engine but for web-based .NET app we need to use web sockets; above solution I cannot use for web-based applications.
Please support me on working on web-based app and thanks for the above as well.
I need to use my extracted in my front-end tables, filters created. Can I use .NET to get data from my object or do i need to use Qlik Engine JSON API also to achieve it ?
I'm not a web developer, so I'm not really the best person to guide you in what is the best way forward. But the .NET SDK is primarily a .NET wrapper for the Qlik Engine JSON API. If you want to extract data from an app, then there is no other way than to use web sockets. And that library provides a way to do so in .NET.
