{"id":6163,"date":"2015-11-02T16:55:25","date_gmt":"2015-11-02T15:55:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"},"modified":"2015-11-02T16:55:25","modified_gmt":"2015-11-02T15:55:25","slug":"sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","title":{"rendered":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!"},"content":{"rendered":"

For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features.
\nAll info about CTP3 are on SQL Server Blog here<\/a>.<\/p>\n

I wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON<\/em><\/a><\/p>\n

With this new CTP version, JSON support has new enhancements and especially the OPENJSON function<\/strong>. When I wrote my blog, this option was not available.
\nThree other functions are available: JSON_VALUE<\/strong>, ISJSON<\/strong> and JSON_QUERY<\/strong>!
\nNow, it is time to test it! \u27a1<\/p>\n

OPENJSON<\/h3>\n

The TVF (Table-Value Function) OPENJSON<\/strong> is the easy way to import the JSON format directly in a table.
\nThe principle is simple as you can see on this picture.<\/p>\n

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

How it works? I want to do exactly what is in the picture below.<\/p>\n

\"JSON201\"<\/a>
\nAs you can see, I use double quotes (“) for all data type in the JSON format.
\nIn a second time, I delete all double quotes (“) from the Salary values.<\/p>\n

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

The result is the same as previously.
\nI will do the date for the HireDate values.<\/p>\n

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

As you can see in this latest test, it doesn’t work!
\nFinally, the best is to keep double quotes (“) in the JSON values.
\nIn JSON structure<\/a>, double quotes are just for string but in SQL Server you can use it for number without problems.<\/p>\n

For more information, msdn link here.<\/a><\/p>\n

JSON_VALUE<\/h3>\n

This function returns a single text with the value of your stored JSON text.
\nAs example, I create a database JSON_TEST with a table JSON_EmployeesList and a jsonContent in nvarchar(MAX) to store the json text in the variable @JsonEmployeesArray.<\/p>\n

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

I use JSON_VALUE function on the 4 objects in EmployeesArray<\/p>\n

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

As you can see, we have the first line of the jsonContent.
\nWhy? JSON_VALUE extracts only a scalar value<\/strong> and not an object or an array like JSON_QUERY<\/p>\n

For more information, msdn link here.<\/a><\/p>\n

ISJSON<\/h3>\n

It is a function used to test if your text is a JSON text and return 1 if it is true.<\/p>\n

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

In the query plan, you can see that the filter is applied with my ISJSON function<\/p>\n

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

For more information, msdn link here<\/a>.<\/p>\n

JSON_QUERY<\/h3>\n

This function is the twin of JSON_VALUE but like a twin, it is not really the same…
\nJSON_VALUE return a scalar value and JSON_QUERY returns an object or an array<\/strong> with the values of your stored JSON text.<\/p>\n

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

As you can see in my example, the JSON_QUERY function returns an array for EmployeesArray and EmployeesArray.Name.
\nFor EmployeesArray.Department, the function return NULL. Department in this example is not an array.<\/p>\n

For more information, msdn link here.<\/a><\/p>\n

To conclude, if you are very interested by these functionalities, you find on msdn a good comparison between these 3 functions here.<\/a>
\nSee you soon!<\/p>\n

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

For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON With this […]<\/p>\n","protected":false},"author":15,"featured_media":6173,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,48],"tags":[694,49,51,566],"type_dbi":[],"class_list":["post-6163","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","category-technology-survey","tag-json","tag-microsoft","tag-sql-server","tag-sql-server-2016"],"acf":[],"yoast_head":"\nSQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY\" \/>\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.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-02T15:55:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1231\" \/>\n\t<meta property=\"og:image:height\" content=\"659\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\",\"datePublished\":\"2015-11-02T15:55:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\"},\"wordCount\":483,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png\",\"keywords\":[\"json\",\"Microsoft\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Development & Performance\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\",\"name\":\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png\",\"datePublished\":\"2015-11-02T15:55:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png\",\"width\":1231,\"height\":659},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","description":"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY","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.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","og_description":"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","og_site_name":"dbi Blog","article_published_time":"2015-11-02T15:55:25+00:00","og_image":[{"width":1231,"height":659,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","datePublished":"2015-11-02T15:55:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"},"wordCount":483,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png","keywords":["json","Microsoft","SQL Server","SQL Server 2016"],"articleSection":["Development & Performance","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/","name":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png","datePublished":"2015-11-02T15:55:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"SQL Server 2016 with thennative JSON support has new functions: OPENJSON, JSON_VALUE, ISJSON and JSON_QUERY","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/JSON200-1.png","width":1231,"height":659},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-json-support-updated-with-sql-server-2016-ctp-3-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0!"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6163"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6173"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6163"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}