[2023-09-05 20:18:27] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.4.104712023-09-05T20:18:27.454Z2023-09-05T20:23:27.454Z0No Errord64a2c36-11c1-4ddd-b2fd-28ca79bf9774mariano.rossin@gmail.comMarianoRossin600d5d5f-9815-4f40-970b-afcab8fee2eb6106-08-07T07:00:00"} [] [2023-09-05 20:18:28] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.com600d5d5f-9815-4f40-970b-afcab8fee2eb\n"} [] [2023-09-05 20:18:30] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-09-05T20:18:30.130Z2023-09-05T20:23:30.130Z0No ErrorFirm Prueba Mariano
Los Ceibos 2731San Jose of The CornerIL23121US
3425290600"} [] [2023-09-05 20:18:30] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.com600d5d5f-9815-4f40-970b-afcab8fee2ebd64a2c36-11c1-4ddd-b2fd-28ca79bf9774\n"} [] [2023-09-05 20:18:31] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.4.104712023-09-05T20:18:31.654Z2023-09-05T20:23:31.654Z0No Errormariano.rossin@gmail.comMarianoJorgeRossin2023-09-05T20:18:27.317FilerFirmAdminfalsefalse"} [] [2023-09-05 21:16:22] 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-08-06 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] [] [2023-09-05 21:17:36] 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-08-06 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] [] [2023-09-05 21:17:45] 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 >= "2020-08-06 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] [] [2023-09-05 21:17:54] 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 >= "2020-08-06 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] [] [2023-09-05 21:19:11] 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 >= "2020-08-06 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] [] [2023-09-05 21:19:15] 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-08-06 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] [] [2023-09-05 21:19:23] 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-04-01 00:00:00" AND va.created_at <= "2023-09-05 23:59:59" ORDER BY va.created_at DESC [] []