{"id":123,"date":"2023-11-15T15:30:00","date_gmt":"2023-11-15T15:30:00","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/"},"modified":"2023-12-06T11:41:56","modified_gmt":"2023-12-06T11:41:56","slug":"remover-duplicatas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/","title":{"rendered":"Como remover duplicatas usando o power query?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3749274572\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-325773442\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial aprenderemos como remover valores duplicados dos dados.<\/p><h2 class=\"wp-block-heading\"> Etapas para remover duplicatas com Power Query<\/h2><p> Abaixo voc\u00ea tem uma lista de nomes onde temos nomes duplicados, e agora voc\u00ea precisa usar o PowerQuery para remover esses valores duplicados. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88958\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png\" sizes=\"auto, \" srcset=\"\" alt=\"remover duplicatas usando consulta avan\u00e7ada\" width=\"446\" height=\"261\"><\/figure><\/div><p> Voc\u00ea pode usar as etapas abaixo:<\/p><ol><li> Primeiro, selecione os dados e v\u00e1 para a guia Dados &gt; Obter e transformar dados &gt; Obter dados &gt; De outras fontes &gt; Da tabela\/intervalo. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-obter dados do intervalo da tabela\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-des-donnees-a-partir-de-la-plage-de-la-table.png\" sizes=\"auto, \" srcset=\"\" alt=\"get-data-from-table-range\" width=\"507\" height=\"342\"><\/li><li> Depois disso, clique em OK para converter seus dados em uma tabela Excel (se ainda n\u00e3o for uma tabela Excel). <br><img loading=\"lazy\" decoding=\"async\" title=\"3-converter dados em tabela do Excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-convertir-les-donnees-en-tableau-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"convert-the-data-into-excel-table\" width=\"425\" height=\"159\"><\/li><li> Agora, quando voc\u00ea clica em OK, ele abre o editor do Power Query e carrega os dados l\u00e1. <br><img loading=\"lazy\" decoding=\"async\" title=\"Editor de 4 carregamentos de dados no power-query\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-chargez-les-donnees-dans-lediteur-de-requetes-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"load-the-data-into-power-query-editor\" width=\"718\" height=\"304\"><\/li><li> Depois disso, na aba Home, clique no menu suspenso \u201cExcluir linhas\u201d e a seguir clique na op\u00e7\u00e3o \u201cRemover duplicatas\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-escolha a op\u00e7\u00e3o de remover duplicatas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-choisissez-loption-de-suppression-des-doublons.png\" sizes=\"auto, \" srcset=\"\" alt=\"choose-remove-duplicates-option\" width=\"562\" height=\"280\"><\/li><\/ol><p> Quando voc\u00ea clica nele, os nomes duplicados s\u00e3o removidos da lista e voc\u00ea fica com apenas nomes exclusivos. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88963\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-ne-laisse-que-les-valeurs-uniques.png\" sizes=\"auto, \" srcset=\"\" alt=\"deixe apenas os valores exclusivos\" width=\"490\" height=\"289\"><\/figure><\/div><p> Acima, a barra de status exibe o n\u00famero de linhas com valores duplicados e sem valores duplicados. Al\u00e9m da aba \u201cHome\u201d, voc\u00ea pode clicar com o bot\u00e3o direito no cabe\u00e7alho da coluna e clicar na op\u00e7\u00e3o \u201cRemover Duplicados\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88964\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-la-barre-detat-affiche-le-nombre-de-lignes-avec-et-sans-valeurs-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"barra de status mostra o n\u00famero de linhas com e sem valores duplicados\" width=\"420\" height=\"256\"><\/figure><\/div><p> Esta \u00e9 a mesma op\u00e7\u00e3o que voc\u00ea usou nas etapas acima e faz exatamente isso.<\/p><h2 class=\"wp-block-heading\"> Removendo duplicatas quando voc\u00ea tem v\u00e1rias colunas<\/h2><p> Se voc\u00ea tiver v\u00e1rias colunas de dados, a Consulta Avan\u00e7ada oferece duas maneiras diferentes de remover valores duplicados.<\/p><p> No exemplo abaixo voc\u00ea tem duas colunas, nomes e pontua\u00e7\u00f5es. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88965\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-supprimer-les-doublons-lorsquil-y-a-plusieurs-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"remover-duplicadas-quando-t\u00eam-m\u00faltiplas-colunas\" width=\"488\" height=\"244\"><\/figure><\/div><p> Agora, se voc\u00ea deseja remover duplicatas considerando duplicatas de ambas as colunas, voc\u00ea precisa selecionar ambas as colunas e usar a op\u00e7\u00e3o \u201cRemover Duplicadas\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88966\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-selectionnez-les-deux-colonnes-et-cliquez-sur-supprimer-les-colonnes-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"selecione ambas as colunas e clique em excluir colunas duplicadas\" width=\"770\" height=\"361\"><\/figure><\/div><p> E voc\u00ea s\u00f3 pode ver uma linha duplicada quando a consideramos selecionando colunas.<\/p><h2 class=\"wp-block-heading\"> Informa\u00e7\u00f5es sobre valores duplicados<\/h2><p> No Power Query, voc\u00ea tamb\u00e9m pode alterar a exibi\u00e7\u00e3o de dados para obter o n\u00famero de valores duplicados. V\u00e1 para a guia Exibir&gt; Divis\u00e3o de colunas. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88967\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-informations-sur-les-valeurs-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"informa\u00e7\u00f5es sobre valores duplicados\" width=\"618\" height=\"322\"><\/figure><\/div><p> Acima voc\u00ea pode ver quantos valores \u00fanicos e distintos voc\u00ea possui em cada coluna.<\/p><h2 class=\"wp-block-heading\"> Mantenha valores duplicados<\/h2><p> Existe uma op\u00e7\u00e3o que permite manter duplicatas e remover valores exclusivos. Guia inicial &gt; Manter linhas &gt; Manter duplicatas. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88968\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-conserver-les-valeurs-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"manter valores duplicados\" width=\"548\" height=\"273\"><\/figure><\/div><div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/solicitacao-de-energia\/\">Consulta avan\u00e7ada no Excel (tutorial)<\/a><h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6e9de105\"><div class=\"gb-container gb-container-6e9de105\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/pesquisav-2\/\">Execute VLOOKUP no Power Query no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/corrente\/\">Power Query: concatenar valores (texto e n\u00fameros)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/diferenca-de-datas\/\">Consulta avan\u00e7ada: diferen\u00e7a de data<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-4eaecde3\"><div class=\"gb-container gb-container-4eaecde3\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formulas-de-funcao\/\">Power Query: fun\u00e7\u00f5es e f\u00f3rmulas<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/o-texto-contem\/\">Power Query: SE o texto contiver<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/a-data-hoje\/\">Power Query: obtenha a data de hoje<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-123","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Como remover duplicatas usando o Power Query?<\/title>\n<meta name=\"description\" content=\"O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial, aprenderemos como...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como remover duplicatas usando o Power Query?\" \/>\n<meta property=\"og:description\" content=\"O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial, aprenderemos como...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:41:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/\",\"name\":\"\u25b7 Como remover duplicatas usando o Power Query?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png\",\"datePublished\":\"2023-11-15T15:30:00+00:00\",\"dateModified\":\"2023-12-06T11:41:56+00:00\",\"description\":\"O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial, aprenderemos como...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como remover duplicatas usando o power query?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Como remover duplicatas usando o Power Query?","description":"O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial, aprenderemos como...","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:\/\/exceladvisor.org\/pt\/remover-duplicatas\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como remover duplicatas usando o Power Query?","og_description":"O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial, aprenderemos como...","og_url":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:41:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/","url":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/","name":"\u25b7 Como remover duplicatas usando o Power Query?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png","datePublished":"2023-11-15T15:30:00+00:00","dateModified":"2023-12-06T11:41:56+00:00","description":"O Power Query permite remover duplicatas de dados, assim como no Excel. E neste tutorial, aprenderemos como...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-supprimer-les-doublons-a-laide-de-power-query.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/remover-duplicatas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como remover duplicatas usando o power query?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/123\/revisions"}],"predecessor-version":[{"id":1170,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/123\/revisions\/1170"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}