{"id":3685,"date":"2019-03-25T17:45:29","date_gmt":"2019-03-25T20:45:29","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/storing-files-in-binary-mode-in-an-sql-server-database\/"},"modified":"2019-07-04T16:58:08","modified_gmt":"2019-07-04T19:58:08","slug":"storing-files-in-binary-mode-in-an-sql-server-database","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/","title":{"rendered":"Storing files in binary mode in an SQL Server database."},"content":{"rendered":"<div align=\"justify\">There are two ways you can store files in the database:<\/div>\n<div align=\"justify\">\n<ul>\n<li><b>Reference<\/b>: Files can be stored in a directory or via network sharing through their references. Example: If the <b>MSDN.PNG<\/b> file is in the <span style=\"font-family: Courier New;\">Z:\\Images\\ directory<\/span>, the stored reference is <span style=\"font-family: Courier New;\">Z:\\Images\\MSDN.PNG<\/span>.<\/li>\n<li><b>File<\/b>: Files can be stored directly on the database table.<\/li>\n<\/ul>\n<p>In this article, we&#8217;ll demonstrate how to save a file directly in an SQL Server database by using a<b> varbinary(max)<\/b> field on the table. This field supports binary data up to 2GB.<br \/>\nIn SQL Server, there are two types of binary large objects (BLOBs): <b>varbinary(max) default<\/b>, which stored data in tables, and <b>varbinary(max) FILESTREAM<\/b>, which store data in the files system. In this example, we&#8217;ll use <b>varbinary(max)<\/b> default.<\/p>\n<p><u><b>1. Creating a file storage table <\/b><\/u><br \/>\nTo create a table in SQL Server Management Studio, use the following syntax:<\/p>\n<div align=\"left\"><span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">CREATE TABLE<\/span> Arquivos<\/span><br \/>\n<span style=\"font-family: Courier New;\">(<\/span><br \/>\n<span style=\"font-family: Courier New;\">\u00a0\u00a0\u00a0 Id <span style=\"color: #0000ff;\">int<\/span>,<\/span><br \/>\n<span style=\"font-family: Courier New;\">\u00a0\u00a0\u00a0 Nome <span style=\"color: #0000ff;\">varchar<\/span>(50) not null,<\/span><br \/>\n<span style=\"font-family: Courier New;\">\u00a0\u00a0\u00a0 Arquivo <span style=\"color: #0000ff;\">varbinary<\/span>(<span style=\"color: #ff00ff;\">max<\/span>) not null<\/span><br \/>\n<span style=\"font-family: Courier New;\">)<\/span><\/div>\n<p><u><b>2. Adding data to the table <\/b><\/u><br \/>\nAfter creating the table, use <i>OpenRowSet <\/i>command alongside <i>Bulk <\/i>option to insert the desired file:<\/p>\n<div align=\"left\"><span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">INSERT INTO<\/span> Arquivos (Id, Nome, Arquivo) <\/span><br \/>\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Select <\/span>1, <span style=\"color: #ff0000;\">&#8216;file1.pdf&#8217;<\/span>, BulkColumn <\/span><br \/>\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">FROM Openrowset<\/span>( <span style=\"color: #0000ff;\">Bulk <\/span><span style=\"color: #ff0000;\">&#8216;C:\\Relatorio1.pdf&#8217;<\/span>, <span style=\"color: #0000ff;\">Single_Blob<\/span>) <span style=\"color: #0000ff;\">as <\/span>Arquivo <\/span><\/div>\n<p><u><b><br \/>\n3. Integrating file read\/record from Elipse E3 <\/b><\/u><br \/>\nFirst of all, you&#8217;ll need to create a Database in Elipse E3, and only then write and read data via E3Query and scripts.<\/p>\n<p>To <b><u>add the file<\/u><\/b> to the database, we&#8217;ll use this SQL clause in a query:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5381EN\/1.png\" alt=\"\" width=\"500\" height=\"404\" align=\"Baseline\" border=\"0\" hspace=\"0\" vspace=\"0\" \/><\/div>\n<p>To <u><b>send the file<\/b><\/u>, we&#8217;ll execute the query with the variables to be replaced. The following script can be used:<\/p>\n<div align=\"left\"><span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">If <\/span>Application.ShowFilePicker(<span style=\"color: #0000ff;\">true<\/span>, File,, 128, <span style=\"color: #ff0000;\">&#8220;Todos os arquivos|*.*&#8221;<\/span>) <span style=\"color: #0000ff;\">Then<\/span><\/span><br \/>\n<span style=\"font-family: Courier New;\">\u00a0\u00a0 VarPath = File<\/span><br \/>\n<span style=\"font-family: Courier New;\">\u00a0\u00a0 VarFileName = <span style=\"color: #990099;\">InputBox<\/span>(&#8220;File Name (Ex: file1.pdf, file1.doc, picture.png&#8230;)&#8221;) <\/span><br \/>\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Set <\/span>Consulta = Screen.Item(<span style=\"color: #ff0000;\">&#8220;Insert&#8221;<\/span>)<\/span><br \/>\n<span style=\"font-family: Courier New;\">Consulta.SetVariableValue <span style=\"color: #ff0000;\">&#8220;FileName&#8221;<\/span>, VarFileName<\/span><br \/>\n<span style=\"font-family: Courier New;\">Consulta.SetVariableValue <span style=\"color: #ff0000;\">&#8220;Path&#8221;<\/span>, VarPath<\/span><br \/>\n<span style=\"font-family: Courier New;\">Screen.Item(&#8220;Insert&#8221;).<span style=\"color: #0000ff;\">Execute(true)<\/span><\/span><br \/>\n<span style=\"color: #0000ff; font-family: Courier New;\">End If<\/span><\/div>\n<p>To <u><b>read<\/b><\/u> the file system&#8217;s binary data saved in the database, we&#8217;ll use ADODB.Stream component, which can read data for further storage in local disk. The following script and SQL query were used:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5381EN\/2.png\" alt=\"\" width=\"500\" height=\"404\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"left\"><span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Const <\/span>adTypeBinary = 1<\/span><br \/>\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Const <\/span>adSaveCreateOverWrite = 2<\/span><br \/>\n<span style=\"font-family: Courier New;\">arquivo = InputBox(<span style=\"color: #ff0000;\">&#8220;File Name:&#8221;<\/span>)<\/span><br \/>\n<span style=\"color: #339966; font-family: Courier New;\">&#8216;Consulta que busca o valor bin\u00e1rio do banco<\/span><br \/>\n<span style=\"font-family: Courier New;\">Screen.Item(<span style=\"color: #ff0000;\">&#8220;Consulta1&#8221;<\/span>).SetVariableValue &#8220;NomeVar&#8221;, arquivo<\/span><br \/>\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">set <\/span>rs = Screen.Item(<span style=\"color: #ff0000;\">&#8220;Consulta1&#8221;<\/span>).GetADORecordset()<\/span><br \/>\n<span style=\"font-family: Courier New;\">bin = rs.Fields.Item(<span style=\"color: #ff0000;\">&#8220;Arquivo&#8221;<\/span>).Value<\/span><\/p>\n<p><span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Set <\/span>outputStream = CreateObject(&#8220;ADODB.Stream&#8221;)<\/span><br \/>\n<span style=\"font-family: Courier New;\">outputStream.Type = 1 <span style=\"color: #339966;\">&#8216; adTypeBinary<\/span><\/span><br \/>\n<span style=\"font-family: Courier New;\">outputStream.Open<\/span><br \/>\n<span style=\"font-family: Courier New;\">outputStream.Write bin<\/span><br \/>\n<span style=\"font-family: Courier New;\">outputStream.SaveToFile <span style=\"color: #ff0000;\">&#8220;C:\\&#8221;<\/span> &#038; arquivo, adSaveCreateOverWrite<\/span><\/div>\n<p>For further information, run the attached demo application, developed in Elipse E3 version 4.7 build 300 alongside SQL Server 2008 R2.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5381EN\/3.png\" alt=\"\" width=\"500\" height=\"377\" align=\"Baseline\" border=\"0\" hspace=\"0\" vspace=\"0\" \/><\/div>\n<p><b>NOTE<\/b>: To make sure this example works properly, you must have an SQL Server database installed in the local computer (or another one on the same network that will grant it access). Next, set up the application&#8217;s Database object (<b>Database1<\/b>) and then create the table to store the files.<\/p>\n<\/div>\n<h3>Attachments:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/App5381.zip\">App5381.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are two ways you can store files in the database: Reference: Files can be stored in a directory or via network sharing through their references. Example: If the MSDN.PNG&hellip;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Storing files in binary mode in an SQL Server database. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Storing files in binary mode in an SQL Server database.\" \/>\n<meta property=\"og:description\" content=\"There are two ways you can store files in the database: Reference: Files can be stored in a directory or via network sharing through their references. Example: If the MSDN.PNG&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:45:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-04T19:58:08+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5381EN\/1.png\" \/>\n<meta name=\"author\" content=\"D\u00e9lio Damin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"D\u00e9lio Damin\" \/>\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:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\"},\"author\":{\"name\":\"D\u00e9lio Damin\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/be597eff34b5f24af940a55332870778\"},\"headline\":\"Storing files in binary mode in an SQL Server database.\",\"datePublished\":\"2019-03-25T20:45:29+00:00\",\"dateModified\":\"2019-07-04T19:58:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\"},\"wordCount\":479,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\",\"name\":\"[:pt]Storing files in binary mode in an SQL Server database.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:45:29+00:00\",\"dateModified\":\"2019-07-04T19:58:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Storing files in binary mode in an SQL Server database.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/be597eff34b5f24af940a55332870778\",\"name\":\"D\u00e9lio Damin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fdf251d36430f8dd22144c3f1bc53376?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fdf251d36430f8dd22144c3f1bc53376?s=96&d=mm&r=g\",\"caption\":\"D\u00e9lio Damin\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/delio\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Storing files in binary mode in an SQL Server database. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Storing files in binary mode in an SQL Server database.[:] - Elipse Knowledgebase","og_description":"There are two ways you can store files in the database: Reference: Files can be stored in a directory or via network sharing through their references. Example: If the MSDN.PNG&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:45:29+00:00","article_modified_time":"2019-07-04T19:58:08+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5381EN\/1.png"}],"author":"D\u00e9lio Damin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"D\u00e9lio Damin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/"},"author":{"name":"D\u00e9lio Damin","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/be597eff34b5f24af940a55332870778"},"headline":"Storing files in binary mode in an SQL Server database.","datePublished":"2019-03-25T20:45:29+00:00","dateModified":"2019-07-04T19:58:08+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/"},"wordCount":479,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/","url":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/","name":"[:pt]Storing files in binary mode in an SQL Server database.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:45:29+00:00","dateModified":"2019-07-04T19:58:08+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/storing-files-in-binary-mode-in-an-sql-server-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Storing files in binary mode in an SQL Server database."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/be597eff34b5f24af940a55332870778","name":"D\u00e9lio Damin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fdf251d36430f8dd22144c3f1bc53376?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fdf251d36430f8dd22144c3f1bc53376?s=96&d=mm&r=g","caption":"D\u00e9lio Damin"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/delio\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3685"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3685"}],"version-history":[{"count":3,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3685\/revisions"}],"predecessor-version":[{"id":7407,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3685\/revisions\/7407"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}