Collect data from Atlassian Confluence

This article will show you how to create an Element using a Atlassian Confluence plugin as a data source. It assumes that you have already established connectivity to your Atlassian Confluence account.

Use Case

Use Case

Atlassian Confluence plugin scans all existing articles in Confluence and extracts only those, which have at least one table included. Such tables are treated as source Reports.

In the given example the table on this Confluence page may serve as a source for a Report in Metric Insights.

1. Access New > Report

Access New > Report
  1. Name the Report: Define a unique descriptive name of your element
  2. Reported: choose the measurement interval from the drop-down list
  3. Category: define a category this element belongs to
  4. To move on to defining data collection details, click Next: Define Report

2. Full Editor displays the Data Collection tab

  1. Data Source: select the account you have created for Atlassian Confluence
  2. Data Collection Schedule: Specify the trigger that will be used to collect the data for your report
  3. Table: Choose the name of the table which should serve as a basis of this Report
  4. Query: the standard query for pulling all data fro the table is:
  1. Once you are ready with you command, click Show Data.

3. Resulting Report columns

If your request syntax is valid, the statement box is green; if there are any errors, the box is colored in red and errors will be explained in the field below. If the request is validated successfully, the Report Columns table is to be displayed below the statement box.

Enable and Publish your Report.