POST

AppointmentCustomerReport.List

Customer appointment report (Advance → Appointment Customer Report). Returns customers who have appointments with next_appointment_date, doctor_name, complete_appointment, and pending_appointment. Core columns only (not the dashboard HTML column customizer). Page size capped at 25.

Permissions

User must be logged in with a valid bearer token.
Returned or changed records are limited by the user permissions, team access, folder access, and account settings.

Action

Returns AppointmentCustomerReport rows as JSON.
Supports the documented filters and paging fields.
List responses are capped at 25 rows per call.

Push Service

No push is sent because this function only reads data or returns helper information.

Automation

No automation is run for this function.

Special Instructions

Send the bearer token on protected calls with Authorization: Bearer YOUR TOKEN.
Send parameters as POST body fields exactly as documented.
For paging, do not request more than 25 rows.
For total rows, call the matching Count function with the same filters.

Required Parameters

No body parameters are required for this function.

Optional Parameters

Name	Type	Sample	What it gives
`name` post	string	`nidhi`	Customer name filter. Aliases: cust_name, search.
`mobile` post	string	`9199`	Mobile filter.
`email` post	string	`[email protected]`	Email filter.
`phone` post	string	`05`	Phone filter.
`date_created_from` post	date	`2026-01-01`	Customer date_created from. Send date filters and date values as UTC Y-m-d H:i:s when the route accepts date/time; date-only table columns store the Y-m-d date part.
`date_created_to` post	date	`2026-08-31`	Customer date_created to. Send date filters and date values as UTC Y-m-d H:i:s when the route accepts date/time; date-only table columns store the Y-m-d date part.
`page_id` post	int	`1`	1-based page.
`limit` post	int	`25`	Page size, capped at 25.
`start` post	int	`0`	Row offset.

Authentication

Send the bearer token returned by Login in the request header.

Authorization: Bearer YOUR TOKEN

Sample Request

{
    "url": "\/app\/AppointmentCustomerReport.List",
    "method": "POST",
    "headers": {
        "Authorization": "Bearer YOUR TOKEN"
    },
    "body": {
        "limit": "25",
        "page_id": "1"
    },
    "url_user": "https:\/\/{user}.bull36.com\/app\/AppointmentCustomerReport.List",
    "url_domain": "https:\/\/{domain}\/app\/AppointmentCustomerReport.List"
}

Endpoint

POST /app/AppointmentCustomerReport.List
POST https://{user}.bull36.com/app/AppointmentCustomerReport.List
POST https://{domain}/app/AppointmentCustomerReport.List

Sample Output

{
    "success": 1,
    "count": 1,
    "recordsTotal": 40,
    "data": [
        {
            "customer_id": 13455191,
            "name": "nidhi",
            "mobile": "919909279618",
            "email": "[email protected]",
            "next_appointment_date": "2026-09-01",
            "doctor_name": "Dr. A",
            "complete_appointment": 2,
            "pending_appointment": 1
        }
    ]
}

Count Only

Use the matching count route with the same filters when the UI only needs total rows for paging.

{
    "url": "\/app\/AppointmentCustomerReport.Count",
    "url_user": "https:\/\/{user}.bull36.com\/app\/AppointmentCustomerReport.Count",
    "url_domain": "https:\/\/{domain}\/app\/AppointmentCustomerReport.Count",
    "method": "POST",
    "headers": {
        "Authorization": "Bearer YOUR TOKEN"
    },
    "body": [],
    "sample_output": {
        "success": 1,
        "count": 123
    },
    "notes": {
        "count": "Use the matching count route when available, or count returned rows.",
        "max_limit": 25
    }
}

Count JavaScript

const token = 'YOUR TOKEN';
const body = new URLSearchParams();

const res = await fetch('https://{domain}/app/AppointmentCustomerReport.Count', {
  method: 'POST',
  headers: { Authorization: `Bearer ${token}` },
  body
});
const data = await res.json();
console.log(data.count);

JavaScript Example

const token = 'YOUR TOKEN';
const body = new URLSearchParams({ limit: '25' });
const res = await fetch('/app/AppointmentCustomerReport.List', { method: 'POST', headers: { Authorization: 'Bearer ' + token }, body });
console.log(await res.json());

Error Example

{
    "success": "0",
    "error": "bearer_token_required",
    "message": "Authorization bearer token is required. Send header: Authorization: Bearer YOUR TOKEN"
}