{"id":7140,"date":"2022-03-31T06:40:00","date_gmt":"2022-03-31T04:40:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=7140"},"modified":"2023-05-15T12:51:36","modified_gmt":"2023-05-15T10:51:36","slug":"manage-excel-data-type-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/","title":{"rendered":"Manage Excel data type with SSIS before integration"},"content":{"rendered":"\n<p class=\"has-text-align-center\"><em><strong>How to manage Excel column data type with SSIS with the sampling registry key?<\/strong><\/em><\/p>\n\n\n\n<p>The integration of Excel files via SSIS requires you to freeze the data type in the OLEDB component. This is because the Excel data type is determined in SSIS by sampling the first 8 rows of the default column in the OLEDB component for Excel sources. To manage Excel data type with SSIS, it is possible to change the sampling number of lines with registry key.<\/p>\n\n\n\n<p>Therefore, to integrate a XLSX file with the correct format you will need to ensure that the first few rows of the file are of the correct type. Or at least looks like so. For example, you can store numbers in a text column. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SSIS detects the type of Excel columns by sampling<\/h3>\n\n\n\n<p>Note that by default the number of lines sampled is 8. However, it is possible to change the number of lines sampled by Excel. More exactly the <strong><a href=\"https:\/\/expert-only.com\/en\/excel-tips\/download-and-install-the-oledb-driver-for-excel-2010\/\">Excel Access Database Engine 12.0 driver<\/a><\/strong>, by changing the registry key as below.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the registry editor, to do this go to the <strong>start menu<\/strong>, type <strong>regedit<\/strong>.<\/li>\n\n\n\n<li>Go to one of these registry keys, it depends on your installation and the driver used to read the Excel files:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Jet\\4.0\\Engines\\Excel<\/strong><\/li>\n\n\n\n<li><strong>HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Office\\16.0\\Access Connectivity Engine\\Engines\\Excel<\/strong><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>Then change the value of the key called <strong>TypeGuessRows<\/strong>, enter values <strong>between 0 and 16 in decimal<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"510\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling.jpg\" alt=\"Manage Excel data type with SSIS\" class=\"wp-image-25500\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling.jpg 934w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling-300x164.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling-768x419.jpg 768w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><figcaption class=\"wp-element-caption\"><em>Manage Excel data type with SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Excel file integration errors with SSIS<\/h2>\n\n\n\n<p>The most common error is trying to integrate an <a href=\"https:\/\/en.wiktionary.org\/wiki\/Excel\" target=\"_blank\" rel=\"noreferrer noopener\">Excel<\/a> file with columns that contains strings longer than 255 characters. If the sampled rows do not contain any strings longer than 255 characters. Moreover, the data type detected by SSIS in the Excel file that will be assigned to the column is: <strong>DT_WSTR(255)<\/strong>. And not <strong>N_TEXT<\/strong>, and all rows longer than 255 characters will be truncated.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Error integrating a mixed Excel column with text and numbers<\/h2>\n\n\n\n<p>Another classical error when you integrate Excel files is the DT_NUMERIC type instead of the DT_WSTR. For example, if the Excel column contains hundreds or thousands of lines, with numeric and characters, but the first 16 lines only contains numeric values. Then the SSIS system interprets it as a numeric column.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Other resources on Excel data integration using SSIS<\/h3>\n\n\n\n<p>The SSMS tutorial below explains how to <strong><a href=\"https:\/\/expert-only.com\/en\/ssms\/import-excel-to-sql-server-with-ssms\/\">import an Excel file into a SQL Server database using SSMS<\/a><\/strong> with no lines of codes.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"yIEtIrFmpg\"><a href=\"https:\/\/expert-only.com\/en\/ssms\/import-excel-to-sql-server-with-ssms\/\">Import data from Excel to SQL Server with SSMS and the Import and Export wizard<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Import data from Excel to SQL Server with SSMS and the Import and Export wizard&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssms\/import-excel-to-sql-server-with-ssms\/embed\/#?secret=ztrwoIgUGb#?secret=yIEtIrFmpg\" data-secret=\"yIEtIrFmpg\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to manage Excel column data type with SSIS with the sampling registry key? The integration of Excel files via SSIS requires you to freeze the data type in the OLEDB component. This is because the Excel data type <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\" title=\"Manage Excel data type with SSIS before integration\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6026,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[],"class_list":{"0":"post-7140","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Manage Excel data type with SSIS before integration - MS BI<\/title>\n<meta name=\"description\" content=\"To manage the Excel column data type detection with SSIS before the import into SQL Server, change the number of rows used for sampling.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Manage Excel data type with SSIS before integration\" \/>\n<meta property=\"og:description\" content=\"To manage the Excel column data type detection with SSIS before the import into SQL Server, change the number of rows used for sampling.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-31T04:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-15T10:51:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\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:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Manage Excel data type with SSIS before integration\",\"datePublished\":\"2022-03-31T04:40:00+00:00\",\"dateModified\":\"2023-05-15T10:51:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\"},\"wordCount\":423,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\",\"name\":\"Manage Excel data type with SSIS before integration - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg\",\"datePublished\":\"2022-03-31T04:40:00+00:00\",\"dateModified\":\"2023-05-15T10:51:36+00:00\",\"description\":\"To manage the Excel column data type detection with SSIS before the import into SQL Server, change the number of rows used for sampling.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Manage Excel data type with SSIS before integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Manage Excel data type with SSIS before integration - MS BI","description":"To manage the Excel column data type detection with SSIS before the import into SQL Server, change the number of rows used for sampling.","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:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/","og_locale":"en_US","og_type":"article","og_title":"Manage Excel data type with SSIS before integration","og_description":"To manage the Excel column data type detection with SSIS before the import into SQL Server, change the number of rows used for sampling.","og_url":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-03-31T04:40:00+00:00","article_modified_time":"2023-05-15T10:51:36+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Manage Excel data type with SSIS before integration","datePublished":"2022-03-31T04:40:00+00:00","dateModified":"2023-05-15T10:51:36+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/"},"wordCount":423,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg","articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/","url":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/","name":"Manage Excel data type with SSIS before integration - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg","datePublished":"2022-03-31T04:40:00+00:00","dateModified":"2023-05-15T10:51:36+00:00","description":"To manage the Excel column data type detection with SSIS before the import into SQL Server, change the number of rows used for sampling.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/motivation_dark_melbourne-city-center-buidings-83992FC8BF0_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Manage Excel data type with SSIS before integration"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/7140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=7140"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/7140\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/6026"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=7140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=7140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=7140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}