Export data from Qlik Sense in json format

[Birgit]

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]

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

[Birgit]

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