{"id":14681,"date":"2016-01-05T09:30:00","date_gmt":"2016-01-05T17:30:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/"},"modified":"2024-01-22T22:52:29","modified_gmt":"2024-01-23T06:52:29","slug":"json-in-sql-server-2016-part-1-of-4","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/","title":{"rendered":"JSON in SQL Server 2016: Part 1 of 4"},"content":{"rendered":"

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because a lot of data is formatted as JSON, it is important to enable SQL Server to process JSON text retrieved from other systems or to format information retrieved from SQL Server tables as JSON text.<\/p>\n

As the most-requested feature on the Microsoft SQL Server connect site, with more than 1,000 votes, support for JSON text processing has been added to SQL Server 2016. In this post, we will present a high-level overview of JSON functionality in SQL Server 2016.<\/p>\n

Overview<\/h1>\n

JSON functions in SQL Server enable you to analyze and query JSON data, transform JSON to relational format, and export SQL query results as JSON text.<\/p>\n

\"<\/a><\/p>\n

If you have JSON text, you can extract data from JSON or verify that JSON is properly formatted using built-in functions JSON_VALUE, JSON_QUERY, and ISJSON. For more advanced querying and analysis, the OPENJSON function can transform an array of JSON objects into a set of rows. Any SQL query can be executed on the returned result set. Finally, there is the FOR JSON clause that enables you to format query results as JSON text.<\/p>\n

We can start with simple examples. In the following Transact-SQL code, we will define a text variable where we will put JSON text:<\/p>\n

DECLARE<\/span> @json NVARCHAR<\/span>(<\/span>4000)<\/span><\/span>
SET<\/span> @json = <\/span>
N'{<\/span>
\u00a0\u00a0\u00a0 “info”:{\u00a0 <\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0 “type”:1,<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 “address”:{\u00a0 <\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 “town”:”Bristol”,<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 “county”:”Avon”,<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 “country”:”England”<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0 },<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0 “tags”:[“Sport”, “Water polo”]<\/span>
\u00a0\u00a0 },<\/span>
\u00a0\u00a0 “type”:”Basic”<\/span>
}’<\/span><\/p>\n

Now, we can extract values and objects from JSON text using the JSON_VALUE and JSON_QUERY functions:<\/p>\n

SELECT<\/span>
\u00a0 JSON_VALUE<\/span>(<\/span>@json,<\/span> ‘$.type’<\/span>)<\/span> as type<\/span>,<\/span>
\u00a0 JSON_VALUE<\/span>(<\/span>@json,<\/span> ‘$.info.address.town’<\/span>)<\/span> as<\/span> town,<\/span><\/span>
\u00a0 JSON_QUERY<\/span>(<\/span>@json,<\/span> ‘$.info.tags’<\/span>)<\/span> as<\/span> tags<\/span><\/p>\n

This query will return \u201cBasic\u201d, \u201cBristol\u201d, and [“Sport”, “Water polo”] values. The JSON_VALUE function returns one scalar value from JSON text (e.g. strings, numbers, true\/false) that is placed on a JSON path specified as the second parameter. JSON_QUERY returns an object or array (in this example an array of tags) on the JSON path. JSON built-in functions use JavaScript-like syntax to reference values and objects in JSON text via second parameter.<\/p>\n

The OPENJSON function enables you to reference some array in JSON text and return elements from that array:<\/p>\n

SELECT value<\/span>
FROM OPENJSON<\/span>(<\/span>@json,<\/span> ‘$.info.tags’<\/span>)<\/span><\/span><\/p>\n

In this example, string values from the tags array are returned. However, the OPENJSON function can return any complex object.<\/p>\n

Finally, there is a FOR JSON clause that can format any result set returned by SQL query as JSON text:<\/p>\n

SELECT<\/span> object_id<\/span>,<\/span> name<\/span>
FROM<\/span> sys.tables<\/span><\/span>
FOR JSON PATH<\/span><\/p>\n

Check out the other posts in this four-part series in the links below (as they become available), or\u00a0learn more in the SQL Server 2016 blogging series<\/a>.<\/p>\n

JSON in SQL Server 2016: Part 2 of 4<\/a><\/p>\n

JSON in SQL Server 2016: Part\u00a03 of 4<\/a><\/p>\n

JSON in SQL Server 2016: Part\u00a04 of 4<\/a><\/p>\n

\"Try<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because a lot of data is formatted as JSON, it is<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2424],"topic":[],"coauthors":[],"class_list":["post-14681","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-best-practices","review-flag-1593580770-633","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-4-1593580446-456"],"yoast_head":"\nJSON in SQL Server 2016: Part 1 of 4 - Microsoft SQL Server Blog<\/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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JSON in SQL Server 2016: Part 1 of 4 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because a lot of data is formatted as JSON, it is\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-05T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:52:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"JSON in SQL Server 2016: Part 1 of 4\",\"datePublished\":\"2016-01-05T17:30:00+00:00\",\"dateModified\":\"2024-01-23T06:52:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\"},\"wordCount\":508,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\",\"name\":\"JSON in SQL Server 2016: Part 1 of 4 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png\",\"datePublished\":\"2016-01-05T17:30:00+00:00\",\"dateModified\":\"2024-01-23T06:52:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JSON in SQL Server 2016: Part 1 of 4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JSON in SQL Server 2016: Part 1 of 4 - Microsoft SQL Server Blog","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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/","og_locale":"en_US","og_type":"article","og_title":"JSON in SQL Server 2016: Part 1 of 4 - Microsoft SQL Server Blog","og_description":"JSON is currently one of the most commonly used data exchange formats. Most modern services return information formatted as JSON text; web browsers use information formatted as JSON. JSON is the common format when semi-structured information needs to be stored, such as in files. Because a lot of data is formatted as JSON, it is","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2016-01-05T17:30:00+00:00","article_modified_time":"2024-01-23T06:52:29+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"JSON in SQL Server 2016: Part 1 of 4","datePublished":"2016-01-05T17:30:00+00:00","dateModified":"2024-01-23T06:52:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/"},"wordCount":508,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/","name":"JSON in SQL Server 2016: Part 1 of 4 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png","datePublished":"2016-01-05T17:30:00+00:00","dateModified":"2024-01-23T06:52:29+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/JSON20functions20in20SQL20Server.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2016\/01\/05\https://www.microsoft.com/json-in-sql-server-2016-part-1-of-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"JSON in SQL Server 2016: Part 1 of 4"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14681"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=14681"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/14681\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=14681"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=14681"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=14681"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=14681"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=14681"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=14681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}