Retrieving imported data from QLIK through API

[anshu2185]

Hi,

My QLIK sense server is importing the data from excel which i do not have access. I want to hit QLIK sense server directly and fetch that excel data from my web application. Is it possible through any QLIK api? 

Thanks in advance.

[bramkn]

why not just let qlik download and upload the Excel file somewhere you can access it?

[anshu2185]

@bramkn  Thanks for the quick reply.

Thats the better way of doing but the that is not in our control. The only way we are figuring out was if we can hit QLIK directly and fetch the data loaded through excel. Do you see any possibility using Engine API or Backend API ?

Thanks.

[bramkn]

The Engine API can load any data stored in the App. So yes thats possible. would be a lot of work for something that should be solved differently. But that wasn't the question of course . 🙂

[anshu2185]

@bramkn  Thanks again. 

I agree that it should be solved differently, but we have the accesss restriction. 

Can you please eloborate on how exactly we can get the data through Engine API?

Do you have any sample code for that ?

Thanks.

[bramkn]

There is an Js engine API and C#.Net SDK.
So it depends on what you want to use on how to do it.
You can export data from an object to Excel/CSV.
Not sure if you would need to build an object for this or if you are able to just get a table as the object.