Parse JSON in JSON from Qlik Sense REST

[Anonymous]

Hello everybody,

I'm trying to read JSON data with REST API but when I make the request the returned data looks like this:

[

  {

  "id": 299,

  "form_id": 194,

  "form_data": "[\r\n {\r\n \"columnname\": \"Firma\",\r\n \"data\": \"someCompany\"\r\n },\r\n {\r\n \"columnname\": \"Yetkili Adı\",\r\n \"data\": \"someName\"\r\n },\r\n {\r\n \"columnname\": \"Telefon\",\r\n \"data\": \"someNumber\"\r\n },\r\n {\r\n \"columnname\": \"Email\",\r\n \"data\": \"someEmail\"\r\n },\r\n {\r\n \"columnname\": \"Hizmet Türü\",\r\n \"data\": \"Destek\"\r\n },\r\n {\r\n \"columnname\": \"Ürün Türü\",\r\n \"data\": \"Qlik View\"\r\n },\r\n {\r\n \"columnname\": \"Başlangıç Zamanı\",\r\n \"data\": \"14.11.2016 \"\r\n },\r\n {\r\n \"columnname\": \"Bitiş Zamanı\",\r\n \"data\": \"14.11.2016\"\r\n },\r\n {\r\n \"columnname\": \"Yapılan iş\",\r\n \"data\": \"someData\\n\"\r\n }\r\n]",

  "form_fill_date": "2016-11-14T14:24:53",

  "form_filled_by_user_id": 113,

  "user_latitude": "41.0154013",

  "user_longitude": "28.909338400000003",

  "workflow_status_id": 276,

  "workflow_status_complete": null,

  "form_version": null

  },...

As you can see there is a key called form_data and its value is also a JSON data. How can I parse that data to Qlik Sense? Is there a way to do that?

Best regards,

Ogün ADSAY.

[#2]

Hi Ogün ADSAY,

You can do a select on the json string to create a data model.

ex:jsonstring= [{"key1":"value1"},{"key2":"value2"}]

Tmp:

Load Id,Name,Address;

SQL Select Id,

     Name=JSON_VALUE(JSonStringColumn,'$.key1'),

     Address=JSON_VALUE(JsonStringColumn,'$.key2')

from your table

This will then create a table with Name and Address as the two column..

SOURCE: Load JSON data in Qlik Sense