#isjson

If you work with modern applications, JSON is already part of your daily life. Whether it’s REST APIs, web services, or tools like Postman, JSON has become the default format for data exchange. And if you’ve touched NoSQL platforms like Azure Cosmos DB, you already know how deeply JSON is baked into today’s systems. SQL Server has supported JSON for quite some time now—since SQL Server 2016, to…

Check data is in JSON format in MS SQL Server ISJSON is used to check the JSON value in MS SQL Server is valid or not. If the value is valid then it will return 1 otherwise 0. Check the JSON value in MS SQL Server is a valid JSON value -- JSON valid format select isjson('{"id": "1"}') as Result Result ------ 1 --NON-JSON format select isjson('abc') as Result Result ------- 0 Check the column…

Everywhere JSON so why not in SQL SERVER–New feature in SQL SERVER 2016

If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t worry you might use sooner than later. JSON is kind of ecosystem which is most popular in the various area for exchanging the data. If you talk about charting solution, AJAX, Mobile services or any 3rd party integration then generally JSON is the first choice of the developers.

  If…

The problem(s) As any ColdFusion dev can tell you, working with JSON in ColdFusion is like feeding yourself soup with a razor blade. Blood everywhere.

The problem is exemplified by the fact that ColdFusion's isJSON() function doesn't protect the deserializeJSON() function from erroring out.

This code should be bullet-proof, but it isn't:

<!--- if this is a valid JSON string ---> <cfif isJSON( your_string )> <!--- deserialize the JSON string (since it's valid) ---> <cfset your_new_object = deserializeJSON( your_string )> </cfif>

Problem 1 In ColdFusion, if you try to deserialize a string that is not valid JSON you will receive a hard error. Ideally, deserialization should fail gracefully.

Problem 2 Furthermore, the isJSON() method should only return true for strings that can actually be deserialized.

The Solution(s) For these reasons, I created a ColdFusion CFC (safeJSON.cfc) which has two methods--one for better JSON validation, and one for more graceful deserialization.

I hope this helps some of you as much as it's helped me.

Requires ColdFusion 10+