Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to load some data from an API which is using a nested JSON format like this:
[ "ab156": {"color":"red", "code":"apple"}, "kou34":{"color":"yellow", "code":"lemon"}]
The "table names" are random and I need to call the API in a loop - so right now I don't see a way to use the Qlik REST connector. According to this (https://support.qlik.com/articles/000074304) nested JSON format isn't supported.
I looked into LLoki (Qlik refers to it's Youtube-video) - but the websites are down. All I can find from LLoki are the guides.
Does anyone know an alternative to LLoki or another way to get the data from nested JSON in QlikSense?
Thanks
this might be helpful as a starting point, although it describes a local json extraction:
Can you get a list of ab156, kou34, ....? If so then you can dynamically generate the load script required.
No, I can't get a list of the names - these are only contained in the JSOJN itself. I'll try Franks solution with python tomorrow.