
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load JSON data in Qlik Sense
Assuming I have an external source which has an REST/SOAP API returning JSON data, Is it possible to read a REST or SOAP API and load JSON data into Qlik?
Accepted Solutions

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, this is possible.
Just use the Qlik REST Connector.
bye Konrad

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
This will then create a table with Name and Address as the two column..
I think this is what you meant.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is very helpful. Do you have any idea what the performance implications of this strategy would be? Also, would there be a way to load the column names dynamically based on the Key in the JSON?
Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Performance should be based on the sql server as you are passing the query to the database and the database itself is doing the work. for Json_Value function, I think you need to know the name of the column as it goes by the path($.Key) however if your database is not an azure and has an object OpenJson you can use that, it can be call dynamically (like select * from table) here's the info for both: OpenJSON - https://msdn.microsoft.com/en-us/library/dn921885.aspx JSON_Value - https://msdn.microsoft.com/en-us/library/dn921898.aspx
