Sense - Nested JSON via REST

[dev1_wattline]

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

[Frank_Hartmann]

this might be helpful as a starting point, although it describes a local json extraction:

https://community.qlik.com/t5/App-Development/How-to-load-local-JSON-file-into-Qlik-Sense/td-p/16117...

[Levi_Turner]

Can you get a list of ab156, kou34, ....? If so then you can dynamically generate the load script required.

[dev1_wattline]

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.