topic Re: CSV export with Table API on mashup in Integration, Extension & APIs

CSV export with Table API on mashup

Anonymous — Fri, 10 Jun 2016 11:44:58 GMT

Hi,

I can export to OOXML format, but when I change to CSV, rpc returns this error

with this code:

This frame is sent:

If I change "CSV_T" with "OOXML" then the table is exported correctly.

I don't find the reason, any suggestion?

Thanks,

JuanJo

Re: CSV export with Table API on mashup

Stefan_Walther — Fri, 10 Jun 2016 15:41:49 GMT

Have a look here:

https://github.com/stefanwalther/sense-extension-recipes/tree/master/tableapi-exportdata-paint

Sent from my iPhone

Re: CSV export with Table API on mashup

Aiham_Azmeh — Mon, 13 Jun 2016 06:25:54 GMT

Hi Juan,

As swr‌, commented, you should use TableApi's exportData method ‒ Qlik Sense‌.

What you are using in your example is the exportData method from the visualization layout; I am not really sure if this is documented, or "officially exposed"... but the reason why you can export OOXML and not CSV_T or CSV_C file format is that you are missing the second parameter "qPath" see documentation here: ExportData method ‒ Qlik Sense‌ - this parameter is mandatory only for CSV_T and CSV_C.

regards,

aiham

Re: CSV export with Table API on mashup

Ranjit — Tue, 23 Apr 2019 13:14:29 GMT

Hi...,

Try this method.

var set = {
qFileType: 'CSV_C',
qPath: '/qHyperCubeDef',
qFileName: 'temp.csv'
}
app.getObject('sxqbWtE').then(function (m) {
console.log(m)
m.exportData(set).then(function (reply) {
console.log(reply)
window.open(reply.qUrl)
})
})