Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
yaminiraju
Contributor
Contributor

Connecting the QlikView and RestConnector

Hi,

I am facing issue while pulling data from the JSON using Postman and RestConnector in Qlikview.

PURPOSE: Trying to pull a sample elasticsearch data (JSON format) into the Qlikview application.

The following steps I have followed, please correct me if am wrong anywhere since am new to QlikView application.

STEP 1: Installed the QlikView 12 Apps, Postman in chrome, elasticsearch-1.7.2.

STEP 2: Generated a http:// URL from the Postman, by the below steps:

                    (a) By setting the POST method, created URL http://localhost:9200/label/color/

                    (b) The below sample JSON have been posted in the above URL

{
  "colorsArray":[{
  "red":"#f00",
  "green":"#0f0",
  "blue":"#00f",
  "cyan":"#0ff",
  "magenta":"#f0f",
  "yellow":"#ff0",
  "black":"#000"
  }
  ]
}


                    (c) I was able to get the above data while i tried to use the GET method

STEP 3: In the Qlikview, created a new file, under the Edit Script, the database "QvRestConnector" was choosed and Connected. In the "REST Connection" tab the following information were provided:

                    (a) URL -  http://localhost:9200/label/color/_search/ 

                    (b) Method - GET

                    (c) Auto Detect response type - enabled

                    (d) Use Windows Authentication - Yes

                    (e) Test Connection - Connection Succeeded

STEP 4: In Edit Script, under Data tab, option Select is chosen. The following information were provided:

                    (a) Response type - JSON

                    (b) Object - Selected the root object

                    (c) Selected OK

STEP 5: Right click on the Main sheet, and selected New Sheet Object --> Chart. Selected Straight Table and chose Next. Here Under the Available Fields/Group, couldn't find any fields.


Can someone guide how to pull the data from JSON file.

PROBLEM: Fields are not displaying in the Available Fields/Group in the Edit Script part.

0 Replies