21.2.6 Inspecting the Report Query JSON

Inspect the generated Report Query JSON to see how data loop names and source rows are structured.

The (Download) button in the Report Query definition page lets you inspect the contents of the JSON file your report uses .It has the following format (edited slightly for brevity). Each Data Loop Name is a top-level JSON object property whose value is an array of JSON objects representing the source's rows. Lowercase JSON property names match the names of each report source column.

{
    "dep": [
        {
            "deptno": 20,
            "dname": "RESEARCH",
            "loc": "DALLAS"
        }
    ],
    "emp_t": [
        {
            "empno": 7566,
            "ename": "JONES",
            "job": "MANAGER",
            "tenure": "44 years, 6 months"
        },
        ⋮
        {
            "empno": 7788,
            "ename": "SCOTT",
            "job": "ANALYST",
            "tenure": "1 year, 2 months"
        }
    ],
    "emp_n": [
        {
            "empno": 7876,
            "ename": "ADAMS",
            "job": "CLERK",
            "hiredate": "12-JAN-1983"
        },
        ⋮
        {
            "empno": 7788,
            "ename": "SCOTT",
            "job": "ANALYST",
            "hiredate": "14-JUL-2024"
        }
    ]
}