topic Store data as QVD or attached file via mashup in Integration, Extension & APIs

Store data as QVD or attached file via mashup

daviddiener — Sat, 16 Nov 2024 17:54:00 GMT

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

Re: Store data as QVD or attached file via mashup

ajaykakkar93 — Fri, 06 Nov 2020 10:33:29 GMT

Hi @daviddiener ,

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

Re: Store data as QVD or attached file via mashup

daviddiener — Fri, 06 Nov 2020 10:50:02 GMT

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/Sense_RepositoryServiceAPI/RepositoryServiceAPI-App-Content-Upload-File.htm

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/Sense_RepositoryServiceAPI/RepositoryServiceAPI-Connect-API-Using-Xrfkey-Headers.htm

The bodyData is a BLOP.