ScheduleApp Reports

Scraping Process Reports

Review the runs saved in SCRAPING_REPORTS, including records found, inserted, existing, skipped, errors, and the duration of the process.

Clear filters
15
Executions
14
Success
0
Partial
0
Failed
45,383
Records Found
25,509
Inserted
3,762
Existing
0
Errors
Jan 01, 2025
Oldest Period Start
Mar 31, 2026
Newest Period End

Latest Scraping Executions

Showing the latest 200 reports according to the selected process, status, and scraping range filters.

Report Process Range Found Unique Requested Returned Inserted Existing Skipped Errors Status Timing Details
#15
Created: Oct 09, 2026 		CustomersScraping
CUSTOMERS / DaySmart
ScheduleApp_Plain.APPOINTMENTS + DaySmart.Customers 		Jan 01, 2025
to Jan 31, 2025 		1,864 1,788 1 0 0 1,787 0 0 SUCCESS 1.053s
Start: Oct 09, 2026 09:03 AM
End: Oct 09, 2026 09:03 AM
Customers scraping completed successfully.
Summary 
{
    "start_date": 20250101,
    "end_date": 20250131,
    "local_appointments": 1864,
    "unique_customer_ids": 1788,
    "requested_to_daysmart": 1,
    "returned_by_api": 0,
    "inserted": 0,
    "existing": 1787,
    "not_returned_by_api": 1,
    "skipped": 0
}
Errors 
[]
#14
Created: Oct 09, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Jan 01, 2025
to Jan 31, 2025 		1,864 1,864 0 1,864 0 1,864 0 0 SUCCESS 9.344s
Start: Oct 09, 2026 09:03 AM
End: Oct 09, 2026 09:03 AM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20250101,
    "end_date": 20250131,
    "appointments_found": 1864,
    "unique_appointment_ids": 1864,
    "inserted": 0,
    "existing": 1864,
    "skipped": 0
}
Errors 
[]
#13
Created: Sep 28, 2026 		HistoricalEventsScraping
EVENTS / ScheduleApp_Plain
ScheduleApp_Plain.APPOINTMENTS 		-
to - 		13,843 251 0 0 212 39 13,592 0 SUCCESS 0.073s
Start: Sep 28, 2026 12:31 PM
End: Sep 28, 2026 12:31 PM
Historical events recovery completed successfully.
Summary 
{
    "source": "ScheduleApp_Plain.APPOINTMENTS",
    "appointments_read": 13843,
    "unique_employee_ids": 251,
    "appointment_rows_collapsed": 13592,
    "inserted": 212,
    "existing": 39,
    "mapped_fields": {
        "employee_id": "employee_id",
        "staff_screen_name": "screen_name",
        "staff_type_id": "type_id",
        "location_id": "location_id"
    },
    "inferred_defaults": {
        "c_id": "888",
        "status": "Inactive",
        "user_group": "c",
        "sort_order": "0",
        "relay1_id": "0",
        "relay2_id": "0",
        "sales_person_id": "0",
        "carrier_id": "0",
        "timezone_id": "0",
        "entity_type_id": "0",
        "bill_rate": "0.00",
        "appt_advance": "0.00"
    }
}
Errors 
[]
#12
Created: Sep 28, 2026 		ActiveEventsScraping
EVENTS / DaySmart
DaySmart.Staff 		-
to - 		70 70 0 70 12 58 0 0 SUCCESS 0.556s
Start: Sep 28, 2026 12:31 PM
End: Sep 28, 2026 12:31 PM
Active events scraping completed successfully.
Summary 
{
    "module": "Staff",
    "endpoint": "GetStaff",
    "status": "Active",
    "events_found": 70,
    "unique_employee_ids": 70,
    "inserted": 12,
    "existing": 58,
    "skipped": 0
}
Errors 
[]
#11
Created: Sep 28, 2026 		CustomersScraping
CUSTOMERS / DaySmart
ScheduleApp_Plain.APPOINTMENTS + DaySmart.Customers 		Feb 01, 2025
to Jun 30, 2025 		10,106 9,566 9,552 9,551 9,551 14 0 0 SUCCESS 50.303s
Start: Sep 28, 2026 12:29 PM
End: Sep 28, 2026 12:30 PM
Customers scraping completed successfully.
Summary 
{
    "start_date": 20250201,
    "end_date": 20250630,
    "local_appointments": 10106,
    "unique_customer_ids": 9566,
    "requested_to_daysmart": 9552,
    "returned_by_api": 9551,
    "inserted": 9551,
    "existing": 14,
    "not_returned_by_api": 1,
    "skipped": 0
}
Errors 
[]
#10
Created: Sep 28, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Jun 01, 2025
to Jun 30, 2025 		3,102 3,102 0 3,102 3,102 0 0 0 SUCCESS 16.717s
Start: Sep 28, 2026 12:29 PM
End: Sep 28, 2026 12:29 PM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20250601,
    "end_date": 20250630,
    "appointments_found": 3102,
    "unique_appointment_ids": 3102,
    "inserted": 3102,
    "existing": 0,
    "skipped": 0
}
Errors 
[]
#9
Created: Sep 28, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		May 01, 2025
to May 31, 2025 		2,633 2,633 0 2,633 2,633 0 0 0 SUCCESS 16.087s
Start: Sep 28, 2026 12:28 PM
End: Sep 28, 2026 12:28 PM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20250501,
    "end_date": 20250531,
    "appointments_found": 2633,
    "unique_appointment_ids": 2633,
    "inserted": 2633,
    "existing": 0,
    "skipped": 0
}
Errors 
[]
#8
Created: Sep 28, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Apr 01, 2025
to Apr 30, 2025 		2,231 2,231 0 2,231 2,231 0 0 0 SUCCESS 10.262s
Start: Sep 28, 2026 12:27 PM
End: Sep 28, 2026 12:27 PM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20250401,
    "end_date": 20250430,
    "appointments_found": 2231,
    "unique_appointment_ids": 2231,
    "inserted": 2231,
    "existing": 0,
    "skipped": 0
}
Errors 
[]
#7
Created: Sep 28, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Mar 01, 2025
to Mar 31, 2025 		2,140 2,140 0 2,140 2,140 0 0 0 SUCCESS 10.309s
Start: Sep 28, 2026 12:26 PM
End: Sep 28, 2026 12:26 PM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20250301,
    "end_date": 20250331,
    "appointments_found": 2140,
    "unique_appointment_ids": 2140,
    "inserted": 2140,
    "existing": 0,
    "skipped": 0
}
Errors 
[]
#6
Created: Sep 28, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Mar 01, 2025
to Mar 31, 2026 		0 0 0 0 0 0 0 0 PENDING -s
Start: Sep 28, 2026 12:23 PM
End: -
#5
Created: Sep 28, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Feb 01, 2026
to Feb 28, 2026 		1,873 1,873 0 1,873 1,873 0 0 0 SUCCESS 9.298s
Start: Sep 28, 2026 12:22 PM
End: Sep 28, 2026 12:22 PM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20260201,
    "end_date": 20260228,
    "appointments_found": 1873,
    "unique_appointment_ids": 1873,
    "inserted": 1873,
    "existing": 0,
    "skipped": 0
}
Errors 
[]
#4
Created: Sep 23, 2026 		HistoricalEventsScraping
EVENTS / ScheduleApp_Plain
ScheduleApp_Plain.APPOINTMENTS 		-
to - 		1,864 39 0 0 39 0 1,825 0 SUCCESS 0.011s
Start: Sep 23, 2026 08:25 AM
End: Sep 23, 2026 08:25 AM
Historical events recovery completed successfully.
Summary 
{
    "source": "ScheduleApp_Plain.APPOINTMENTS",
    "appointments_read": 1864,
    "unique_employee_ids": 39,
    "appointment_rows_collapsed": 1825,
    "inserted": 39,
    "existing": 0,
    "mapped_fields": {
        "employee_id": "employee_id",
        "staff_screen_name": "screen_name",
        "staff_type_id": "type_id",
        "location_id": "location_id"
    },
    "inferred_defaults": {
        "c_id": "888",
        "status": "Inactive",
        "user_group": "c",
        "sort_order": "0",
        "relay1_id": "0",
        "relay2_id": "0",
        "sales_person_id": "0",
        "carrier_id": "0",
        "timezone_id": "0",
        "entity_type_id": "0",
        "bill_rate": "0.00",
        "appt_advance": "0.00"
    }
}
Errors 
[]
#3
Created: Sep 23, 2026 		ActiveEventsScraping
EVENTS / DaySmart
DaySmart.Staff 		-
to - 		65 65 0 65 65 0 0 0 SUCCESS 1.747s
Start: Sep 23, 2026 08:25 AM
End: Sep 23, 2026 08:25 AM
Active events scraping completed successfully.
Summary 
{
    "module": "Staff",
    "endpoint": "GetStaff",
    "status": "Active",
    "events_found": 65,
    "unique_employee_ids": 65,
    "inserted": 65,
    "existing": 0,
    "skipped": 0
}
Errors 
[]
#2
Created: Sep 23, 2026 		CustomersScraping
CUSTOMERS / DaySmart
ScheduleApp_Plain.APPOINTMENTS + DaySmart.Customers 		Jan 01, 2025
to Jan 31, 2025 		1,864 1,788 1,788 1,787 1,787 0 0 0 SUCCESS 9.766s
Start: Sep 23, 2026 08:23 AM
End: Sep 23, 2026 08:23 AM
Customers scraping completed successfully.
Summary 
{
    "start_date": 20250101,
    "end_date": 20250131,
    "local_appointments": 1864,
    "unique_customer_ids": 1788,
    "requested_to_daysmart": 1788,
    "returned_by_api": 1787,
    "inserted": 1787,
    "existing": 0,
    "not_returned_by_api": 1,
    "skipped": 0
}
Errors 
[]
#1
Created: Sep 23, 2026 		AppointmentsScraping
APPOINTMENTS / DaySmart
DaySmart.Appointments 		Jan 01, 2025
to Jan 31, 2025 		1,864 1,864 0 1,864 1,864 0 0 0 SUCCESS 8.887s
Start: Sep 23, 2026 08:23 AM
End: Sep 23, 2026 08:23 AM
Appointments scraping completed successfully.
Summary 
{
    "start_date": 20250101,
    "end_date": 20250131,
    "appointments_found": 1864,
    "unique_appointment_ids": 1864,
    "inserted": 1864,
    "existing": 0,
    "skipped": 0
}
Errors 
[]