1 Reply Latest reply: Sep 1, 2017 2:17 AM by Anand Subramanian RSS

    Parse JSON in JSON from Qlik Sense REST

    Og�n ADSAY

      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.