[2023-10-06 20:38:05] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.7.105192023-10-06T20:38:05.887Z2023-10-06T20:43:05.887Z0No Errorf4bada30-e0f6-498f-8817-cc83d7eaa93fmariano.rossin@gmail.comMarianoRossina41d5d54-be35-4645-8ce3-e0a145c923a66106-05-25T07:00:00"} [] [2023-10-06 20:38:07] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-10-06 20:38:08] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-06T20:38:08.842Z2023-10-06T20:43:08.842Z0No ErrorFirm Prueba Mariano
Los Ceibos 2731San Jose of The CornerTX23121US
3425290600"} [] [2023-10-06 20:38:09] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6f4bada30-e0f6-498f-8817-cc83d7eaa93f\n"} [] [2023-10-06 20:38:10] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-06T20:38:10.780Z2023-10-06T20:43:10.780Z0No Errormariano.rossin@gmail.comMarianoJorgeRossin2023-10-06T20:38:05.78falsefalse"} [] [2023-10-06 20:44:27] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-06T20:44:27.808Z2023-10-06T20:49:27.808Z-4Authentication failed, invalid/expired authentication token or email/password combination0001-01-01T00:00:00"} [] [2023-10-06 20:44:37] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-000000000000202022.1.7.105192023-10-06T20:44:37.674Z2023-10-06T20:49:37.674Z0No Errorf4bada30-e0f6-498f-8817-cc83d7eaa93fmariano.rossin@gmail.comMarianoRossina41d5d54-be35-4645-8ce3-e0a145c923a66106-05-25T07:00:00"} [] [2023-10-06 20:44:38] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6\n"} [] [2023-10-06 20:44:39] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-06T20:44:39.601Z2023-10-06T20:49:39.601Z0No ErrorFirm Prueba Mariano
Los Ceibos 2731San Jose of The CornerTX23121US
3425290600"} [] [2023-10-06 20:44:40] dev.INFO: API Request Auth: {"context":"\nmariano.rossin@gmail.coma41d5d54-be35-4645-8ce3-e0a145c923a6f4bada30-e0f6-498f-8817-cc83d7eaa93f\n"} [] [2023-10-06 20:44:41] dev.INFO: API Response: {"context":"00000000-0000-0000-0000-0000000000002022.1.7.105192023-10-06T20:44:41.758Z2023-10-06T20:49:41.758Z0No Errormariano.rossin@gmail.comMarianoJorgeRossin2023-10-06T20:44:37.58falsefalse"} [] [2023-10-06 20:44:51] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-09-06 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-06 20:44:58] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-07-01 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-06 20:46:10] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-07-01 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-06 20:46:21] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-04-01 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-06 20:46:26] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-09-06 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-06 20:46:48] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-09-06 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] [] [2023-10-06 20:46:51] 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, fem.envelope_id, fem.filing_status_code 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 cd.is_draft = 0 AND va.created_at >= "2023-09-06 00:00:00" AND va.created_at <= "2023-10-06 23:59:59" GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] []