Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Highlighted
minvestis
New Contributor II

Rest Connector - JSON response format issue - Qlik Sense

HI,

 

I am using rest connector to extract data from one of cloud based system.

While getting response from cloud system its shows me following structure.

Json API.png 

 

Here, JSON format is providing each records as individual table (i.e. 25339455 - Actually this is row and here it act as a table due to JSON format), i want all this records into one single table.

Generally, all this records should show under Workspaces table but here its rows act as individual table. This leads to 1000+ table in my data model as this table contain 1000+ rows and all rows loading as individual table.

Can you help me how to get this format in one single table?

Let me know if you need more information for the same.

 

Thanks

Mayank Patel

 

Tags (3)
Labels (5)
5 Replies
AxNoxy
New Contributor III

Re: Rest Connector - JSON response format issue - Qlik Sense

Can you post the script of what shows if you load the data until Workspaces level? I mean if its possible to make

Workspaces:

LOAD

*

 FROM root/workspaces (something);

 

Just check the workspaces row

minvestis
New Contributor II

Re: Rest Connector - JSON response format issue - Qlik Sense

Hi,

To give you script here, i limited my data per page = 2 in API, so now it shows following preview.

Json API.png

 

And here i attached script upto workspaces level.

If you see script only for two records it have big script, think if I load 1000+ records how it will be big script.

 

Looking forward for your feedback.

 

AxNoxy
New Contributor III

Re: Rest Connector - JSON response format issue - Qlik Sense

I had some similar problem once with XML files, my solution thats its not  a mere  solution was to import all the code to a txt file and then add it as an Include Statement.

Hope you find your answer soon.

minvestis
New Contributor II

Re: Rest Connector - JSON response format issue - Qlik Sense

Hi,

 

Importing all the code to a txt file is not a proper solution as let say we have newly added records in cloud system then again we need to import new code in txt file.

And I have more then 5 entity similar this, which i need to configure in it.

Thanks that you looked in my query. I hope we get some solution for this.

 

@Michael_Tarallo  : Hi Michael, Can you help me on this? Do we have any solution to fix this issue?

 

Thanks

Mayank Patel

Employee
Employee

Re: Rest Connector - JSON response format issue - Qlik Sense

Hi Mayank - let me see what I can do. Sorry for the delay. 

Regards,
Mike Tarallo
Qlik