[2023-10-12 21:00:17] 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=\"4e0aa1da-6535-45ae-be2c-f4d458991065\" 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>2022.1.7.10519</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>2023-10-12T21:00:17.612Z</u:Created><u:Expires>2023-10-12T21:05:17.612Z</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\">f4bada30-e0f6-498f-8817-cc83d7eaa93f</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\">a41d5d54-be35-4645-8ce3-e0a145c923a6</PasswordHash><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">6106-05-25T07:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2023-10-12 21:00:27] 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=\"a124e963-5f92-482b-8c74-0903bf67e428\" 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>2022.1.7.10519</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>2023-10-12T21:00:27.070Z</u:Created><u:Expires>2023-10-12T21:05:27.070Z</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\">f4bada30-e0f6-498f-8817-cc83d7eaa93f</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\">a41d5d54-be35-4645-8ce3-e0a145c923a6</PasswordHash><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">6106-05-25T07:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2023-10-12 21:00: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\"><SOAP-ENV:Header><ns1:UserNameHeader><UserName>mariano.rossin@gmail.com</UserName><Password>a41d5d54-be35-4645-8ce3-e0a145c923a6</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetFirm/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-12 21:00: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=\"8e46b2b3-3112-42e8-9d47-6686ef19cbbd\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2022.1.7.10519</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>2023-10-12T21:00:30.885Z</u:Created><u:Expires>2023-10-12T21:05:30.885Z</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=\"8384e46c-71b6-42bd-ad01-125ecba387f3\" 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>TX</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>"} []
[2023-10-12 21:00:31] 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>a41d5d54-be35-4645-8ce3-e0a145c923a6</Password></ns2:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns2:GetUser><ns2:GetUserRequest><ns1:UserID>f4bada30-e0f6-498f-8817-cc83d7eaa93f</ns1:UserID></ns2:GetUserRequest></ns2:GetUser></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-12 21:00:32] 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=\"3c805599-5547-4914-9fd8-7d3a29b07961\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2022.1.7.10519</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>2023-10-12T21:00:32.731Z</u:Created><u:Expires>2023-10-12T21:05:32.731Z</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=\"f4bada30-e0f6-498f-8817-cc83d7eaa93f\" FirmID=\"8384e46c-71b6-42bd-ad01-125ecba387f3\" 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>2023-10-12T21:00:26.96</LastLoginDate><RestrictFiling>false</RestrictFiling><RestrictFilingComment/><IsUndeliverable>false</IsUndeliverable></User></GetUserResponse></GetUserResponse></s:Body></s:Envelope>"} []
[2023-10-12 21:01: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, 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-12 00:00:00" AND va.created_at <= "2023-10-12 23:59:59"  GROUP BY va.case_draft_id ORDER BY va.created_at DESC [] []
[2023-10-12 23: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=\"1541e1b4-5112-488b-8151-7b69244fc9b1\" 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>2022.1.7.10519</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>2023-10-12T23:29:28.251Z</u:Created><u:Expires>2023-10-12T23:34:28.251Z</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\">f4bada30-e0f6-498f-8817-cc83d7eaa93f</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\">a41d5d54-be35-4645-8ce3-e0a145c923a6</PasswordHash><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">6106-05-25T07:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2023-10-12 23: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\"><SOAP-ENV:Header><ns1:UserNameHeader><UserName>mariano.rossin@gmail.com</UserName><Password>a41d5d54-be35-4645-8ce3-e0a145c923a6</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetFirm/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-12 23:29:31] 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=\"32c112c4-479a-4ac9-965a-c70c9c9990e8\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2022.1.7.10519</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>2023-10-12T23:29:31.379Z</u:Created><u:Expires>2023-10-12T23:34:31.379Z</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=\"8384e46c-71b6-42bd-ad01-125ecba387f3\" 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>TX</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>"} []
[2023-10-12 23:29:31] 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>a41d5d54-be35-4645-8ce3-e0a145c923a6</Password></ns2:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns2:GetUser><ns2:GetUserRequest><ns1:UserID>f4bada30-e0f6-498f-8817-cc83d7eaa93f</ns1:UserID></ns2:GetUserRequest></ns2:GetUser></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-12 23:29:34] 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=\"39876e8e-8c0f-4602-893d-d2d60f97d91e\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2022.1.7.10519</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>2023-10-12T23:29:34.818Z</u:Created><u:Expires>2023-10-12T23:34:34.818Z</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=\"f4bada30-e0f6-498f-8817-cc83d7eaa93f\" FirmID=\"8384e46c-71b6-42bd-ad01-125ecba387f3\" 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>2023-10-12T23:29:28.11</LastLoginDate><RestrictFiling>false</RestrictFiling><RestrictFilingComment/><IsUndeliverable>false</IsUndeliverable></User></GetUserResponse></GetUserResponse></s:Body></s:Envelope>"} []