# Ad-hoc analysis

* cQube enables download of computed metrics for analysis outside cQube by using any third party tool like Excel, METABASE, Tableau, KNIME or any other similar tool.
* Users can download the JSON files from the S3 output bucket through the API.
* The example spec for the download API will be as like below

API headers 

```
{
   "Authorization":"Bearer access_token",
   "Content-Type":"application/json"
}
```

**List S3 Buckets API Endpoint**

**GET** <https://cqube\\_domain/data/list\\_s3\\_buckets&#x20>;

Output Body

```
{
   "input":"cqube-input-bucket",
   "output":"cqube-output-bucket",
   "emission":"cqube-emission-bucket"
}
```

**POST** <https://cqube\\_domain/data/list\\_s3\\_files&#x20>;

Request Body:&#x20;

```
{
   "bucket":"cqube-output-bucket"
}
```

**POST** <https://cqube\\_domain/data/download\\_uri&#x20>;

Output Body:&#x20;

```
{
   "filename":"school_master/2020/2020-06/2020-06-04_school_master/04-06-2020_13:12:59.574_5e1 60862-c5b3-4121-9a96-ecefa34fc264_school_mst.zip",
   "bucket":"cqube-gj-input"
}
```