CSV export with Table API on mashup

[Anonymous]

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

[Stefan_Walther]

Have a look here:

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

Sent from my iPhone

[Aiham_Azmeh · Accepted solution]

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

[Ranjit]

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)
})
})