Export a QlikView Ajax Doc to excel programmatically

[justindelisi]

We have several QlikView web apps and I'm trying to pull some data from these apps to be used on a web app dashboard. The only access to the qlik apps I have is through the ajax versions. I know that I can right click on tables and export to excel but is there a way anyone knows of to do this with an external script in javascript or python perhaps? I know there are APIs for QlikSense apps to export data from mashups but I couldn't find anything for QlikView. 

[Nicole-Smith]

There are some items that allow you to do document/object integration in other applications:
https://community.qlik.com/t5/QlikView-Documents/QlikView-MashUp-Documentation-Examples/ta-p/1481500

If the above doesn't solve for what you're trying to do, your best bet would be to have the developer of the application export the data to a .txt file (using the Qlik View load script) that you can then read into your application.

[Brett_Bleess]

Just adding a link to the Help regarding Mash-ups in QlikView that Nicole mentioned in her post.

https://help.qlik.com/en-US/qlikview-developer/April2019/Subsystems/Mashups/Content/QV_Mashups/mashu...

To Nicole's other point, really need further information on the use case you are attempting to solve in order to determine if there may be other ways to do things.  One other that came to mind would be to create QVD files in the app from which you are trying to get the data such that you can use those QVD files in the other apps rather than trying to export/import etc.  

Regards,
Brett

[MikeW]

I have posted some sample javascript code that exports pivot or straight table chart to csv. You can probably modify it to do what you need.

https://community.qlik.com/t5/QlikView-Documents/Useful-Qlikview-Javascript-for-Chrome-Ajax-client/t...

[erikzions]

I have this exact need.  I am exporting a small table to a text file for use elsewhere.  The Export Action works fine in IE.  It doesn't work in AJAX and they don't want to limit people to IE since it isn't their preference.  (mumble grumble grumble) have you had any luck?  

[justindelisi]

No unfortunately I haven't. I ended up making a qlik app that exported the
qvd I needed to a csv and then picked it up with a cloud ETL service to use
it elsewhere.