Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Bucapps
Contributor
Contributor

Download OOXML / Excel file with ticket authentication.

Hi, I've made all the process to get the url to download my file but when I get the qUrl I can't  just download the file using node. 

 

 

 

// Generate Sheet with data.
    var sheet = await app.getObject('e86fbce8-3aa3-4be0-8081-d55a1f4cd531')

    //Generate download link
    var exportResult = await sheet.exportData("OOXML", "", "export.xlsx");
    console.log(exportResult);

 

 

 

 

under exportResult I got 

 

 

 

{ qUrl:
   '/tempcontent/ABCD/fileName.xlsx?serverNodeId=nodeId',
  qWarnings: [] }

 

 

 

  and im stuck at the point of download. 

 

if I concatenate the url of my qliksense url with the qUrl and paste it in the browser it download the file. but I need to download the file from the Node server. 

I use ?QlikTicket=abcd1234 to authenticate. 

Can I use this session to download the file ?

 

 

 

const session = enigma.create({
        schema,
        url: `https://${qsAppHost}/app/engineData?QlikTicket=${qsTicket}`,
        createSocket: (url) => new WebSocket(url, {
            headers: {
                'X-Qlik-User': `UserDirectory=${encodeURIComponent(qsQpsTicketBody.UserDirectory)}; UserId=${encodeURIComponent(qsQpsTicketBody.UserId)}`,
            },
        }),
    });

 

 

 

Labels (2)
0 Replies