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

Andreas_Giesbrecht — Fri, 21 Jan 2022 09:31:41 GMT

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 which will be dynamically

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.

article Reloads of dynamic JSON files via General QWC with asynchronous mode do not work as expected in Official Support Articles

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

Workaround:

Environment