Octopus reporting with an Excel template

To help you get started, we provide a sample Excel spreadsheet that you can connect to your own Octopus Server.

Getting started

The fastest way to get started is to use our Excel spreadsheet template. The spreadsheet uses Pivot Tables and Pivot Charts to summarize the data. You can use it as a starting point, and then modify or adapt it to suit your needs.

First, download the template and open it in Excel. The template fetches data from our public Demo Octopus Server.

Please make sure you unblock the file after downloading it, otherwise you may get a misleading error message like: The file is corrupt and cannot be opened

To change the source of the data:

  1. Go to the DATA ribbon tab in Excel, then click Queries & Connections:

  2. Select the Octopus Deployment history connection, then click Properties…

  3. Go to the Definition tab, then click Browse…

  4. In the Select Data Source menu, instead of selecting a file, enter your reporting URL, then Open. To get your reporting URL, see the section below on Using the XML Feed.

Refreshing the data

Once you have set up your connection, you can refresh the data from the source whenever you like. If you make your own customizations to the spreadsheet, you can save them, and simply refresh the data in the sheet whenever you like.

Using the XML feed

The best way to consume reporting data from Octopus is using the XML feed. The feed is always available at:

https://<OCTOPUS-SERVER>/api/reporting/deployments/xml?apikey=<API-KEY>

Where:

  • <OCTOPUS-SERVER> is the hostname of your Octopus Server
  • <API-KEY> is one of your API keys

For example:

https://demo.octopus.app/api/reporting/deployments/xml?apikey=API-GUEST

https://your-octopus-url/api/reporting/deployments/xml?apikey=API-1234567891234567891234567

The XML feed can be consumed programmatically, or via Excel or Microsoft PowerBI. We have a blog on how to do this using PowerBI

Since a user-specific API key is used to consume the data, only data that the user can see will appear in the report.

If you encounter the following error when using your own Octopus Server

Unhandled exception from web server: The parameter is incorrect
System.Net.HttpListenerException (0x80004005): The parameter is incorrect
at System.Net.HttpResponseStream.Dispose(Boolean disposing)
at System.IO.Stream.Close()
at Octopus.Server.Web.OctopusNancyHost.OutputWithDefaultTransferEncoding(Response nancyResponse, HttpListenerResponse response) in Y:\work\refs\tags\3.2.0\source\Octopus.Server\Web\OctopusNancyHost.cs:line 353
at Octopus.Server.Web.OctopusNancyHost.ConvertNancyResponseToResponse(NancyContext nancyRequest, Response nancyResponse, HttpListenerResponse response) in Y:\work\refs\tags\3.2.0\source\Octopus.Server\Web\OctopusNancyHost.cs:line 339
at Octopus.Server.Web.OctopusNancyHost.Process(HttpListenerContext ctx) in Y:\work\refs\tags\3.2.0\source\Octopus.Server\Web\OctopusNancyHost.cs:line 447

This is due to that the revocation information for the certificate is not retrievable, to get around it, do the following

  1. Click New Source….
  2. Data Feed.
  3. Fill in your URL in the Link or File: field.
  4. Click Browse….
  5. This should give you a Security Alert “Revocation information for the security certificate for this site is not available. Do you want to proceed?”
  6. Click Yes.
  7. Cancel the File Open dialog.
  8. Cancel the Data Connection Wizard.
  9. Paste the URL in the File Name field.

Learn more

Help us continuously improve

Please let us know if you have any feedback about this page.

Send feedback

Page updated on Thursday, June 27, 2024