Store data as QVD or attached file via mashup

[daviddiener]

Hello,

I want to upload a .xlsx file via a mashup and import it to my Qlik Sense App. Which Qlik API has the capability to do that? Either a direct store in the library as .qvd or attaching the .xlsx file to the app (lib://AttachedFiles/) would work.

Thanks in advance!

David

[ajaykakkar93]

Hi @daviddiener ,

I have not performed this, for now, ill surely give it a try.

[daviddiener · Accepted solution]

I did it by sending a POST request to the QRS API. It is documented here: https://help.qlik.com/en-US/sense-developer/September2020/Subsystems/RepositoryServiceAPI/Content/Se...

Here is my JS Code:

var baseUrl = "https://my-qliksense-server.com/qrs/appcontent/<App-id>"
var url = baseUrl + "/uploadfile?externalpath=myFile.xlsx&overwrite=true&xrfkey=abcdefghijklmnop"
    
var xmlHttp = new XMLHttpRequest()
xmlHttp.open( "POST", url, false ) // false for synchronous request
xmlHttp.setRequestHeader("X-Qlik-XrfKey", "abcdefghijklmnop")
xmlHttp.send( bodyData )

The X-Qlik-XrfKey (16-digits) has to match the xrfkey query parameter. (https://help.qlik.com/en-US/sense-developer/September2020/Subsystems/RepositoryServiceAPI/Content/Se...

The bodyData is a BLOP.