Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
stefano_pernat
Contributor II
Contributor II

qlik rest connector generates lot of tables reading json, how to have single table instead

Hi all,

I'm using QlikViewRestConnector to fetch data from an external API (I attached the structure sample),

I noticed that the connector gerates a lot of tables (one tables for one key and only one line fetched).

Is it possible to generate or concatenate into a single table?

Thanks

1 Solution

Accepted Solutions
stefano_pernat
Contributor II
Contributor II
Author

I discovered that QlikViewRestConnector creates a table for every json object

I solved changing json structure to an array of objects.

In this way QlikViewRestConnector generates a single table

View solution in original post

4 Replies
stefano_pernat
Contributor II
Contributor II
Author

I discovered that QlikViewRestConnector creates a table for every json object

I solved changing json structure to an array of objects.

In this way QlikViewRestConnector generates a single table

lightsection
Contributor III
Contributor III

Can you elaborate more on this :
How do u create array of objects ?
Is it done on Qlik end ? or on the data side of things ?
stefano_pernat
Contributor II
Contributor II
Author

Hello,

sorry for my late response but I got a cuple days of holiday.

As you can see in my previous post I got a backend API that generates a pretty complex JSON.

The original JSON was in the form:

{

"index": {

"field": "value",

"field2": "value",

.....

},

....

}

For this JSON, Qlik connector generates for every object a relationship table with inside autogenerated ID that connects every object with the root one.

So it generates a lot of tables.

For solving this issue I had to change my backend API so it returns a JSON in the following form:

[

{

"index": "value",

"field1": "value",

"field2": "value"

},

....

]

Reformatting JSON as an Array Qlik connector understand that objects inside are related and generates a single table.

regards

Stefano

Rakeshmutha
Contributor III
Contributor III

Hi i am using array function in qliksense using rest api  and it fetches me one data at a time

i need to fetch the total data from the table and show me in the another temp table.

what we will be the best solution for this .