IsJsonValid

Checks the validity of a Json string

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.IsJsonValid( @Json )

Arguments:

Name	Type	Description
@Json	nvarchar(MAX)	Json string



Return Type:

bit



Return Values:

0 = Json is NOT Valid
1 = Json IS Valid



Remarks:

Microsoft introduced the IsJson function starting with SQL Server 2016. This function can be used starting with SQL Server 2008.



Sample Usage:



DECLARE @Json nvarchar(MAX)

SET @Json = '{
  "firstName": "John",
  "lastName": "Smith",
  "isAlive": true,
  "age": 25,
  "address": {
    "streetAddress": "21 2nd Street",
    "city": "New York",
    "state": "NY",
    "postalCode": "10021-3100"
  },
  "phoneNumbers": [
    {
      "type": "home",
      "number": "212 555-1234"
    },
    {
      "type": "office",
      "number": "646 555-4567"
    },
    {
      "type": "mobile",
      "number": "123 456-7890"
    }
  ],
  "children": [],
  "spouse": null
}'


SELECT SQLHTTP.net.IsJsonValid(@Json)

DECLARE @Json nvarchar(MAX)

SET @Json = '{

"firstName": "John",

"lastName": "Smith",

"isAlive": true,

"age": 25,

"address": {

"streetAddress": "21 2nd Street",

"city": "New York",

"state": "NY",

"postalCode": "10021-3100"

"phoneNumbers": [

{

"type": "home",

"number": "212 555-1234"

{

"type": "office",

"number": "646 555-4567"

{

"type": "mobile",

"number": "123 456-7890"

}

"children": [],

"spouse": null

SELECT SQLHTTP.net.IsJsonValid(@Json)

-----



IsJsonValid

Featured API Wrapper Code / SQL Server