Qlik Community

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dev1_wattline
Contributor II
Contributor II

Sense - Nested JSON via REST

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

3 Replies
Frank_Hartmann
Master II
Master II

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
Employee
Employee

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

dev1_wattline
Contributor II
Contributor II
Author

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.