{"id":11017,"date":"2024-08-07T19:13:12","date_gmt":"2024-08-07T17:13:12","guid":{"rendered":"https:\/\/www.dynamicsproject.com\/?p=11017"},"modified":"2024-08-15T11:18:34","modified_gmt":"2024-08-15T09:18:34","slug":"sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren","status":"publish","type":"post","link":"https:\/\/www.dynamicsproject.com\/en\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html","title":{"rendered":"Import SQL Extended Events data automatically and time-controlled into an SQL database"},"content":{"rendered":"

In this article, we describe how to import extended SQL Server events data for the performance analysis of Business Central automatically and time-controlled into the V8 SQL database. <\/p>\n

Introduction<\/h6>\n

Query performance monitoring is one of the most important diagnostic methods for detecting queries with poor performance. However, sometimes this can be a bit tedious. Therefore, one should use appropriate tools such as V8 Search XE and methods such as SQL Server Extended Events to monitor and analyze query performance metrics. <\/p>\n

Most of our customers import data from the V8 Search XE Client manually on a daily basis. For this reason, we have decided to provide a template and show you in this article how to integrate this template into the SQL Server Agent.<\/p>\n

\n

\nFor those readers who do not use Business Central or V8 Search XE, there is also an option to use the import module (V8XELoader) from V8 Search XE as a standalone software application. SQL Server Extended Events do not affect SQL Server performance like the Profiler and also provide numerous events to help troubleshoot query performance and other issues. For example, to resolve deadlock issues, this can be the first option and in our opinion, it must be the first option. You can use the V8XELoader to import all SQL Extended Events files into an SQL database. It is possible to automatically create tables for the recorded events. <\/p>\n

If you are not yet familiar with SQL Extended Events, we will be happy to advise you.\n<\/p><\/div>\n

\n

Set up the PowerShell script (V8XELoaderTemplate.ps1) in the SQL Server agent<\/h4>\n

 Please note that SQL Server Express and Azure SQL DB do not contain a SQL Server Agent.<\/p>\n

Step 1<\/h6>\n

The V8XELoader module is a parameterized app and is normally started from the V8 Search XE Client. Depending on which task you want to fulfill with the V8XELoader, e.g. the import of SQL Extended Events files (XEvents) such as the \"Long Duration (LD)\", the parameters to be transferred are set up in the options of the V8 client.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

\n \"V8XELoader\n<\/div>\n

\n

These parameters must be entered manually in the PowerShell script \"V8XELoaderTemplate\". And saved in a new PowerShell script for the respective action. As a separate script is required for the action for each step in the SQL Server Agent.<\/p>\n

\n

\n \"V8XELoader\n<\/div>\n

\n

Step 2<\/h6>\n

In SQL Server Management Studio (SSMS), navigate to the \"Object Explorer\" section, go to the \"SQL Server Agent\" section, expand it and click on the \"New Job...\" option.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Step 3<\/h6>\n

On the very first screen that appears, enter the basic information as follows:<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Step 4<\/h6>\n

Click on \"Steps\" at the top left of \"Select page\" and then on the \"New\" button.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Step 5<\/h6>\n

On the screen that appears, enter the information as shown in the screenshot below and make sure that Type = \"PowerShell\".<\/p>\n

To call up the PS1 file, the PowerShell command is as follows:<\/p>\n

 PowerShell.exe -File \u201eC:\\…\\V8XELoaderTemplate.ps1\u201c<\/h6>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Step 6<\/h6>\n

Create the desired schedule for the PowerShell script in the \"Schedules\" section.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Step 7<\/h6>\n

In this demo, we will not go into the areas of \"Warnings\", \"Notifications\" and \"Destinations\".<\/p>\n

Then click on \"OK\" to create your job. It should now be displayed in the \"SQL Server Agent jobs\" section.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

To execute the job, right-click on it and select \"Start job at step\". The job should then start executing or wait for the scheduled execution time.<\/p>\n

How can I check the status of an order to see if it has been successfully completed? To answer this, you need to right-click on your order and select the \"Show history\" option.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

In this view, a green tick indicates that everything went well (if the job was not successful, the symbol is a red circle with a cross). This view also contains other useful information such as the job duration.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

You have several options in V8 Search XE to obtain information about the job.
\nNormally, the number of imported XEvents data and when opening the V8 Search XE client in the dashboard should have updated.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Another option is to execute a \"SELECT query\" from the SQL Server Management Studio (SSMS) for the \"V8 NLog\" table. Here you can check whether the import was successful. <\/p>\n

\n\"V8XELoader\n<\/div>\n

\n

 A little tip: You should empty the \"V8 NLog\" table in good time so that the database does not grow unnecessarily large.<\/p>\n

Alternatively, you can also use the TSQL Editor in V8 Search XE to check the \"V8 NLog\" table.<\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

For example, if you open the \"Long Duration XEvents\" dialog in the V8 Search XE Client, you can use the filter dialog to see the smallest and largest date of the existing imported SQL Extended Events data. <\/p>\n

\n

\n\"V8XELoader\n<\/div>\n

\n

\n

\n\"V8XELoader\n<\/div>\n

\n

Falls sie das V8XELoader PowerShell Script Template benutzen m\u00f6chten, schreiben Sie bitte eine kurze Mail an info@dynamicsproject.com. <\/a>. Sollten Sie Unterst\u00fctzung bei der Einrichtung ben\u00f6tigen, helfen wir ihnen nat\u00fcrlich gerne.<\/p>\n

\n

Your dynamicsproject.com Team<\/strong><\/p>","protected":false},"excerpt":{"rendered":"

In diesem Artikel beschreiben wir, wie man erweiterte SQL Server-Ereignisse Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren kann. Einf\u00fchrung Die \u00dcberwachung der Abfrageleistung ist eine der wichtigsten Diagnosemethoden, um Abfragen mit schlechter Leistung aufzudecken. Manchmal kann dies jedoch etwas m\u00fchsam sein. Daher sollte man geeignete Tools […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[201,200],"tags":[223,220,221,222],"class_list":["post-11017","post","type-post","status-publish","format-standard","hentry","category-dynamics-365-business-central","category-sql-server","tag-performanceanalyse-business-central","tag-sql-extended-events","tag-sql-server","tag-v8-search-xe"],"yoast_head":"\nSQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren - Dynamicsproject.com<\/title>\n<meta name=\"description\" content=\"SQL Server Extended Events Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren.\" \/>\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.dynamicsproject.com\/en\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren - Dynamicsproject.com\" \/>\n<meta property=\"og:description\" content=\"SQL Server Extended Events Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicsproject.com\/en\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamicsproject.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-07T17:13:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-15T09:18:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8XELoader-00-1024x406.png\" \/>\n<meta name=\"author\" content=\"InfoMaster\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InfoMaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\"},\"author\":{\"name\":\"InfoMaster\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#\\\/schema\\\/person\\\/88abb0921041778d8d2e371ae39e465c\"},\"headline\":\"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren\",\"datePublished\":\"2024-08-07T17:13:12+00:00\",\"dateModified\":\"2024-08-15T09:18:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\"},\"wordCount\":855,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/V8XELoader-00-1024x406.png\",\"keywords\":[\"Performanceanalyse Business Central\",\"SQL Extended Events\",\"SQL Server\",\"V8 Search XE\"],\"articleSection\":[\"Dynamics 365 Business Central\",\"SQL Server\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\",\"name\":\"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren - Dynamicsproject.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/V8XELoader-00-1024x406.png\",\"datePublished\":\"2024-08-07T17:13:12+00:00\",\"dateModified\":\"2024-08-15T09:18:34+00:00\",\"description\":\"SQL Server Extended Events Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/V8XELoader-00-1024x406.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/V8XELoader-00-1024x406.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/sql-server\\\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.dynamicsproject.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/\",\"name\":\"Dynamicsproject.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicsproject.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#organization\",\"name\":\"Dynamicsproject.com\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/DPLogo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dynamicsproject.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/DPLogo.jpg\",\"width\":350,\"height\":53,\"caption\":\"Dynamicsproject.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicsproject.com\\\/#\\\/schema\\\/person\\\/88abb0921041778d8d2e371ae39e465c\",\"name\":\"InfoMaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7bb40821f07f44f30706658f04de714269cabe761fe30c1499fc1d285aece5d6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7bb40821f07f44f30706658f04de714269cabe761fe30c1499fc1d285aece5d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7bb40821f07f44f30706658f04de714269cabe761fe30c1499fc1d285aece5d6?s=96&d=mm&r=g\",\"caption\":\"InfoMaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren - Dynamicsproject.com","description":"SQL Server Extended Events Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren.","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.dynamicsproject.com\/en\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\/","og_locale":"en_US","og_type":"article","og_title":"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren - Dynamicsproject.com","og_description":"SQL Server Extended Events Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren.","og_url":"https:\/\/www.dynamicsproject.com\/en\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html\/","og_site_name":"Dynamicsproject.com","article_published_time":"2024-08-07T17:13:12+00:00","article_modified_time":"2024-08-15T09:18:34+00:00","og_image":[{"url":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8XELoader-00-1024x406.png","type":"","width":"","height":""}],"author":"InfoMaster","twitter_misc":{"Written by":"InfoMaster","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#article","isPartOf":{"@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html"},"author":{"name":"InfoMaster","@id":"https:\/\/www.dynamicsproject.com\/#\/schema\/person\/88abb0921041778d8d2e371ae39e465c"},"headline":"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren","datePublished":"2024-08-07T17:13:12+00:00","dateModified":"2024-08-15T09:18:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html"},"wordCount":855,"publisher":{"@id":"https:\/\/www.dynamicsproject.com\/#organization"},"image":{"@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8XELoader-00-1024x406.png","keywords":["Performanceanalyse Business Central","SQL Extended Events","SQL Server","V8 Search XE"],"articleSection":["Dynamics 365 Business Central","SQL Server"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html","url":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html","name":"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren - Dynamicsproject.com","isPartOf":{"@id":"https:\/\/www.dynamicsproject.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage"},"image":{"@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8XELoader-00-1024x406.png","datePublished":"2024-08-07T17:13:12+00:00","dateModified":"2024-08-15T09:18:34+00:00","description":"SQL Server Extended Events Daten f\u00fcr die Performanceanalyse von Business Central automatisiert und zeitgesteuert in die V8 SQL Datenbank importieren.","breadcrumb":{"@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#primaryimage","url":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8XELoader-00-1024x406.png","contentUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2024\/08\/V8XELoader-00-1024x406.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicsproject.com\/sql-server\/sql-extended-events-daten-automatisiert-und-zeitgesteuert-importieren.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.dynamicsproject.com\/"},{"@type":"ListItem","position":2,"name":"SQL Extended Events Daten automatisiert und zeitgesteuert in eine SQL Datenbank importieren"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicsproject.com\/#website","url":"https:\/\/www.dynamicsproject.com\/","name":"Dynamicsproject.com","description":"","publisher":{"@id":"https:\/\/www.dynamicsproject.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicsproject.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dynamicsproject.com\/#organization","name":"Dynamicsproject.com","url":"https:\/\/www.dynamicsproject.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicsproject.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2015\/05\/DPLogo.jpg","contentUrl":"https:\/\/www.dynamicsproject.com\/wp-content\/uploads\/2015\/05\/DPLogo.jpg","width":350,"height":53,"caption":"Dynamicsproject.com"},"image":{"@id":"https:\/\/www.dynamicsproject.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.dynamicsproject.com\/#\/schema\/person\/88abb0921041778d8d2e371ae39e465c","name":"InfoMaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7bb40821f07f44f30706658f04de714269cabe761fe30c1499fc1d285aece5d6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7bb40821f07f44f30706658f04de714269cabe761fe30c1499fc1d285aece5d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7bb40821f07f44f30706658f04de714269cabe761fe30c1499fc1d285aece5d6?s=96&d=mm&r=g","caption":"InfoMaster"}}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/posts\/11017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/comments?post=11017"}],"version-history":[{"count":68,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/posts\/11017\/revisions"}],"predecessor-version":[{"id":11110,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/posts\/11017\/revisions\/11110"}],"wp:attachment":[{"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/media?parent=11017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/categories?post=11017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicsproject.com\/en\/wp-json\/wp\/v2\/tags?post=11017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}