topic Re: Rest Connector - JSON response format issue - Qlik Sense in Integration, Extension & APIs

Rest Connector - JSON response format issue - Qlik Sense

minvestis — Sat, 16 Nov 2024 06:02:49 GMT

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.

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

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

AxNoxy — Thu, 18 Apr 2019 21:15:22 GMT

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

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

minvestis — Thu, 18 Apr 2019 21:27:16 GMT

Hi,

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

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.

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

AxNoxy — Thu, 18 Apr 2019 21:39:35 GMT

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.

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

minvestis — Thu, 18 Apr 2019 23:26:26 GMT

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

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

Michael_Tarallo — Fri, 26 Apr 2019 18:22:44 GMT

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