topic Sense - Nested JSON via REST in Integration, Extension & APIs

Sense - Nested JSON via REST

dev1_wattline — Tue, 04 May 2021 08:56:41 GMT

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

Re: Sense - Nested JSON via REST

Frank_Hartmann — Tue, 04 May 2021 10:38:43 GMT

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/1611727

Re: Sense - Nested JSON via REST

Levi_Turner — Tue, 04 May 2021 12:48:40 GMT

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

Re: Sense - Nested JSON via REST

dev1_wattline — Tue, 04 May 2021 13:20:21 GMT

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.