[2023-07-17 20:05:40] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T20:05:40.434Z2023-07-17T20:10:40.434Z175Please activate your account using the link in your registration email.0001-01-01T00:00:00"} [] [2023-07-17 20:06:28] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T20:06:28.193Z2023-07-17T20:11:28.193Z175Please activate your account using the link in your registration email.0001-01-01T00:00:00"} [] [2023-07-17 20:07:40] dev.INFO: API Request Auth: {"context":"\nFirmAdministratordariomartinelli02+mfrstageil@gmail.comDarioMartinelliStageIl2023holaholaEspaña 421AustinTX73301USDario Martinelli3446548351\n"} [] [2023-07-17 20:07:41] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T20:07:41.222Z2023-07-17T20:12:41.222Z0No Error7d1b4132-7672-494d-b9e8-edba2aa03a7e71025cc5-a391-43bd-8878-8f187c6fd03f13718b1a-1ca6-4a3a-b15a-6cff1992d4aatrue6106-08-10T07:00:00Z"} [] [2023-07-17 20:13:11] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.0.1.99312023-07-17T20:13:11.183Z2023-07-17T20:18:11.183Z0No Error7d1b4132-7672-494d-b9e8-edba2aa03a7edariomartinelli02+mfrstageil@gmail.comDarioMartinelli13718b1a-1ca6-4a3a-b15a-6cff1992d4aa6106-08-10T07:00:00"} [] [2023-07-17 20:13:13] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa\n"} [] [2023-07-17 20:13:14] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T20:13:13.751Z2023-07-17T20:18:13.751Z0No ErrorDario Martinelli
España 421AustinTX73301US
3446548351"} [] [2023-07-17 20:13:14] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa7d1b4132-7672-494d-b9e8-edba2aa03a7e\n"} [] [2023-07-17 20:13:15] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T20:13:15.333Z2023-07-17T20:18:15.333Z0No Errordariomartinelli02+mfrstageil@gmail.comDarioMartinelli2023-07-17T20:13:11.143FilerFirmAdminfalsefalse"} [] [2023-07-17 20:13:16] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa784513DarioMartinelli\n"} [] [2023-07-17 20:13:18] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T20:13:17.819Z2023-07-17T20:18:17.819Z82Invalid Bar Number."} [] [2023-07-17 20:14:19] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:15:20] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-07-10 00:00:00" ORDER BY va.created_at DESC [] [] [2023-07-17 20:15:33] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at <= "2023-07-09 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:15:39] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:15:46] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where (uva.firstname like '%joe%' OR uva.middlename like '%joe%' OR uva.lastname like '%joe%') ORDER BY va.created_at DESC [] [] [2023-07-17 20:15:50] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:15:59] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:19:52] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:22:34] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:22:50] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:23:15] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:23:29] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:23:41] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:24:32] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:24:46] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:25:45] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:25:59] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:26:25] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:26:34] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:29:03] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:29:41] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:30:20] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:30:46] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:31:21] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:31:36] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:31:44] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:34:57] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:35:07] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:35:37] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:36:16] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:36:37] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:37:06] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category ORDER BY va.created_at DESC [] [] [2023-07-17 20:37:48] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:37:59] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-01 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:38:07] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:38:23] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-01 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:38:28] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:38:35] dev.INFO: Select CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price, va.created_at as filing_date from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:42:17] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:42:25] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:44:59] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:45:02] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:46:44] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:47:42] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:48:46] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:49:25] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 20:49:56] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 22:28:52] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.3.104272023-07-17T22:28:51.915Z2023-07-17T22:33:51.915Z0No Error3c1214f4-9688-45b1-90c4-6f6ced36acf5dariomartinelli02+mfrstageca@gmail.comDarioMartinelli428b230e-9e9e-46be-be5d-48f51273cae76106-07-31T09:00:00"} [] [2023-07-17 22:28:53] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageca@gmail.com428b230e-9e9e-46be-be5d-48f51273cae7\n"} [] [2023-07-17 22:28:54] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.3.104272023-07-17T22:28:54.603Z2023-07-17T22:33:54.603Z0No ErrorDario Martinelli
España 421AustinTX73301US
3446548351"} [] [2023-07-17 22:28:55] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageca@gmail.com428b230e-9e9e-46be-be5d-48f51273cae73c1214f4-9688-45b1-90c4-6f6ced36acf5\n"} [] [2023-07-17 22:28:56] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.3.104272023-07-17T22:28:56.376Z2023-07-17T22:33:56.376Z0No Errordariomartinelli02+mfrstageca@gmail.comDarioMartinelli2023-07-17T22:28:53.477FilerFirmAdminfalsefalse"} [] [2023-07-17 22:38:34] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.0.1.99312023-07-17T22:38:34.258Z2023-07-17T22:43:34.258Z0No Error7d1b4132-7672-494d-b9e8-edba2aa03a7edariomartinelli02+mfrstageil@gmail.comDarioMartinelli13718b1a-1ca6-4a3a-b15a-6cff1992d4aa6106-08-10T07:00:00"} [] [2023-07-17 22:38:35] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa\n"} [] [2023-07-17 22:38:36] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T22:38:36.243Z2023-07-17T22:43:36.243Z0No ErrorDario Martinelli
España 421AustinTX73301US
3446548351"} [] [2023-07-17 22:38:36] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa7d1b4132-7672-494d-b9e8-edba2aa03a7e\n"} [] [2023-07-17 22:38:37] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T22:38:37.233Z2023-07-17T22:43:37.233Z0No Errordariomartinelli02+mfrstageil@gmail.comDarioMartinelli2023-07-17T22:38:34.223FilerFirmAdminfalsefalse"} [] [2023-07-17 22:38:38] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa784513DarioMartinelli\n"} [] [2023-07-17 22:38:39] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T22:38:39.430Z2023-07-17T22:43:39.430Z82Invalid Bar Number."} [] [2023-07-17 22:39:37] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 22:40:04] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 22:53:46] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 22:54:00] dev.INFO: Select va.created_at as filing_date, CONCAT_WS(" ", uva.firstname, uva.middlename, uva.lastname) as rep_name, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer_name, f.firmname as firm_name, l.name as jurisdiction, fc.name as filing_type, va.plan as va_type, va.price as va_price from virtual_assistance va join case_draft cd on cd.id = va.case_draft_id left join users uva on uva.id = va.virtual_assistant_id left join users uf on uf.id = cd.drafter_id left join locations l on l.code = cd.location_code left join file_envelope_map fem ON cd.id = fem.draft_id left join firm f ON uf.firmid = f.fid left join filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code and fc.case_category_id = cd.case_category where va.created_at >= "2023-06-17 00:00:00" AND va.created_at <= "2023-07-17 23:59:59" ORDER BY va.created_at DESC [] [] [2023-07-17 22:54:21] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa\n\t\n\t\thttp://localhost:13000/\n\t\n\turn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0\n\t\n \n \n\t\n\t\t\n\t\t\t\n\t\t\n\t\n\t\n\t\n\t\t\n\t\t\t\n \n\t\t\t\n\t\t\n\t\n \n \n 2023-06-17\n \n \n 2023-07-17\n \n \n\t\n"} [] [2023-07-17 22:54:22] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T22:54:22.245Z2023-07-17T22:59:22.245Zhttps://courts.wa.gov:8000urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.010No error"} [] [2023-07-17 22:54:36] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa\n\t\n\t\thttp://localhost:13000/\n\t\n\turn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0\n\t\n \n \n\t\n\t\t\n\t\t\t\n\t\t\n\t\n\t\n\t\n\t\t\n\t\t\t\n \n\t\t\t\n\t\t\n\t\n \n \n 2023-06-01\n \n \n 2023-07-17\n \n \n\t\n"} [] [2023-07-17 22:54:37] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T22:54:37.093Z2023-07-17T22:59:37.093Zhttps://courts.wa.gov:8000urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.010No error"} [] [2023-07-17 22:54:46] dev.INFO: API Request Auth: {"context":"\ndariomartinelli02+mfrstageil@gmail.com13718b1a-1ca6-4a3a-b15a-6cff1992d4aa\n\t\n\t\thttp://localhost:13000/\n\t\n\turn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0\n\t\n \n \n\t\n\t\t\n\t\t\t\n\t\t\n\t\n\t\n\t\n\t\t\n\t\t\t\n \n\t\t\t\n\t\t\n\t\n \n \n 2023-05-01\n \n \n 2023-07-17\n \n \n\t\n"} [] [2023-07-17 22:54:47] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.0.1.99312023-07-17T22:54:47.234Z2023-07-17T22:59:47.234Zhttps://courts.wa.gov:8000urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.010No error"} []