{"id":9967,"date":"2019-03-01T08:33:06","date_gmt":"2019-03-01T08:33:06","guid":{"rendered":"https:\/\/dbtut.com\/?p=9967"},"modified":"2020-12-07T07:20:14","modified_gmt":"2020-12-07T07:20:14","slug":"json-text-is-not-properly-formatted","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/","title":{"rendered":"JSON text is not properly formatted"},"content":{"rendered":"

If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred.<\/p>\n

Msg 13609, Level 16, State 7, Line 13<\/em><\/span><\/p>\n

JSON text is not properly formatted. Unexpected character is found at position.<\/em><\/span><\/p>\n

Be sure that the JSON data is correct. You can check whether its correct or not using ISJSON function. You can find detailed information about JSON functions in the article named “JSON Functions in SQL Server(TSQL)<\/a>”<\/p>\n

For Example execute the below script. As you can see an error will be occured.<\/p>\n\n

DECLARE @json_data NVARCHAR(4000)\r\nSET @json_data=N'{  \r\n    \"Person\": {    \r\n       \"Name\": \"Nurullah CAKIR\",\r\n       \"Friends\": [\"Faruk ERDEM\", \"Hakan GURBASLAR\", \"Ogun OZALP\"]\r\n    }'\r\n\r\nSET @json_data=JSON_MODIFY(@json_data,'$.Person.Name','Faruk ERDEM')\r\n\r\nprint @json_data\r\n<\/pre>\n
\"\"<\/p>\n
If you change the JSON data as below, the problem will be corrected.<\/p>\n
DECLARE @json_data NVARCHAR(4000)\r\nSET @json_data=N'{  \r\n    \"Person\": {    \r\n       \"Name\": \"Nurullah CAKIR\",\r\n       \"Friends\": [\"Faruk ERDEM\", \"Hakan GURBASLAR\", \"Ogun OZALP\"]\r\n\t   }\r\n    }'\r\n\r\nSET @json_data=JSON_MODIFY(@json_data,'$.Person.Name','Faruk ERDEM')\r\n\r\nprint @json_data\r\n<\/pre>\n
You can find online json formatter to check your json is valid on the web.<\/p>\n
In addition you can find usefult json examples on article JSON Comment Tutorial with Examples<\/a><\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State 7, Line 13 JSON text is not properly formatted. Unexpected character is found at position. Be sure that the JSON data is correct. You can check whether its correct or …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[2263,2264],"class_list":["post-9967","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-json-text-is-not-properly-formatted","tag-json-text-is-not-properly-formatted-unexpected-character-is-found-at-position"],"aioseo_notices":[],"yoast_head":"\nJSON text is not properly formatted - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JSON text is not properly formatted - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State 7, Line 13 JSON text is not properly formatted. Unexpected character is found at position. Be sure that the JSON data is correct. You can check whether its correct or …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-01T08:33:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-07T07:20:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"JSON text is not properly formatted\",\"datePublished\":\"2019-03-01T08:33:06+00:00\",\"dateModified\":\"2020-12-07T07:20:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\"},\"wordCount\":140,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png\",\"keywords\":[\"JSON text is not properly formatted\",\"JSON text is not properly formatted. Unexpected character is found at position.\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\",\"name\":\"JSON text is not properly formatted - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png\",\"datePublished\":\"2019-03-01T08:33:06+00:00\",\"dateModified\":\"2020-12-07T07:20:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png\",\"width\":893,\"height\":454},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JSON text is not properly formatted\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JSON text is not properly formatted - Database Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/","og_locale":"en_US","og_type":"article","og_title":"JSON text is not properly formatted - Database Tutorials","og_description":"If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State 7, Line 13 JSON text is not properly formatted. Unexpected character is found at position. Be sure that the JSON data is correct. You can check whether its correct or …","og_url":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/","og_site_name":"Database Tutorials","article_published_time":"2019-03-01T08:33:06+00:00","article_modified_time":"2020-12-07T07:20:14+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"JSON text is not properly formatted","datePublished":"2019-03-01T08:33:06+00:00","dateModified":"2020-12-07T07:20:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/"},"wordCount":140,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png","keywords":["JSON text is not properly formatted","JSON text is not properly formatted. Unexpected character is found at position."],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/","url":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/","name":"JSON text is not properly formatted - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png","datePublished":"2019-03-01T08:33:06+00:00","dateModified":"2020-12-07T07:20:14+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c78edfbd9a3c.png","width":893,"height":454},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/01\/json-text-is-not-properly-formatted\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"JSON text is not properly formatted"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9967"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9967\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}