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

[stefano_pernat]

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

[stefano_pernat · Accepted solution]

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]

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]

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

[Rocky6]

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 .