Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NoNameFound
Contributor III
Contributor III

Large JSON responses results in incomplete schema using REST connector

Hey everyone, 

I've encountered an issue when loading a large JSON response through the REST connector. 
The response I get contains objects that may have a sub-array or not ("someinfo":{"id":1,"text"="bla"} / "someinfo":"") and is only a single page, so no pagination. 

When the first few rows do not contain a sub-array, but the last few do, Qlik straight up ignores that and does not get the schema right. 

My question is: How far does Qlik look into the response to infer a schema and how can I make sure that Qlik gets the schema right for the entirety of the response? I've already tried to turn up the symbols preload count to "unlimited" (because I hoped it might help), but to no avail. 

Thanks. 

1 Reply
rafaelencinas
Partner - Creator II
Partner - Creator II

Hi @NoNameFound !

I have this same issue with larger JSON Files, 

In my case, when I create a Data Connection, I tried to found a record with all attitributes filled, but , when its not possible, in Load Statement I add manually the fields and sub queryes, or I try to mix different Load Statements.

 

Bye!

 

 

Senior Qlik Architect
Cobra, Stallone, "You're a problem and I'm the solution"