Returns the details of a Microsoft Excel spreadsheet stored on the CMS repository.
GET <webi_URL>/spreadsheets/{spreadsheetId}
Response type: application/xml or application/json
Response body: the details of the spreadsheet with the following information:
XML response:
<spreadsheet> <id>7168</id> <cuid>AQJqfTLbR5RNoYhzV9DnCMA</cuid> <name>MySheet</name> <folderId>6206</folderId> <path>Public Folders/Documents/</path> <updated>2014-07-17T14:27:44.367+02:00</updated> <createdBy>Administrator</createdBy> <file>myfile.xlsx</file> <size>22444</size> <mimeType>application/vnd.ms-excel</mimeType> <sheets> <sheet>sheet1</sheet> <sheet>sheet2</sheet> <sheet>sheet3</sheet> <sheet>sheet4</sheet> </sheets> <namedRanges> <range>items</range> <range>region</range> <range>region_item_units_cost</range> <range>sum_cost</range> <range>sum_units</range> </namedRanges> </spreadsheet>
JSON response:
{"spreadsheet": {"id":7168, "cuid":"AQJqfTLbR5RNoYhzV9DnCMA", "name":"MySheet", "folderId":6206, "path":"Public Folders\/Documents\/", "updated":"2014-07-17T10:34:19.763+02:00", "createdBy":"Administrator", "file":"myfile.xlsx", "size":22444, "mimeType":"application\/vnd.ms-excel", "sheets": [{"sheet":"sheet1"}, {"sheet":"sheet2"}, {"sheet":"sheet3"}, {"sheet":"sheet4"}], "namedRanges": [{"range":"items"}, {"range":"region"}, {"range":"region_item_units_cost"}, {"range":"sum_costs"}, {"range":"sum_units"}] } }