Parse JSON in JSON from Qlik Sense REST

Anonymous — Mon, 13 Mar 2017 11:59:53 GMT

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.

Re: Parse JSON in JSON from Qlik Sense REST

Fri, 01 Sep 2017 06:17:13 GMT

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

topic Re: Parse JSON in JSON from Qlik Sense REST in App Development

Parse JSON in JSON from Qlik Sense REST

Re: Parse JSON in JSON from Qlik Sense REST