[2023-10-11 19:14:11] 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=\"9b63ac02-54c2-4c21-a2d9-0597b719cdcc\" 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-11T19:14:11.064Z</u:Created><u:Expires>2023-10-11T19:19:11.064Z</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-11 19:14:12] 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-11 19:14:14] 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=\"bcb4e464-8979-426d-adb9-ff1ece976d78\" 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-11T19:14:14.065Z</u:Created><u:Expires>2023-10-11T19:19:14.065Z</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-11 19:14:14] 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-11 19:14:15] 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=\"98cad25b-47ba-40e7-9253-53bca3f1d120\" 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-11T19:14:15.864Z</u:Created><u:Expires>2023-10-11T19:19:15.864Z</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-11T19:14:10.97</LastLoginDate><RestrictFiling>false</RestrictFiling><RestrictFilingComment/><IsUndeliverable>false</IsUndeliverable></User></GetUserResponse></GetUserResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:17:23] 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=\"5a81ec55-55f9-43b9-9a10-60ecd79e16b2\" 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-11T19:17:23.508Z</u:Created><u:Expires>2023-10-11T19:22:23.508Z</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\">c626fc3c-039b-457b-a15e-b6e754930895</UserID><Email xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">morettilucas+proof@hotmail.com</Email><FirstName xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">proof</FirstName><LastName xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">proof</LastName><PasswordHash xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">f9dd2e0c-7970-4d8b-8692-3499d81e30aa</PasswordHash><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">6106-10-12T07:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:17:23] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetFirm/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:17: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=\"ac5afd10-476d-439b-9386-a3fad80aa9eb\" 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-11T19:17:25.693Z</u:Created><u:Expires>2023-10-11T19:22:25.693Z</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=\"d8be3872-cdde-4171-851f-9640f83a10ea\" IsIndividual=\"false\" IsAgency=\"false\" xmlns=\"urn:tyler:efm:services:schema:GetFirmResponse\"><FirmName xmlns=\"urn:tyler:efm:services:schema:Common\">proof</FirmName><Address xmlns=\"urn:tyler:efm:services:schema:Common\"><AddressLine1>proof</AddressLine1><AddressLine2>proof</AddressLine2><City>proof</City><State>TX</State><ZipCode>90210</ZipCode><Country>US</Country></Address><PhoneNumber xmlns=\"urn:tyler:efm:services:schema:Common\">12312312332</PhoneNumber></Firm></GetFirmResponse></GetFirmResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:17: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:schema:GetUserRequest\" xmlns:ns2=\"urn:tyler:efm:services\"><SOAP-ENV:Header><ns2:UserNameHeader><UserName>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns2:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns2:GetUser><ns2:GetUserRequest><ns1:UserID>c626fc3c-039b-457b-a15e-b6e754930895</ns1:UserID></ns2:GetUserRequest></ns2:GetUser></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:17: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=\"1474f452-5a75-4f5f-a950-1b58f6432675\" 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-11T19:17:27.615Z</u:Created><u:Expires>2023-10-11T19:22:27.615Z</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=\"c626fc3c-039b-457b-a15e-b6e754930895\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" IsApproved=\"true\" IsActive=\"true\" IsActivated=\"true\" IsLockedOut=\"false\" xmlns=\"urn:tyler:efm:services:schema:Common\"><Email>morettilucas+proof@hotmail.com</Email><FirstName>proof</FirstName><MiddleName>proof</MiddleName><LastName>proof</LastName><LastLoginDate>2023-10-11T19:17:23.37</LastLoginDate><RestrictFiling>false</RestrictFiling><RestrictFilingComment/><IsUndeliverable>false</IsUndeliverable></User></GetUserResponse></GetUserResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:21:28] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetAttorneyList/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:21: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=\"9c952bef-4d28-45e3-a0a1-43dbec144ffe\" 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-11T19:21:30.240Z</u:Created><u:Expires>2023-10-11T19:26:30.240Z</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\"><GetAttorneyListResponse xmlns=\"urn:tyler:efm:services\"><AttorneyListResponse><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><Attorney AttorneyID=\"1503192b-5e66-417e-9d07-01ba7893829a\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" xmlns=\"urn:tyler:efm:services:schema:AttorneyListResponse\"><BarNumber xmlns=\"urn:tyler:efm:services:schema:Common\">18234000</BarNumber><FirstName xmlns=\"urn:tyler:efm:services:schema:Common\">Mister</FirstName><MiddleName xmlns=\"urn:tyler:efm:services:schema:Common\"/><LastName xmlns=\"urn:tyler:efm:services:schema:Common\">Abogado</LastName><Email xmlns=\"urn:tyler:efm:services:schema:Common\">alfredshepperd@hotmail.com</Email></Attorney></AttorneyListResponse></GetAttorneyListResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:21:30] dev.INFO: attorney list: stdClass Object
(
    [AttorneyListResponse] => stdClass Object
        (
            [Error] => stdClass Object
                (
                    [ErrorCode] => 0
                    [ErrorText] => No Error
                )

            [Attorney] => stdClass Object
                (
                    [BarNumber] => 18234000
                    [FirstName] => Mister
                    [MiddleName] => 
                    [LastName] => Abogado
                    [AttorneyID] => 1503192b-5e66-417e-9d07-01ba7893829a
                    [FirmID] => d8be3872-cdde-4171-851f-9640f83a10ea
                )

        )

)
 [] []
[2023-10-11 19:21:36] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetServiceContactList/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:21:38] 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=\"5ec1dbdb-1be2-4310-bfe7-3af37000b3b5\" 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-11T19:21:38.121Z</u:Created><u:Expires>2023-10-11T19:26:38.121Z</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\"><GetServiceContactListResponse xmlns=\"urn:tyler:efm:services\"><ServiceContactListResponse><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><ServiceContact ServiceContactID=\"b359ce37-4e70-4734-a300-764a5f43d687\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" AddByFirmName=\"proof\" xmlns=\"urn:tyler:efm:services:schema:ServiceContactListResponse\"><FirstName xmlns=\"urn:tyler:efm:services:schema:Common\">Mister</FirstName><MiddleName xmlns=\"urn:tyler:efm:services:schema:Common\"/><LastName xmlns=\"urn:tyler:efm:services:schema:Common\">Abogado</LastName><Email xmlns=\"urn:tyler:efm:services:schema:Common\">mariano.rossin+attorney1@gmail.com</Email><IsPublic xmlns=\"urn:tyler:efm:services:schema:Common\">false</IsPublic><IsInFirmMasterList xmlns=\"urn:tyler:efm:services:schema:Common\">true</IsInFirmMasterList><IsUndeliverable xmlns=\"urn:tyler:efm:services:schema:Common\">false</IsUndeliverable></ServiceContact></ServiceContactListResponse></GetServiceContactListResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:21:42] dev.INFO: servicecontroller error id 7287 [] []
[2023-10-11 19:21:42] dev.INFO: servicecontroller error firm d8be3872-cdde-4171-851f-9640f83a10ea [] []
[2023-10-11 19:21:43] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetPaymentAccountList/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:21:44] 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=\"27b83d27-c955-48f1-96d8-ac962b886a36\" 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-11T19:21:44.528Z</u:Created><u:Expires>2023-10-11T19:26:44.528Z</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\"><GetPaymentAccountListResponse xmlns=\"urn:tyler:efm:services\"><PaymentAccountListResponse><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><PaymentAccount PaymentAccountID=\"dc52e883-9d2a-455a-be64-83f824192e7b\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" PaymentAccountTypeCode=\"CC\" xmlns=\"urn:tyler:efm:services:schema:PaymentAccountListResponse\"><AccountName xmlns=\"urn:tyler:efm:services:schema:Common\">training</AccountName><PaymentAccountTypeCodeId xmlns=\"urn:tyler:efm:services:schema:Common\">-135</PaymentAccountTypeCodeId><AccountToken xmlns=\"urn:tyler:efm:services:schema:Common\">248923395</AccountToken><CardType xmlns=\"urn:tyler:efm:services:schema:Common\">VISA</CardType><CardLast4 xmlns=\"urn:tyler:efm:services:schema:Common\">4448</CardLast4><CardMonth xmlns=\"urn:tyler:efm:services:schema:Common\">12</CardMonth><CardYear xmlns=\"urn:tyler:efm:services:schema:Common\">2027</CardYear><CardHolderName xmlns=\"urn:tyler:efm:services:schema:Common\">Mister Tedex</CardHolderName><Active xmlns=\"urn:tyler:efm:services:schema:Common\">true</Active><IsAvailableAtAllLocations xmlns=\"urn:tyler:efm:services:schema:Common\">true</IsAvailableAtAllLocations></PaymentAccount></PaymentAccountListResponse></GetPaymentAccountListResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:21:46] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetAttorneyList/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:21:47] 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=\"081834ea-9473-496d-8b47-739879563bf2\" 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-11T19:21:47.677Z</u:Created><u:Expires>2023-10-11T19:26:47.677Z</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\"><GetAttorneyListResponse xmlns=\"urn:tyler:efm:services\"><AttorneyListResponse><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><Attorney AttorneyID=\"1503192b-5e66-417e-9d07-01ba7893829a\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" xmlns=\"urn:tyler:efm:services:schema:AttorneyListResponse\"><BarNumber xmlns=\"urn:tyler:efm:services:schema:Common\">18234000</BarNumber><FirstName xmlns=\"urn:tyler:efm:services:schema:Common\">Mister</FirstName><MiddleName xmlns=\"urn:tyler:efm:services:schema:Common\"/><LastName xmlns=\"urn:tyler:efm:services:schema:Common\">Abogado</LastName><Email xmlns=\"urn:tyler:efm:services:schema:Common\">alfredshepperd@hotmail.com</Email></Attorney></AttorneyListResponse></GetAttorneyListResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:21:47] dev.INFO: attorney list: stdClass Object
(
    [AttorneyListResponse] => stdClass Object
        (
            [Error] => stdClass Object
                (
                    [ErrorCode] => 0
                    [ErrorText] => No Error
                )

            [Attorney] => stdClass Object
                (
                    [BarNumber] => 18234000
                    [FirstName] => Mister
                    [MiddleName] => 
                    [LastName] => Abogado
                    [AttorneyID] => 1503192b-5e66-417e-9d07-01ba7893829a
                    [FirmID] => d8be3872-cdde-4171-851f-9640f83a10ea
                )

        )

)
 [] []
[2023-10-11 19:21:49] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetServiceContactList/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:21:50] 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=\"a1ca9c89-ec53-4827-9183-cedc001c7113\" 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-11T19:21:50.429Z</u:Created><u:Expires>2023-10-11T19:26:50.429Z</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\"><GetServiceContactListResponse xmlns=\"urn:tyler:efm:services\"><ServiceContactListResponse><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><ServiceContact ServiceContactID=\"b359ce37-4e70-4734-a300-764a5f43d687\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" AddByFirmName=\"proof\" xmlns=\"urn:tyler:efm:services:schema:ServiceContactListResponse\"><FirstName xmlns=\"urn:tyler:efm:services:schema:Common\">Mister</FirstName><MiddleName xmlns=\"urn:tyler:efm:services:schema:Common\"/><LastName xmlns=\"urn:tyler:efm:services:schema:Common\">Abogado</LastName><Email xmlns=\"urn:tyler:efm:services:schema:Common\">mariano.rossin+attorney1@gmail.com</Email><IsPublic xmlns=\"urn:tyler:efm:services:schema:Common\">false</IsPublic><IsInFirmMasterList xmlns=\"urn:tyler:efm:services:schema:Common\">true</IsInFirmMasterList><IsUndeliverable xmlns=\"urn:tyler:efm:services:schema:Common\">false</IsUndeliverable></ServiceContact></ServiceContactListResponse></GetServiceContactListResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:21:55] 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>morettilucas+proof@hotmail.com</UserName><Password>f9dd2e0c-7970-4d8b-8692-3499d81e30aa</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetServiceContactList/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:21:56] 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=\"5ac0aaae-8317-4e79-9363-8c3db92b9c31\" 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-11T19:21:56.585Z</u:Created><u:Expires>2023-10-11T19:26:56.585Z</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\"><GetServiceContactListResponse xmlns=\"urn:tyler:efm:services\"><ServiceContactListResponse><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><ServiceContact ServiceContactID=\"b359ce37-4e70-4734-a300-764a5f43d687\" FirmID=\"d8be3872-cdde-4171-851f-9640f83a10ea\" AddByFirmName=\"proof\" xmlns=\"urn:tyler:efm:services:schema:ServiceContactListResponse\"><FirstName xmlns=\"urn:tyler:efm:services:schema:Common\">Mister</FirstName><MiddleName xmlns=\"urn:tyler:efm:services:schema:Common\"/><LastName xmlns=\"urn:tyler:efm:services:schema:Common\">Abogado</LastName><Email xmlns=\"urn:tyler:efm:services:schema:Common\">mariano.rossin+attorney1@gmail.com</Email><IsPublic xmlns=\"urn:tyler:efm:services:schema:Common\">false</IsPublic><IsInFirmMasterList xmlns=\"urn:tyler:efm:services:schema:Common\">true</IsInFirmMasterList><IsUndeliverable xmlns=\"urn:tyler:efm:services:schema:Common\">false</IsUndeliverable></ServiceContact></ServiceContactListResponse></GetServiceContactListResponse></s:Body></s:Envelope>"} []
[2023-10-11 19:26:55] dev.INFO: sending xml: <FilingListQueryMessage xmlns="urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:FilingListQueryMessage-4.0" xmlns:j="http://niem.gov/niem/domains/jxdm/4.0" xmlns:nc="http://niem.gov/niem/niem-core/2.0" xmlns:ecf="urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CommonTypes-4.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<ecf:SendingMDELocationID>
		<nc:IdentificationID>http://localhost:13000/</nc:IdentificationID>
	</ecf:SendingMDELocationID>
	<ecf:SendingMDEProfileCode>urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0</ecf:SendingMDEProfileCode>
	<ecf:QuerySubmitter>
            <ecf:EntityPerson/>
            </ecf:QuerySubmitter>
	<j:CaseCourt>
		<nc:OrganizationIdentification>
			<nc:IdentificationID></nc:IdentificationID>
		</nc:OrganizationIdentification>
	</j:CaseCourt>
	<nc:CaseTrackingID></nc:CaseTrackingID>
	<nc:DocumentSubmitter>
		<ecf:EntityPerson>
			<nc:PersonOtherIdentification>
                                    <nc:IdentificationID></nc:IdentificationID>
			</nc:PersonOtherIdentification>
		</ecf:EntityPerson>
	</nc:DocumentSubmitter>
        <nc:DateRange>
        <nc:StartDate>
            <nc:Date>2023-09-11</nc:Date>
        </nc:StartDate>
        <nc:EndDate>
            <nc:Date>2023-10-11</nc:Date>
        </nc:EndDate>
    </nc:DateRange>
	</FilingListQueryMessage> [] []
[2023-10-11 19:26:55] 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:oasis:names:tc:legalxml-courtfiling:schema:xsd:FilingListQueryMessage-4.0\" 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><FilingListQueryMessage xmlns=\"urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:FilingListQueryMessage-4.0\" xmlns:j=\"http://niem.gov/niem/domains/jxdm/4.0\" xmlns:nc=\"http://niem.gov/niem/niem-core/2.0\" xmlns:ecf=\"urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CommonTypes-4.0\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\n\t<ecf:SendingMDELocationID>\n\t\t<nc:IdentificationID>http://localhost:13000/</nc:IdentificationID>\n\t</ecf:SendingMDELocationID>\n\t<ecf:SendingMDEProfileCode>urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0</ecf:SendingMDEProfileCode>\n\t<ecf:QuerySubmitter>\n            <ecf:EntityPerson/>\n            </ecf:QuerySubmitter>\n\t<j:CaseCourt>\n\t\t<nc:OrganizationIdentification>\n\t\t\t<nc:IdentificationID></nc:IdentificationID>\n\t\t</nc:OrganizationIdentification>\n\t</j:CaseCourt>\n\t<nc:CaseTrackingID></nc:CaseTrackingID>\n\t<nc:DocumentSubmitter>\n\t\t<ecf:EntityPerson>\n\t\t\t<nc:PersonOtherIdentification>\n                                    <nc:IdentificationID></nc:IdentificationID>\n\t\t\t</nc:PersonOtherIdentification>\n\t\t</ecf:EntityPerson>\n\t</nc:DocumentSubmitter>\n        <nc:DateRange>\n        <nc:StartDate>\n            <nc:Date>2023-09-11</nc:Date>\n        </nc:StartDate>\n        <nc:EndDate>\n            <nc:Date>2023-10-11</nc:Date>\n        </nc:EndDate>\n    </nc:DateRange>\n\t</FilingListQueryMessage></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2023-10-11 19:26:58] dev.INFO: API Response:  {"context":"<s:Envelope xmlns:s=\"http://schemas.xmlsoap.org/soap/envelope/\"><s:Header><ActivityId CorrelationId=\"0f8a3807-6b3d-4899-add3-9f1dd3a59fbd\" 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\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><u:Created>2023-10-11T19:26:57.927Z</u:Created><u:Expires>2023-10-11T19:31:57.927Z</u:Expires></u:Timestamp></o:Security></s:Header><s:Body><FilingListResponseMessage xmlns=\"urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:FilingListResponseMessage-4.0\" xmlns:j=\"http://niem.gov/niem/domains/jxdm/4.0\" xmlns:nc=\"http://niem.gov/niem/niem-core/2.0\" xmlns:ecf=\"urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CommonTypes-4.0\" xmlns:tyler=\"urn:tyler:ecf:extensions:Common\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"><ecf:SendingMDELocationID><nc:IdentificationID>https://courts.wa.gov:8000</nc:IdentificationID></ecf:SendingMDELocationID><ecf:SendingMDEProfileCode>urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0</ecf:SendingMDEProfileCode><j:CaseCourt><nc:OrganizationIdentification><nc:IdentificationID>texfile</nc:IdentificationID></nc:OrganizationIdentification></j:CaseCourt><ecf:Error><ecf:ErrorCode>0</ecf:ErrorCode><ecf:ErrorText>No error</ecf:ErrorText></ecf:Error></FilingListResponseMessage></s:Body></s:Envelope>"} []
[2023-10-11 19:26:58] dev.INFO: GetPolicyCleanObject [] []
[2023-10-11 19:26:58] dev.INFO: filing list SimpleXMLElement Object
(
    [SendingMDELocationID] => SimpleXMLElement Object
        (
            [IdentificationID] => https://courts.wa.gov:8000
        )

    [SendingMDEProfileCode] => urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:WebServicesMessaging-2.0
    [CaseCourt] => SimpleXMLElement Object
        (
            [OrganizationIdentification] => SimpleXMLElement Object
                (
                    [IdentificationID] => texfile
                )

        )

    [Error] => SimpleXMLElement Object
        (
            [ErrorCode] => 0
            [ErrorText] => No error
        )

)
 [] []
[2023-10-11 19:27:35] 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-09-11 00:00:00" AND va.created_at <= "2023-10-11 23:59:59" ORDER BY va.created_at DESC [] []