Skip to content

Download FOCUS reports from Object Storage

Last updated on

STACKIT stores your FOCUS reports in the Object Storage bucket that you defined in your FOCUS export schedule. The Object Storage offering from STACKIT is S3-compatible, so there is a wide range of options to choose from to download the reports. In this guide we want to highlight some common ones.

Use Python to access reports programmatically.

Prerequisites

  • Python 3 installed.
  • Code editor (e.g., Visual Studio Code).
  1. Create a directory for your project and navigate into it.

    Terminal window
    mkdir -p "desired/project/folder"
    cd "desired/project/folder"
  2. Initialize a virtual environment and install boto3.

    Terminal window
    python3 -m venv .venv
    source .venv/bin/activate
    pip install boto3
  3. Set your credentials as environment variables. If you don’t have credentials, see Create and delete Object Storage credentials

    Terminal window
    export ACCESS_KEY_ID="<CHANGE ME>"
    export SECRET_ACCESS_KEY="<CHANGE ME>"
  4. Create a script file named focus-downloader.py. This script downloads the FOCUS report from your bucket (your-bucket) and saves it to a local path (local/path/to/downloaded-report.csv.gz).

    import boto3
    import os
    import sys
    access_key_id = os.getenv('ACCESS_KEY_ID')
    secret_access_key = os.getenv('SECRET_ACCESS_KEY')
    if not access_key_id:
    print('Environment variable ACCESS_KEY_ID empty!')
    sys.exit(1)
    if not secret_access_key:
    print('Environment variable SECRET_ACCESS_KEY empty!')
    sys.exit(1)
    s3 = boto3.client(
    's3',
    endpoint_url='https://object.storage.eu01.stackit.schwarz',
    aws_access_key_id=access_key_id,
    aws_secret_access_key=secret_access_key,
    )
    s3.download_file('your-bucket', 'path/to/report.csv.gz', 'local/path/to/downloaded-report.csv.gz')
  5. Run the script:

    Terminal window
    python3 focus-downloader.py
  6. Verify the download. The file appears in the specified local path (e.g., local/path/to/downloaded-report.csv.gz)