API: Execute Report

executeReport

Execute specific report and get data

Required parameters

Parameter	Description
id	Report ID
export_columns	Columns to export in report

Optional parameters

Parameter	Description
params	Parameters to export in report
conditions	Conditions to export in report
conditions_connector	Condition connector to export in report. Possible values [AND,OR]

Request

GET /admin/api.php?api_id=API_ID&api_key=API_KEY&call=executeReport&id=ID&export_columns=EXPORT_COLUMNS

PHP Samples

PHP Samples: Generate a report for #1 for a one-month period where the order status is 'Active'

Response

{
    "success": true,
    "report_data": [
        {
            "Order ID": "62",
            "Current Status": "Active",
            "Order Number": "275109710"
        },
        {
            "Order ID": "68",
            "Current Status": "Active",
            "Order Number": "788492445"
        },
        {
            "Order ID": "69",
            "Current Status": "Active",
            "Order Number": "2117465167"
        }
    ],
    "call": "executeReport",
    "server_time": 1786450401
}