"{\"Incoming_SMS_Message\":{\"custom8\":null, \"custom9\":null, \"email\":null, \"custom2\":null, \"custom3\":null, \"custom1\":\"61074\", \"short_code\":\"18667378487\", \"custom6\":null, \"custom7\":null, \"custom4\":null, \"custom5\":null, \"zip\":null, \"Message\":\"Refill\", \"date_in\":\"1\\\/11\\\/2024 12:55:16 PM\", \"contact_created\":\"10\\\/1\\\/2020 8:19:59 AM\", \"mobile\":\"6053214023\", \"user_guid\":\"A5F81D32-4FEB-47D9-8BF9-0FA5F9DA1FCA\", \"notes\":null, \"state\":null, \"custom10\":null, \"firstname\":\"Mickey\", \"city\":null, \"campaign_name\":\"QuitLine Application\", \"opt_out_flag\":false, \"gender\":null, \"carrier_name\":\"TMOBILEUS\", \"country_id\":null, \"guid\":\"2A1D90B6-C3B0-EE11-80E5-BC305BF816D7\", \"status\":null, \"birthdate\":null, \"campaign_keyword\":\"ql\", \"address2\":null, \"contacts_guid\":\"4323EF35-71DD-4931-8BF9-0FA5F9DA1FCA\", \"lastname\":\"Mouse\", \"address\":null, \"age_range\":null}}" "{\"Incoming_SMS_Message\":{\"custom8\":null, \"custom9\":null, \"email\":null, \"custom2\":null, \"custom3\":null, \"custom1\":\"61074\", \"short_code\":\"18667378487\", \"custom6\":null, \"custom7\":null, \"custom4\":null, \"custom5\":null, \"zip\":null, \"Message\":\"Refill\", \"date_in\":\"1\\\/11\\\/2024 12:56:43 PM\", \"contact_created\":\"10\\\/1\\\/2020 8:19:59 AM\", \"mobile\":\"6053214023\", \"user_guid\":\"A5F81D32-4FEB-47D9-8BF9-0FA5F9DA1FCA\", \"notes\":null, \"state\":null, \"custom10\":null, \"firstname\":\"Mickey\", \"city\":null, \"campaign_name\":\"QuitLine Application\", \"opt_out_flag\":false, \"gender\":null, \"carrier_name\":\"TMOBILEUS\", \"country_id\":null, \"guid\":\"B4EC6CE6-C3B0-EE11-80E5-BC305BF816D7\", \"status\":null, \"birthdate\":null, \"campaign_keyword\":\"ql\", \"address2\":null, \"contacts_guid\":\"4323EF35-71DD-4931-8BF9-0FA5F9DA1FCA\", \"lastname\":\"Mouse\", \"address\":null, \"age_range\":null}}" "{\"Incoming_SMS_Message\":{\"custom8\":null, \"custom9\":null, \"email\":null, \"custom2\":null, \"custom3\":null, \"custom1\":\"47513\", \"short_code\":\"18667378487\", \"custom6\":null, \"custom7\":null, \"custom4\":null, \"custom5\":null, \"zip\":null, \"Message\":\"Refill\", \"date_in\":\"1\\\/11\\\/2024 12:58:24 PM\", \"contact_created\":\"10\\\/1\\\/2020 8:19:59 AM\", \"mobile\":\"6053214023\", \"user_guid\":\"A5F81D32-4FEB-47D9-8BF9-0FA5F9DA1FCA\", \"notes\":null, \"state\":null, \"custom10\":null, \"firstname\":\"Polly\", \"city\":null, \"campaign_name\":\"QuitLine Application\", \"opt_out_flag\":false, \"gender\":null, \"carrier_name\":\"TMOBILEUS\", \"country_id\":null, \"guid\":\"0C034128-C4B0-EE11-80E5-BC305BF816D7\", \"status\":null, \"birthdate\":null, \"campaign_keyword\":\"ql\", \"address2\":null, \"contacts_guid\":\"4323EF35-71DD-4931-8BF9-0FA5F9DA1FCA\", \"lastname\":\"Benson\", \"address\":null, \"age_range\":null}}" {"status":"error","errors":["You have entered an improper value, 2023-12-30 00:00:00, for field EnrollmentDate, which is of type date. Proper Format: YYYY-MM-DD"]} "{\"Incoming_SMS_Message\":{\"custom8\":null, \"custom9\":null, \"email\":null, \"custom2\":null, \"custom3\":null, \"custom1\":\"47513\", \"short_code\":\"18667378487\", \"custom6\":null, \"custom7\":null, \"custom4\":null, \"custom5\":null, \"zip\":null, \"Message\":\"Refill\", \"date_in\":\"1\\\/11\\\/2024 12:59:28 PM\", \"contact_created\":\"10\\\/1\\\/2020 8:19:59 AM\", \"mobile\":\"6053214023\", \"user_guid\":\"A5F81D32-4FEB-47D9-8BF9-0FA5F9DA1FCA\", \"notes\":null, \"state\":null, \"custom10\":null, \"firstname\":\"Polly\", \"city\":null, \"campaign_name\":\"QuitLine Application\", \"opt_out_flag\":false, \"gender\":null, \"carrier_name\":\"TMOBILEUS\", \"country_id\":null, \"guid\":\"75CC2A4C-C4B0-EE11-80E5-BC305BF816D7\", \"status\":null, \"birthdate\":null, \"campaign_keyword\":\"ql\", \"address2\":null, \"contacts_guid\":\"4323EF35-71DD-4931-8BF9-0FA5F9DA1FCA\", \"lastname\":\"Benson\", \"address\":null, \"age_range\":null}}" {"query":"INSERT INTO `client_medication` (`client_medication`.`ClientID`, `client_medication`.`EnrollmentDate`, `client_medication`.`IsRefillByText`, `client_medication`.`IsPregnantOrNursing`, `client_medication`.`ClientMedicationSetupID`, `client_medication`.`MedicaidNumber`, `client_medication`.`Notes`, `client_medication`.`ExternalEnrollmentID`, `client_medication`.`PrescriptionReceived`, `client_medication`.`PrescriptionReceivedByUserID`, `client_medication`.`PrescriptionReceivedDate`, `client_medication`.`LabelCreated`, `client_medication`.`LabelCreatedByUserID`, `client_medication`.`LabelCreatedDate`, `client_medication`.`PrescriptionFulfilled`, `client_medication`.`PrescriptionFulfilledByUserID`, `client_medication`.`PrescriptionFulfilledDate`, `client_medication`.`DateAdded`) VALUES (47513, '2023-12-30', 1, 0, 6, NULL, 'Refill KSK Ordered', NULL, 0, NULL, NULL, b'0', NULL, NULL, 0, NULL, NULL, current_timestamp())","status":"success","result":42546}