[2026-05-11 22:56:40] Content-Type: application/json
[2026-05-11 22:56:40] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 22:56:40] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 22:56:40] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:56:40] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 22:56:40] Result: 1 patients found for practice_id=1
[2026-05-11 22:56:40] Content-Type: application/json
[2026-05-11 22:56:40] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 22:56:40] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 22:56:40] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:56:40] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 22:56:40] Result: 1 patients found for practice_id=1
[2026-05-11 22:56:40] Content-Type: application/json
[2026-05-11 22:56:40] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 22:56:40] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 22:56:40] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:56:51] Content-Type: application/json
[2026-05-11 22:56:51] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 22:56:51] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 22:56:51] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:56:51] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 22:56:51] Result: 393 patients found for practice_id=1
[2026-05-11 22:56:52] Content-Type: application/json
[2026-05-11 22:56:52] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 22:56:52] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 22:56:52] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:56:52] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 22:56:52] Result: 393 patients found for practice_id=9999
[2026-05-11 22:57:17] Content-Type: application/json
[2026-05-11 22:57:17] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 22:57:17] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 22:57:17] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:57:17] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 22:57:17] Result: 1 patients found for practice_id=1
[2026-05-11 22:57:17] Content-Type: application/json
[2026-05-11 22:57:17] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 22:57:17] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 22:57:17] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:57:17] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 22:57:17] Result: 1 patients found for practice_id=1
[2026-05-11 22:57:17] Content-Type: application/json
[2026-05-11 22:57:17] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 22:57:17] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 22:57:17] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:57:27] Content-Type: application/json
[2026-05-11 22:57:27] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 22:57:27] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 22:57:27] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:57:27] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 22:57:27] Result: 393 patients found for practice_id=1
[2026-05-11 22:57:27] Content-Type: application/json
[2026-05-11 22:57:27] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 22:57:27] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 22:57:27] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:57:27] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 22:57:27] Result: 393 patients found for practice_id=9999
[2026-05-11 22:59:05] Content-Type: application/json
[2026-05-11 22:59:05] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 22:59:05] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 22:59:05] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:59:05] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 22:59:05] Result: 1 patients found for practice_id=1
[2026-05-11 22:59:05] Content-Type: application/json
[2026-05-11 22:59:05] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 22:59:05] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 22:59:05] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:59:05] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 22:59:05] Result: 1 patients found for practice_id=1
[2026-05-11 22:59:06] Content-Type: application/json
[2026-05-11 22:59:06] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 22:59:06] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 22:59:06] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:59:15] Content-Type: application/json
[2026-05-11 22:59:15] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 22:59:15] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 22:59:15] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:59:15] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 22:59:15] Result: 393 patients found for practice_id=1
[2026-05-11 22:59:15] Content-Type: application/json
[2026-05-11 22:59:15] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 22:59:15] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 22:59:15] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 22:59:15] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 22:59:15] Result: 393 patients found for practice_id=9999
[2026-05-11 23:03:28] Content-Type: application/json
[2026-05-11 23:03:28] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:03:28] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:03:28] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:03:28] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 23:03:28] Result: 1 patients found for practice_id=1
[2026-05-11 23:03:28] Content-Type: application/json
[2026-05-11 23:03:28] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:03:28] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:03:28] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:03:28] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 23:03:28] Result: 1 patients found for practice_id=1
[2026-05-11 23:04:39] Content-Type: application/json
[2026-05-11 23:04:39] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:04:39] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:04:39] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:05:52] Content-Type: application/json
[2026-05-11 23:05:52] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:05:52] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:05:52] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:05:52] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 23:05:52] Result: 1 patients found for practice_id=1
[2026-05-11 23:05:52] Content-Type: application/json
[2026-05-11 23:05:52] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:05:52] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:05:52] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:05:52] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 23:05:52] Result: 1 patients found for practice_id=1
[2026-05-11 23:06:56] Content-Type: application/json
[2026-05-11 23:06:56] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:06:56] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:06:56] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:07:01] Content-Type: application/json
[2026-05-11 23:07:01] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:07:01] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:07:01] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:07:01] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 23:07:01] Result: 1 patients found for practice_id=1
[2026-05-11 23:07:01] Content-Type: application/json
[2026-05-11 23:07:01] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:07:01] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:07:01] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:07:01] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 23:07:01] Result: 1 patients found for practice_id=1
[2026-05-11 23:07:04] Content-Type: application/json
[2026-05-11 23:07:04] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:07:04] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:07:04] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:07:04] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:07:04] Result: 393 patients found for practice_id=1
[2026-05-11 23:07:04] Content-Type: application/json
[2026-05-11 23:07:04] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:07:04] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:07:04] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:07:04] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:07:04] Result: 393 patients found for practice_id=9999
[2026-05-11 23:08:09] Content-Type: application/json
[2026-05-11 23:08:09] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:08:09] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:08:09] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:09:20] Content-Type: application/json
[2026-05-11 23:09:20] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:09:20] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:09:20] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:09:20] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:09:20] Result: 393 patients found for practice_id=1
[2026-05-11 23:09:20] Content-Type: application/json
[2026-05-11 23:09:20] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:09:20] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:09:20] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:09:20] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:09:20] Result: 393 patients found for practice_id=9999
[2026-05-11 23:10:27] Content-Type: application/json
[2026-05-11 23:10:27] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:10:27] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:10:27] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:10:27] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:10:27] Result: 393 patients found for practice_id=1
[2026-05-11 23:10:28] Content-Type: application/json
[2026-05-11 23:10:28] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:10:28] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:10:28] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:10:28] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:10:28] Result: 393 patients found for practice_id=9999
[2026-05-11 23:10:49] Content-Type: application/json
[2026-05-11 23:10:49] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:10:49] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:10:49] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:10:49] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 23:10:49] Result: 1 patients found for practice_id=1
[2026-05-11 23:10:49] Content-Type: application/json
[2026-05-11 23:10:49] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:10:49] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:10:49] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:10:49] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 23:10:49] Result: 1 patients found for practice_id=1
[2026-05-11 23:11:51] Content-Type: application/json
[2026-05-11 23:11:51] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:11:51] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:11:51] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:14:06] Content-Type: application/json
[2026-05-11 23:14:06] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:14:06] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:14:06] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:14:06] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:14:06] Result: 393 patients found for practice_id=1
[2026-05-11 23:14:06] Content-Type: application/json
[2026-05-11 23:14:06] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:14:06] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:14:06] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:14:06] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:14:06] Result: 393 patients found for practice_id=9999
[2026-05-11 23:14:23] Content-Type: application/json
[2026-05-11 23:14:23] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:14:23] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"test"}
[2026-05-11 23:14:23] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:14:23] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%test%'
[2026-05-11 23:14:23] Result: 1 patients found for practice_id=1
[2026-05-11 23:14:23] Content-Type: application/json
[2026-05-11 23:14:23] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:14:23] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","last_name":"Spencer"}
[2026-05-11 23:14:23] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":null,"lastName":"Spencer","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:14:23] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(last_name) LIKE '%spencer%'
[2026-05-11 23:14:23] Result: 1 patients found for practice_id=1
[2026-05-11 23:15:29] Content-Type: application/json
[2026-05-11 23:15:29] Raw Payload: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:15:29] Parsed Data: {"user_id":999,"encryption_key":"totally_invalid_key","last_name":"test"}
[2026-05-11 23:15:29] Sanitized Data: {"userId":"999","encryptionKey":"totally_invalid_key","firstName":null,"lastName":"test","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:17:51] Content-Type: application/json
[2026-05-11 23:17:51] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:17:51] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":1,"first_name":"%","last_name":"%"}
[2026-05-11 23:17:51] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:17:51] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:17:51] Result: 393 patients found for practice_id=1
[2026-05-11 23:17:51] Content-Type: application/json
[2026-05-11 23:17:51] Raw Payload: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:17:51] Parsed Data: {"user_id":3,"encryption_key":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","active_practice_id":9999,"first_name":"%","last_name":"%"}
[2026-05-11 23:17:51] Sanitized Data: {"userId":"3","encryptionKey":"d3544020b68ff1b51251fc1b121a440f352c7288988063871400cf22398e0d44","firstName":"%","lastName":"%","dateOfBirth":null,"realPatientId":null}
[2026-05-11 23:17:51] Executing SQL: SELECT patient_id, first_name, last_name, date_of_birth, realpatientid, sex, is_sandbox FROM patients WHERE 1=1 AND LOWER(first_name) LIKE '%%%' AND LOWER(last_name) LIKE '%%%'
[2026-05-11 23:17:51] Result: 393 patients found for practice_id=9999
[2026-05-11 23:28:11] Content-Type: 
[2026-05-11 23:28:11] Raw Payload: 
[2026-05-11 23:28:11] Parsed Data: []
[2026-05-11 23:28:11] Sanitized Data: {"userId":null,"encryptionKey":null,"firstName":null,"lastName":null,"dateOfBirth":null,"realPatientId":null}
[2026-05-12 11:19:27] Content-Type: 
[2026-05-12 11:19:27] Raw Payload: 
[2026-05-12 11:19:27] Parsed Data: []
[2026-05-12 11:19:27] Sanitized Data: {"userId":null,"encryptionKey":null,"firstName":null,"lastName":null,"dateOfBirth":null,"realPatientId":null}
