topic Re: How to load data which is json formate in Sql server in QlikView

How to load data which is json formate in Sql server

Anonymous — Tue, 30 Jun 2015 05:33:38 GMT

Hi All,

I have data in sql server in that one field is in json formate so how to load data into to Qlikview and how i saparate json formate data in Qlikview.

Regards,

Chandini.G

Re: How to load data which is json formate in Sql server

petter — Tue, 30 Jun 2015 05:37:56 GMT

This might be helpful to you:

Re: Using data from JSON Rest API in Qlikview‌

and this:

JSON connector example.zip

Re: How to load data which is json formate in Sql server

Anonymous — Tue, 30 Jun 2015 05:50:18 GMT

Hi petter,

Thanks for your response.

My data is in sql server not in web so how i saparate those data.

Thanks,

Re: How to load data which is json formate in Sql server

petter — Tue, 30 Jun 2015 06:08:06 GMT

If you are accessing your SQL Server via HTTP protocol that should work well even though the server is not "on the web" it would be exactly the same except that the URL points to a server that is only available internally in the organisation/business.

JSON itself is not dependent on transport mechanism. It is purely a data-format - but is often coupled with REST which is based on HTTP as a transport. Hence the name JSON REST API. If the data is already available directly from some table in SQL Server you might not need a full JSON REST API only the JSON parsing that pull out the relevant data for you into tables and columns/fields.

Re: How to load data which is json formate in Sql server

petter — Tue, 30 Jun 2015 06:10:36 GMT

You might even use a Macro which runs a JScrpit (Microsofts JavaScript) to do the parsing. JSON - stands for JavaScript Object Notation. So basically any small JavaScript could be able to parse out the values you are looking for. A JScript function in a Module/Macro is possible to call from a LOAD SCRIPT.