{"id":2659,"date":"2023-11-28T07:55:32","date_gmt":"2023-11-28T15:55:32","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=2659"},"modified":"2026-02-23T11:37:43","modified_gmt":"2026-02-23T19:37:43","slug":"data-api-builder-0-9-7-released","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/data-api-builder-0-9-7-released\/","title":{"rendered":"Data API builder 0.9.7 Released"},"content":{"rendered":"<p>There has been a lot of news and exciting announcements in the past days and Data API builder now join the long list of releases that you don&#8217;t want to miss. Version 0.9.7 introduces some interesting features, especially around observability and logging, to make it easier to figure out what&#8217;s going on behind the scenes.<\/p>\n<h2 id=\"enable-application-insights-when-self-hosting-dab\">Enable Application Insights when self-hosting DAB<\/h2>\n<p>Logs can now be streamed to Application Insights for a better monitoring and debugging experience, especially when Data API builder is deployed in Azure. A new\u00a0<code>telemetry<\/code>\u00a0section can be added to the configuration file to enable and configure integration with Application Insights:<\/p>\n<pre class=\"prettyprint language-json\"><code class=\"language-json\">\"telemetry\": { \n    \"application-insights\": { \n        \"enabled\": true, \/\/ To enable\/disable application insights telemetry \n        \"connection-string\": \"{APP_INSIGHTS_CONNECTION_STRING}\" \/\/ Application Insights connection string to send telemetry \n    } \n}<\/code><\/pre>\n<p>Read all the details in the\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/data-api-builder\/use-application-insights\" data-linktype=\"relative-path\">Use Application Insights<\/a>\u00a0documentation page.<\/p>\n<h2 id=\"support-for-ignoring-extraneous-fields-in-rest-request-body\">Ignore extraneous fields in rest request body<\/h2>\n<p>With the new <code>request-body-strict<\/code> option, you can now decide if having extra field in the REST payload generates an error (default behavior, backward compatible) or the extra fields is just silently ignored.<\/p>\n<pre class=\"prettyprint language-json\"><code class=\"language-json\">\"runtime\": { \n    \"rest\": { \n        \"enabled\": true, \n        \"path\": \"\/api\", \n        \"request-body-strict\": true \n    }, \n    ... \n}<\/code><\/pre>\n<p>By setting the\u00a0<code>request-body-strict<\/code>\u00a0option to\u00a0<code>false<\/code>, fields that don&#8217;t have a mapping to the related database object are ignored without generating any error.<\/p>\n<h2 id=\"adding-application-name-for-mssql-connections\">Adding Application Name for\u00a0<code>mssql<\/code>\u00a0connections<\/h2>\n<p>Data API builder now injects in the connection string, for\u00a0<code>mssql<\/code>\u00a0database types only, the value\u00a0<code>dab-&lt;version&gt;<\/code>\u00a0as the\u00a0<code>Application Name<\/code>\u00a0property, making easier to identify the connections in the database server. If\u00a0<code>Application Name<\/code>\u00a0is already present in the connection string, Data API builder version is appended to it.<\/p>\n<h2 id=\"support-time-data-type-in-mssql\">Support\u00a0<code>time<\/code>\u00a0data type in\u00a0<code>mssql<\/code><\/h2>\n<p><code>time<\/code>\u00a0data type is now supported in\u00a0<code>mssql<\/code>\u00a0databases.<\/p>\n<h2 id=\"mutations-on-table-with-triggers-for-mssql\">Mutations on table with triggers for\u00a0<code>mssql<\/code><\/h2>\n<p>Mutations are now fully supported on tables with triggers for\u00a0<code>mssql<\/code>\u00a0databases.<\/p>\n<h2 id=\"preventing-updateinsert-of-read-only-fields-in-a-table-by-user\">Automatically detect read-only fields in a table<\/h2>\n<p>Automatically detect read-only fields the database and prevent users to update\/insert those fields.<\/p>\n<h2 id=\"complete-list-of-fixes\">Complete list of fixes<\/h2>\n<p>Take a look at\u00a0<a href=\"https:\/\/github.com\/Azure\/data-api-builder\/releases\/tag\/v0.9.7\" data-linktype=\"external\">0.9.7 GitHub release page<\/a>\u00a0for a comprehensive list of all the changes and improvements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There has been a lot of news and exciting announcements in the past days and Data API builder now join the long list of releases that you don&#8217;t want to miss. Version 0.9.7 introduces some interesting features, especially around observability and logging, to make it easier to figure out what&#8217;s going on behind the scenes. [&hellip;]<\/p>\n","protected":false},"author":24720,"featured_media":2563,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,597],"tags":[409,560,504,596,410],"class_list":["post-2659","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-data-api-builder-2","tag-api","tag-data-api-builder","tag-graphql","tag-openapi","tag-rest"],"acf":[],"blog_post_summary":"<p>There has been a lot of news and exciting announcements in the past days and Data API builder now join the long list of releases that you don&#8217;t want to miss. Version 0.9.7 introduces some interesting features, especially around observability and logging, to make it easier to figure out what&#8217;s going on behind the scenes. [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/2659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/24720"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=2659"}],"version-history":[{"count":1,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/2659\/revisions"}],"predecessor-version":[{"id":6622,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/2659\/revisions\/6622"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/2563"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=2659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=2659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=2659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}