4.1 Retrieve the Entity Container for the Content of a Workbook

  • Article

The following example illustrates the exchange of messages required for a client to retrieve the entity container for the content of the Sales.xlsx workbook.

Request

 GET /_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/ HTTP/1.1
 Accept: application/atom+xml
 Host: www.contoso.com

Response

 HTTP/1.1 200 OK
 Cache-Control: private
 Content-Type: application/atom+xml;charset=utf-8
 Server: Microsoft-IIS/7.5
 SPRequestGuid: 63c0d5ca-8b6e-43bf-92a5-d6ed45210f5b
 X-SharePointHealthScore: 4
 X-AspNet-Version: 2.0.50727
 X-Powered-By: ASP.NET
 MicrosoftSharePointTeamServices: 14.0.0.4732
 Date: Wed, 20 Jan 2010 19:48:13 GMT
 Content-Length: 3158
  
 <?xml version="1.0" encoding="utf-8" standalone="yes"?>
 <feed xmlns="http://www.w3.org/2005/Atom" xmlns:x="http://schemas.microsoft.com/office/2008/07/excelservices/rest" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservice" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
   <title type="text">Model</title>
   <id>http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/</id>
   <updated>2010-01-20T19:48:13Z</updated>
   <author>
     <name />
   </author>
   <link rel="self" href="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/" title="Model" />
   <entry>
     <category term="ExcelServices.Ranges" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
     <title>Ranges</title>
     <id>http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Ranges</id>
     <updated>2010-01-20T19:48:13Z</updated>
     <author>
       <name />
     </author>
     <link rel="alternate" href="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Ranges?$format=atom" title="Ranges" />
     <content type="application/atom+xml;charset=utf-8" src="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Ranges?$format=atom" />
   </entry>
   <entry>
     <category term="ExcelServices.Charts" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
     <title>Charts</title>
     <id>http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Charts</id>
     <updated>2010-01-20T19:48:13Z</updated>
     <author>
       <name />
     </author>
     <link rel="alternate" href="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Charts?$format=atom" title="Charts" />
     <content type="application/atom+xml;charset=utf-8" src="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Charts?$format=atom" />
   </entry>
   <entry>
     <category term="ExcelServices.Tables" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
     <title>Tables</title>
     <id>http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Tables</id>
     <updated>2010-01-20T19:48:13Z</updated>
     <author>
       <name />
     </author>
     <link rel="alternate" href="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Tables?$format=atom" title="Tables" />
     <content type="application/atom+xml;charset=utf-8" src="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/Tables?$format=atom" />
   </entry>
   <entry>
     <category term="ExcelServices.PivotTables" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
     <title>PivotTables</title>
     <id>http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/PivotTables</id>
     <updated>2010-01-20T19:48:13Z</updated>
     <author>
       <name />
     </author>
     <link rel="alternate" href="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/PivotTables?$format=atom" title="PivotTables" />
     <content type="application/atom+xml;charset=utf-8" src="http://www.contoso.com/_vti_bin/ExcelRest.aspx/Cycles/Sales.xlsx/Model/PivotTables?$format=atom" />
   </entry>
 </feed>