
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Parse JSON in JSON from Qlik Sense REST
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
