Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
minvestis
Contributor II
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

 

Labels (5)
5 Replies
AxNoxy
Contributor III
Contributor III

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
Contributor II
Contributor II
Author

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
Contributor III
Contributor III

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
Contributor II
Contributor II
Author

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

Michael_Tarallo
Employee
Employee

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

Regards,
Mike Tarallo
Qlik