JSON_VALUE in SQL-server 2014
JSON support was not introduced until SQL Server 2016, so you'll need to use custom functions. Check out Phil Factor's article on this where he provides some code for parsing JSON in earlier versions of SQL Server.