topic Re: Export data from Qlik Sense in json format in App Development

Export data from Qlik Sense in json format

Birgit — Mon, 20 Dec 2021 21:08:46 GMT

Dear all,

We try to export data from Qlik Sense using a REST connection. Export format should be json (or alternatively xml). We found the following statement:

LIB CONNECT TO 'REST_connection';

RestConnectorMasterTable:

SQL SELECT

"returnValue"

FROM JSON (wrap on) "root"

WITH CONNECTION(BODY "$(vRequestBody)");

We can’t figure out how to export our Qlik Sense data in json format to the variable "$(vRequestBody)"?

We use Qlik Sense Enterprise, June 2020 Patch 2.

Many thanks in advance for your help!!

Best regards,

Birgit

SN — Tue, 15 Jun 2021 07:44:05 GMT

Did you find a way to do it? and how?

Birgit — Wed, 16 Jun 2021 09:44:22 GMT

No, unfortunately not. Now we export data in csv-format and transform into json-format outside Qlik.