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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
NoNameFound
Contributor III
Contributor III

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? 

0 Replies