JSON convertor in QLIVIEW

[0li5a3a]

Hi Guys,

I  checked all the  community  discussions about JSON  but I don't understand the logic. Could someone drive me on to the right direction?

I need to extract data from MySQL and  I have a column what contain the data using JSON format.

I want to thank you in advance !

[adamdavi3s]

Did you find this?

JSON Loader

Parsing JSON in QlikView Desktop?

[0li5a3a]

I found this but I  need to extract data from MySQL server   i don't have an url

[adamdavi3s]

Ok, can you possibly provide a sample of how the table looks with a row of data?

It'll be possible somehow

[adamdavi3s]

Just found this from hoangvvo‌

You can do a select on the json string to create a data model.

ex:jsonstring= [{"key1":"value1"},{"key2":"value2"}]

Tmp:

Load Id,Name,Address;

SQL Select Id,

     Name=JSON_VALUE(JSonStringColumn,'$.key1'),

     Address=JSON_VALUE(JsonStringColumn,'$.key2')

from your table

[0li5a3a]

if I want to use Qlik general web connector do you know how to configure it?