Overview

Report data is provided as a JSON formatted file. The reporting engine can work with any data as long as it is valid JSON. Parsing of data by the reporting engine is done using the JSONata Query Language.

Report Template Example

The following report template and subsequent report data illustrate how data substitution works.

{
    "id": "JHA-EA-RPT-BASIC",
    "name": "Basic Report",
    "description": "Basic data substitution report",
    "creator": "Aaron Watson",
    "version": "1.0",
    "components": [
        {
            "type": "Table",
            "headerRows": {
                "data": [ [ "Date", "Merchant", "Amount" ] ],
                "style": {
                    "textOptions": {
                        "weight": "bold"
                    }
                }
            },
            "rows": {
                "dataQuery": "transactions"
            },
            "columns": [
                {
                    "rowDataQuery": "date"
                },
                {
                    "rowDataQuery": "merchant"
                },
                {
                    "rowDataQuery": "amount"
                }
            ]
        }
    ]
}

Report Data Example

{
    "transactions": [
        {
            "date": "01/02/2022", 
            "merchant": "walmart", 
            "amount": 20.12
        },
        {
            "date": "01/06/2022", 
            "merchant": "amazon", 
            "amount": 47.20
        },
        {
            "date": "01/12/2022", 
            "merchant": "kroger", 
            "amount": 10.10
        },
        {
            "date": "01/25/2022", 
            "merchant": "autozone", 
            "amount": 210.89
        }
    ]
}

The sample template and data above would create a report as shown below: