[2024-08-12 20:29:25] dev.INFO: API Response:  {"context":"<s:Envelope xmlns:s=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><s:Header><ActivityId CorrelationId=\"6764be1a-7375-46d2-9aae-6c186bf585e2\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><SessionTimeout xmlns=\"http://www.tylertech.com/\">20</SessionTimeout><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.3.1.13</Version></EFMConfigurationHeader><o:Security s:mustUnderstand=\"1\" xmlns:o=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\"><u:Timestamp u:Id=\"_0\"><u:Created>2024-08-12T20:29:25.438Z</u:Created><u:Expires>2024-08-12T20:34:25.438Z</u:Expires></u:Timestamp></o:Security></s:Header><s:Body xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><AuthenticateUserResponse xmlns=\"urn:tyler:efm:services\"><AuthenticateUserResponse><Error xmlns=\"urn:tyler:efm:services:schema:BaseResponse\"><ErrorCode xmlns=\"urn:tyler:efm:services:schema:Common\">0</ErrorCode><ErrorText xmlns=\"urn:tyler:efm:services:schema:Common\">No Error</ErrorText></Error><UserID xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">8d721b93-6de5-4c9f-bc40-b7c44c260e61</UserID><Email xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">mariano.rossin@gmail.com</Email><FirstName xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">Mariano</FirstName><LastName xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">Rossin</LastName><PasswordHash xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">3c934aae-25b0-4905-9a93-d2626cde96e1</PasswordHash><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">6106-08-07T07:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2024-08-12 20:29:26] dev.INFO: API Request Auth:  {"context":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:ns1=\"urn:tyler:efm:services\"><SOAP-ENV:Header><ns1:UserNameHeader><UserName>mariano.rossin@gmail.com</UserName><Password>3c934aae-25b0-4905-9a93-d2626cde96e1</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetFirm/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2024-08-12 20:29:28] dev.INFO: API Response:  {"context":"<s:Envelope xmlns:s=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><s:Header><ActivityId CorrelationId=\"11c0e5d3-6aeb-4977-a1f1-1353e6fb85e6\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.3.1.13</Version></EFMConfigurationHeader><o:Security s:mustUnderstand=\"1\" xmlns:o=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\"><u:Timestamp u:Id=\"_0\"><u:Created>2024-08-12T20:29:28.666Z</u:Created><u:Expires>2024-08-12T20:34:28.666Z</u:Expires></u:Timestamp></o:Security></s:Header><s:Body xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><GetFirmResponse xmlns=\"urn:tyler:efm:services\"><GetFirmResponse><Error xmlns=\"urn:tyler:efm:services:schema:BaseResponse\"><ErrorCode xmlns=\"urn:tyler:efm:services:schema:Common\">0</ErrorCode><ErrorText xmlns=\"urn:tyler:efm:services:schema:Common\">No Error</ErrorText></Error><Firm FirmID=\"c42f3675-13f2-4a62-a578-9c3404fe8f7b\" IsIndividual=\"false\" IsAgency=\"false\" xmlns=\"urn:tyler:efm:services:schema:GetFirmResponse\"><FirmName xmlns=\"urn:tyler:efm:services:schema:Common\">Firm Prueba Mariano</FirmName><Address xmlns=\"urn:tyler:efm:services:schema:Common\"><AddressLine1>Los Ceibos 2731</AddressLine1><AddressLine2/><City>San Jose of The Corner</City><State>IL</State><ZipCode>23121</ZipCode><Country>US</Country></Address><PhoneNumber xmlns=\"urn:tyler:efm:services:schema:Common\">3425290600</PhoneNumber></Firm></GetFirmResponse></GetFirmResponse></s:Body></s:Envelope>"} []
[2024-08-12 20:29:29] dev.INFO: API Request Auth:  {"context":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:ns1=\"urn:tyler:efm:services:schema:GetUserRequest\" xmlns:ns2=\"urn:tyler:efm:services\"><SOAP-ENV:Header><ns2:UserNameHeader><UserName>mariano.rossin@gmail.com</UserName><Password>3c934aae-25b0-4905-9a93-d2626cde96e1</Password></ns2:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns2:GetUser><ns2:GetUserRequest><ns1:UserID>8d721b93-6de5-4c9f-bc40-b7c44c260e61</ns1:UserID></ns2:GetUserRequest></ns2:GetUser></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2024-08-12 20:29:30] dev.INFO: API Response:  {"context":"<s:Envelope xmlns:s=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><s:Header><ActivityId CorrelationId=\"1329e961-52f9-4172-87f2-01441fb0a148\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.3.1.13</Version></EFMConfigurationHeader><o:Security s:mustUnderstand=\"1\" xmlns:o=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd\"><u:Timestamp u:Id=\"_0\"><u:Created>2024-08-12T20:29:30.754Z</u:Created><u:Expires>2024-08-12T20:34:30.754Z</u:Expires></u:Timestamp></o:Security></s:Header><s:Body xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><GetUserResponse xmlns=\"urn:tyler:efm:services\"><GetUserResponse><Error xmlns=\"urn:tyler:efm:services:schema:BaseResponse\"><ErrorCode xmlns=\"urn:tyler:efm:services:schema:Common\">0</ErrorCode><ErrorText xmlns=\"urn:tyler:efm:services:schema:Common\">No Error</ErrorText></Error><User UserID=\"8d721b93-6de5-4c9f-bc40-b7c44c260e61\" FirmID=\"c42f3675-13f2-4a62-a578-9c3404fe8f7b\" IsApproved=\"true\" IsActive=\"true\" IsActivated=\"true\" IsLockedOut=\"false\" xmlns=\"urn:tyler:efm:services:schema:Common\"><Email>mariano.rossin@gmail.com</Email><FirstName>Mariano</FirstName><MiddleName>Jorge</MiddleName><LastName>Rossin</LastName><LastLoginDate>2024-08-12T20:29:25.14</LastLoginDate><Role><Location/><RoleName>Filer</RoleName></Role><Role><Location/><RoleName>FirmAdmin</RoleName></Role><RestrictFiling>false</RestrictFiling><RestrictFilingComment/><IsUndeliverable>false</IsUndeliverable><Status>Active</Status></User></GetUserResponse></GetUserResponse></s:Body></s:Envelope>"} []
[2024-08-12 20:31:24] 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, fem.envelope_id, fem.filing_id, fem.filing_status_code, cd.title as case_name, cd.docket_id as case_no, cd.filing_date as submission_date, fem.processed_date as clerk_process_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 cd.is_draft = 0 AND cd.filing_date >= "2024-07-13 00:00:00" AND cd.filing_date <= "2024-08-12 23:59:59"  GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] []
[2024-08-12 20:31:30] 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, fem.envelope_id, fem.filing_id, fem.filing_status_code, cd.title as case_name, cd.docket_id as case_no, cd.filing_date as submission_date, fem.processed_date as clerk_process_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 cd.is_draft = 0 AND cd.filing_date >= "2024-07-13 00:00:00" AND cd.filing_date <= "2024-08-12 23:59:59"  GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] []
[2024-08-12 20:31: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, fem.envelope_id, fem.filing_id, fem.filing_status_code, cd.title as case_name, cd.docket_id as case_no, cd.filing_date as submission_date, fem.processed_date as clerk_process_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 cd.is_draft = 0 AND cd.filing_date >= "2022-07-13 00:00:00" AND cd.filing_date <= "2024-08-12 23:59:59"  GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] []