JSON with unknown elements (Qlik Sense Enterprise for Windows)
Hey everyone,
I have a problem of which I don't know how to solve it: I have a data pipeline set up that extracts JSON data from a REST API. The top-level elements are unknown and non-sequential.
When using the built-in REST connector of Qlik Sense, the connector tries to arrange the data into a model, but the data that comes back from the endpoint might have new unknown top-level elements. My data looks like this: [ "1234":{ "somearray": [] "somekey": "somevalue", "someotherkey": "someothervalue" }, "2843":{ "somearray": [] "somekey": "anothervalue", "someotherkey": "someothervalue" }, "2995": { <...> } ]
The code that Qlik creates via the connector only accounts for the top-level elements ("1234", "2843", "2995") it can fetch at the time of creation of the script, so when there's subsequently new elements or elements get deleted, the script created by the connector can not account for that.
Anyone got an idea how to solve this issue using Qlik Sense onboard capabilities?