topic Re: Mashup Store table in excel/CSV (server side) in Integration, Extension & APIs

Mashup Store table in excel/CSV (server side)

J_Uri — Sat, 16 Nov 2024 01:09:52 GMT

Hi.

I'm having issues downloading a table into the server on a mashup.

The idea is to store a table that contains a few dimensions and 2 variable inputs which once they hit the "export" button that data should get stored in an excel file in the server.

//EXPORT
require( ["js/qlik", 'jquery'], function ( qlik, $ ) {
var app9 = qlik.openApp('App.qvf', config);
var $exportButton = $( document.createElement('button')).text('Export').appendTo('body');
var object = app.getObject('QV14','ObjectID');
object.then(function(model) {
var table = new qlik.table(model);
$exportButton.bind('click', function() {
table.exportData({download: true});
})
})
});

This allows to export the data into the client side. However, i need to store it into the server.

Any idea how should i approach this?

Best regards.

Re: Mashup Store table in excel/CSV (server side)

rwunderlich — Thu, 05 Nov 2020 19:25:49 GMT

Because of the sandbox security restrictions in the browser, you will need to POST the data to a service running on the server (or some server) and have the service write the file.

-Rob

Re: Mashup Store table in excel/CSV (server side)

J_Uri — Tue, 10 Nov 2020 08:19:40 GMT

Thanks Rob for the reply.

I've been looking into this and found a post that is saying that the file is located in the server when doing an export.

https://community.qlik.com/t5/Qlik-Sense-Integration-Extensions-APIs/How-to-include-quot-Export-data-quot-feature-in-a-mashup/td-p/861168/page/3

Could this mean that the export function would allow to export to the server?

Could you provide an example of a service running on the server to capture that data?

Best regards.

Re: Mashup Store table in excel/CSV (server side)

rwunderlich — Tue, 10 Nov 2020 15:13:50 GMT

I believe the table.exportData() function you've show in your example will always run client-side, and therefore write to the local machine. As far as example of writing server-side, what web server and framework are you using for your mashup?

Re: Mashup Store table in excel/CSV (server side)

J_Uri — Thu, 12 Nov 2020 18:05:06 GMT

We're using the Qlik devhub so i'm guessing we're ussing the QlikServer as a web server. Otherwise i don't know what you're referring to.

Best regards.

Re: Mashup Store table in excel/CSV (server side)

J_Uri — Thu, 19 Nov 2020 11:22:44 GMT

Update:

The solution to create a web application to store the data we needed delayed the deployment of the project too much and was ultimately discarded.

We would have needed to create a nodejs server and create a service that would listen to petitions 24/7 and recover these fields and store them in a SQL databse or a CSV.

This topic was very helpful: https://community.qlik.com/t5/New-to-Qlik-Sense/Is-anyone-familiar-with-mashups-InputBox-to-store-into-MySql-db/td-p/1415723

Finally we opted to use Qlik OnDemand App to store the information we needed on the server in a QVD. This basically creates an app that is filtered by the user and stores the filtered information into a QVD. Quite simple and the only problem is that the apps are stored in the server aswell, which they can be deleted daily thorugh an automated task.

Hope this is usefull to somebody else.

Best regards, Javier.