[DRAFT] Setting up the compliance reporting integration

To utilise this integration, you must do the following:

Step 1: Create a custom report

1. As a Fuse site admin, go to the Admin Panel and click Reporting (Beta).

   

2. In the Create a custom report section, select a custom the report you wish to create, ensuring that you give it a easily recognisable title and that you have applied the desired filters so that it contains the data you need. For more information on how to create a custom report, see Creating a custom report.

   

Step 2: Share the title or ID of the report

Once you have created the custom report, share either the title of the report or the report ID with the person in your organisation responsible for building integrations via RESTful API.

• The title of the report you have created can be obtained in the Custom reports list in the Custom reports screen:

  

• You can obtain the ID of a report by editing it and copying the ID from the URL. For information on how to edit a report, see Editing an existing report.

  

Step 3: Building the integration via API

Once the person responsible for building the integration has the title or ID of the custom report, they can start the process of building the integration using Fuse’s RESTful APIs, and to retrieve the designated report data. To do this, they must have access to the necessary RESTful API endpoints listed below.

Required API endpoints

The following RESTful API endpoints can be used to retrieve the data from reports:

GET: Retrieve the details of a report using the report title

The following GET request can be used to obtain the details of the report:

GET /compliance_reporting/reports/all

GET: https://<instance>.fuseuniversal.com/api/v4.4/compliance_reporting/reports/all?query=<title_of_required_report>&auth_token==xxxxx

The above will return the following response:

{
  "total_count": 1,
  "last_page": true,
  "reports": [
    {
      "title": "Title of Report",             <---- Title of the report
      "id": 987654321,                         <---- ID of the report
      "report_created_by": "Report Owner",
      "created_at": "2024-02-22T12:05:58.000Z",
      "report_type_code": "learning_plan_status_custom",
      "tag": "Learning plan report",
      "executions": [
        {
          "execution_id": 12345678,             <---- Execution ID of the report
          "started_at": "2024-02-26 23:01:48",
          "report_executed_by": 12040315,
          "report_status": "success",
          "report_download_url": "https://fusion-universal-assets-production.s3-eu-west-1.amazonaws.com/report-engine/xxxxxx"
        },
     ]
    }
  ]
}

Obtain a signed AWS download link to download the latest execution ID

GET /compliance_reporting/download_report/{execution_id}

GET: https://<instance_name>.fuseuniversal.com/api/v4.4/compliance_reporting/download_report/<execution_id>?auth_token=<valid_auth_token>

The above will return the following response:

{
  "success": true,
  "signed_download_url": "https://fusion-universal-assets-production.s3-eu-west-1.amazonaws.com/report-engine/xxxxxxx"
}

 To get the download URL for a report generated using the “Reporting (Beta)” tool via the Fuse Admin page, run the below API Request URL to get the signed S3 download link: