Reloads of dynamic JSON files via General QWC with asynchronous mode do not work as expected

[Andreas_Giesbrecht]

Ssynchronous mode for reloads via Qlik Web Connectors (Asynchronous requests) only works as expected for data resources (like for example JSON files) that have a static schema.

You might not get the expected results if you reload from data resources with a dynamic structure like for example:

File1:

{ "firstName": "John",
"lastName": "Smith"}

File2:
{ "firstName": "Bob",
"middleName": "Mel"
"lastName": "Lee"}

In this case if you reload those 2 JSON files via General QWC with asynchronous mode, most likely the "middleName" won't be reloaded in Qlik Sense because it is using the first file (File1) to generate the table structure and then with subsequent tables it is pulling the same columns where they are found. 

A feature request has been created in the community in order to improve this functionality:

Add to the asynchronous mode of the GeneralWebConnector the ability to load data, the structure of w...

Workaround:

A workaround would be to use a "For/next loop" approach as described in here, where you would be able to reload all the column structures:

Synchronous requests

Environment

• Qlik Sense all versions
• QlikView all versions
• QWC all versions

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.