How to automatically loading and parsing JSON schema in the Load Editor?
I am working on developing an app that pulls in data using APIs. Due to the nature of the company I work in, I am not the owner of the app and thus cannot use the GUI to load in data, there are restrictions on my ability to create new connections, and I cannot install any extensions. As such, I have created a generic REST connector that I point to the REST endpoint in the Load Editor using WITH CONNECTION.
A lot of information from REST APIs is returned in the JSON format. After much scouring online, I have found ways to load JSON data using the Load Editor into the app. However, this requires foreknowledge of the data model and the somewhat laborious process of listing each of the desired field names for the parent and all children fields.
However, when loading in via the Data Manager, the wizard automatically parses out the JSON schema and generates the Load Editor script with the repeated Select statements to load the data based on the field names.
My question is, is there a way to replicate this automatic identifying of all the fields that the wizard does within the Load Editor? The app is in development so it would make my life so much easier if I could add to the data model without having to first investigate the data in Python and then writing out long lists of field names to loop through.
If you can create a connection, even just locally, that has the full URL, the select data dialog in the Load Editor will generate the load statement for you. You can then adjust the statement to use the generic connection.
If you absolutely can't create the connection, you may consider installing Qlik Sense Desktop and trying to generate the load statement from there.
If you can create a connection, even just locally, that has the full URL, the select data dialog in the Load Editor will generate the load statement for you. You can then adjust the statement to use the generic connection.
If you absolutely can't create the connection, you may consider installing Qlik Sense Desktop and trying to generate the load statement from there.
Apologies for the delay in my reply, this comment was very helpful. I didn't end up implementing this method as the keys in the JSON response wasn't always consistent but I saw that this could allow me parse a known response in the Load Script. Thank you so much!
