[2025-02-05 20:32:38] dev.INFO: API Response:  {"context":"NULL"} []
[2025-02-05 21:01:10] 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=\"9f3f91b7-0b53-46ca-a62b-15706782d07d\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.6.1.11416</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>2025-02-05T21:01:09.936Z</u:Created><u:Expires>2025-02-05T21:06:09.936Z</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\">-4</ErrorCode><ErrorText xmlns=\"urn:tyler:efm:services:schema:Common\">Authentication failed, invalid/expired authentication token or email/password combination</ErrorText></Error><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">0001-01-01T00:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2025-02-05 21:01:29] 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=\"5cc42b26-6e86-49bc-a2f2-5ca5e174a0db\" 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.6.1.11416</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>2025-02-05T21:01:29.607Z</u:Created><u:Expires>2025-02-05T21:06:29.607Z</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\">67821b5b-9adb-470b-bf19-34a4e4449c9d</UserID><Email xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">dariomartinelli02+mfrstageil_new@gmail.com</Email><FirstName xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">Dario</FirstName><LastName xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">Martinelli</LastName><PasswordHash xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">79371f78-ebf5-4d99-afc8-bf2099e0bf25</PasswordHash><ExpirationDateTime xmlns=\"urn:tyler:efm:services:schema:AuthenticateResponse\">6106-08-13T07:00:00</ExpirationDateTime></AuthenticateUserResponse></AuthenticateUserResponse></s:Body></s:Envelope>"} []
[2025-02-05 21:01:34] 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>dariomartinelli02+mfrstageil_new@gmail.com</UserName><Password>79371f78-ebf5-4d99-afc8-bf2099e0bf25</Password></ns1:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:GetFirm/></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2025-02-05 21:01:36] 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=\"f3280eca-6ace-438b-97e9-a7f5338ecae4\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.6.1.11416</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>2025-02-05T21:01:36.451Z</u:Created><u:Expires>2025-02-05T21:06:36.451Z</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=\"359250ff-0f50-4898-a7f4-86bf2e1e79db\" IsIndividual=\"false\" IsAgency=\"false\" xmlns=\"urn:tyler:efm:services:schema:GetFirmResponse\"><FirmName xmlns=\"urn:tyler:efm:services:schema:Common\">Dario Martinelli</FirmName><Address xmlns=\"urn:tyler:efm:services:schema:Common\"><AddressLine1>España 421</AddressLine1><AddressLine2/><City>Austin</City><State>TX</State><ZipCode>73301</ZipCode><Country>US</Country></Address><PhoneNumber xmlns=\"urn:tyler:efm:services:schema:Common\">3446548351</PhoneNumber></Firm></GetFirmResponse></GetFirmResponse></s:Body></s:Envelope>"} []
[2025-02-05 21:01: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:schema:GetUserRequest\" xmlns:ns2=\"urn:tyler:efm:services\"><SOAP-ENV:Header><ns2:UserNameHeader><UserName>dariomartinelli02+mfrstageil_new@gmail.com</UserName><Password>79371f78-ebf5-4d99-afc8-bf2099e0bf25</Password></ns2:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns2:GetUser><ns2:GetUserRequest><ns1:UserID>67821b5b-9adb-470b-bf19-34a4e4449c9d</ns1:UserID></ns2:GetUserRequest></ns2:GetUser></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2025-02-05 21:01: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=\"2c01648c-448b-4fc0-842d-c013fff2f0f4\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.6.1.11416</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>2025-02-05T21:01:38.379Z</u:Created><u:Expires>2025-02-05T21:06:38.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\"><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=\"67821b5b-9adb-470b-bf19-34a4e4449c9d\" FirmID=\"359250ff-0f50-4898-a7f4-86bf2e1e79db\" IsApproved=\"true\" IsActive=\"true\" IsActivated=\"true\" IsLockedOut=\"false\" xmlns=\"urn:tyler:efm:services:schema:Common\"><Email>dariomartinelli02+mfrstageil_new@gmail.com</Email><FirstName>Dario</FirstName><MiddleName/><LastName>Martinelli</LastName><LastLoginDate>2025-02-05T21:01:29.503</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>"} []
[2025-02-05 21:01:39] 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:Common\" xmlns:ns2=\"urn:tyler:efm:services\"><SOAP-ENV:Header><ns2:UserNameHeader><UserName>dariomartinelli02+mfrstageil_new@gmail.com</UserName><Password>79371f78-ebf5-4d99-afc8-bf2099e0bf25</Password></ns2:UserNameHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns2:CreateAttorney><ns2:CreateAttorneyRequest><ns1:Attorney AttorneyID=\"67821b5b-9adb-470b-bf19-34a4e4449c9d\" FirmID=\"359250ff-0f50-4898-a7f4-86bf2e1e79db\"><ns1:BarNumber>784513</ns1:BarNumber><ns1:FirstName>Dario</ns1:FirstName><ns1:MiddleName></ns1:MiddleName><ns1:LastName>Martinelli</ns1:LastName></ns1:Attorney></ns2:CreateAttorneyRequest></ns2:CreateAttorney></SOAP-ENV:Body></SOAP-ENV:Envelope>\n"} []
[2025-02-05 21:01:40] 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=\"5606ce2f-e51c-4f12-9c28-7832832cf629\" xmlns=\"http://schemas.microsoft.com/2004/09/ServiceModel/Diagnostics\">00000000-0000-0000-0000-000000000000</ActivityId><EFMConfigurationHeader xmlns=\"urn:tyler:efm:services\"><Version>2024.6.1.11416</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>2025-02-05T21:01:40.876Z</u:Created><u:Expires>2025-02-05T21:06:40.876Z</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\"><CreateAttorneyResponse xmlns=\"urn:tyler:efm:services\"><CreateAttorneyResponse><Error xmlns=\"urn:tyler:efm:services:schema:BaseResponse\"><ErrorCode xmlns=\"urn:tyler:efm:services:schema:Common\">82</ErrorCode><ErrorText xmlns=\"urn:tyler:efm:services:schema:Common\">Invalid Bar Number.</ErrorText></Error></CreateAttorneyResponse></CreateAttorneyResponse></s:Body></s:Envelope>"} []
[2025-02-05 21:02:02] dev.INFO: SELECT cd.id,cd.account_type, fem.filing_id, f.firmname as firm_name, cd.case_no as envelope_id, l.name as jurisdiction, fem.filing_client_matter as client_ref_no, cd.title as case_name, cd.docket_id as case_no, l.name as court, cd.filing_date as submission_date, cd.updated_at as filing_date, cd.pay_ac_id as payac_id, CONCAT_WS(" ", ua.firstname, ua.middlename, ua.lastname) as filing_attorney, CONCAT_WS(" ", uf.firstname, uf.middlename, uf.lastname) as filer, uf.email as filer_email, fc.name as filing_type, cd.is_draft as filing_status, ua.barnumber as bar_number, fem.filing_status_code as filing_status_code, f.firmname as law_firm, fem.processed_date as clerk_process_date, fem.card_type as payment_type, pa.accountname as payment_acc_name, fem.primary_acc_no as last_4_digits, fem.total_fees as total_fees, fem.provider_tax_fees, fem.provider_service_fees, fem.court_service_fees, fem.service_tax_fees, fem.filing_service_fees, fem.court_filing_fees, fem.court_case_fees, fem.convenience_fees, fem.lead_document as lead_document, cd.case_tracking_id, fem.redaction_fees, fem.mail_service_fees, fem.court_party_fee FROM file_envelope_map fem JOIN case_draft cd ON cd.id = fem.draft_id LEFT JOIN locations l ON  cd.location_code=l.code LEFT JOIN users ua ON ua.attorneyid = cd.filing_attorney_id LEFT JOIN users uf ON uf.id = cd.drafter_id LEFT JOIN filing_codes fc ON fem.filing_type_nfrc = fc.code AND cd.location_code = fc.location_code LEFT JOIN firm f ON uf.firmid = f.fid LEFT JOIN payaccount pa ON pa.payacid = cd.pay_ac_id  where uf.firmid = "359250ff-0f50-4898-a7f4-86bf2e1e79db" AND fem.filing_status_code in ("accepted")  GROUP BY filing_id ORDER BY envelope_id [] []