Reports

The Reports API is used to access, create, and modify the different reports on your business' account. Since reports allow you to view critical information about your business in a clear way, it is crucial for you to familiarize yourself with how to get, create, and modify the different reports you have built.

On this page




Reports API Endpoints

These are the endpoints that are available under the /reports path, which lists all the different reports you have available on your business' reports page.

Endpoint

Description

GET /reports/categoryReturns an array of strings representing each report category code on an account.
GET /report/category/{categoryCode}Returns a list of report objects in the specified category.
POST /report/print/file/{reportFileName}Runs the specified report.




Reports API Parameters


Data points passed on in the request URL portion of the API call that are used to filter the data being requested. 

Parameter

TypeEndpoints to be used with

Description

attachbooleanPOST /report/print/fileIndicates whether the report should download (if set to 'true') or show on screen (if set to 'false').
endDatestringPOST /report/print/fileShould be set as the end date of the report to be returned following a GET report call, formatted as YYYY-MM-DD. 
formatstringPOST /report/print/fileShould be set as the format of the report to be returned. Accepts "print", "pdf", "xls" or "xlsx".
locationIdintegerPOST /report/print/fileShould be set as the ID of the location of the report to be returned. Only applicable for reports in the "locations" report category. 
startDatestringPOST /report/print/fileShould be set as the start date of the report to be returned following a GET report call, formatted as YYYY-MM-DD. 




Reports API Request Body/Headers

POST /report/print/file/{reportFileName}
    "startDate": 2023-06-02,
    "endDate": 2023-06-02,
    "format": pdf,
    "attach": 0,
    "locationId": undefined




Reports API Responses

GET /reports/category
{
    "0": "closed_appointments",
    "1": "open_appointments",
    "2": "coupon",
    "3": "client_service",
    "4": "cancelled_appointments",
    "5": "classes",
    "6": "by_location",
    "7": "staff",
    "8": "noshow_appointments",
    "9": "booking_site_reports",
    "10": "email_reports",
    "11": "repeating_appointments",
    "12": "working_hours",
    "13": "all_appts",
    "14": "waitlist",
    "15": "client",
    "16": "invoice"
}
GET /reports/category/{categoryCode}
[{
    "active": true,
    "businessId": null,
    "category": "closed_appointments",
    "createdDate": 1462475855691,
    "createdUser": null,
    "modifiedDate": null,
    "modifiedUser": null,
    "planIds": [1, 3, 5, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 30, 31, 32, 33,…],
    "reportFileName": "appt-closed-daily-staff",
    "reportId": 10,
    "reportName": "Completed Appointments by Staff",
    "reportType": null,
    "resellerIds": [1, 2, 3],
    "securityFunctions": ["dashboardReportView", "accessAllStaffAtLocations", "accessAllLocations"]
}]




Reports Object Values

Property nameTypeDescription
activebooleanIndicates whether or not the specified report is active.
businessIdintegerProvides the unique numeric ID for the business that the specified report belongs to.
categorystringDisplays as the category of the specified report.
createdDateintegerDisplays as the date the specified report was created, in milliseconds elapsed since January 1, 1970 00:00:00 UTC form.
createdUserstringDisplays the username of the user who created the specified report.
modifiedDateintegerDisplays as the date the specified report was last modified, in milliseconds elapsed since January 1, 1970 00:00:00 UTC form.
modifiedUserstringDisplays the username of the user who last modified the specified report.
planIdsintegerProvides a comma-separated list of the IDs of the plans that can run the specified report.
reportFileNamestringDisplays as the file name of the specified report.
reportIdintegerProvides the unique numeric ID for the specified report.
reportNamestringDisplays as the name of the specified report.
reportTypestringDisplays as the type of the specified report.
resellerIdsintegerProvides unique numeric IDs for the resellers of the specified report. 
securityFunctionsstringDisplays the names of the security role functions required for a staff to be able to access the specified report.