JSON API - Basic Reporting

Record-Rows – filtered record data

This function is not strictly conformant with JSON API.

GET @apiroot/recordrows/{urlencoded eformtype}?filter={filter}&page%5Boffset%5D={start item offset}&page%5Blimit%5D={number of items}&columns={JSON Array of columns}

The following parameters are available. Note that square brackets must be URL-encoded (%5B, %5D).

• filter: A filter string
• page[offset]: Skip this number of records
• page[limit]: Return this number of records
• columns: A JSON array of column names to include. If not included, this will assume only RecordID. It is mandatory for meta-forms.

Request

EMPTY

Response

{
    "data": [
        {
            "RecordID": 1,
            "EFormType": "banana"
        },
        {
            "RecordID": 2,
            "EFormType": "banana"
        }
    ]
}