Reporting


Click here for a complete list of operations.

RetrieveCustomReport

This method returns a CSV string containing the requested custom report data. [sTicket] Ticket returned by AuthService.asmx. [sQueryNm] The MeridianLink Mortgage custom report name. [includeAllWithAccess] If true then the report will include all loans up to the loan access level of the authenticated user (Corporate | Branch | Individual). Otherwise the report will only include loans that the user is explicitly assigned to (Individual level).

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /los/webservice/Reporting.asmx HTTP/1.1
Host: secure.lendingqb.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.lendersoffice.com/los/webservices/RetrieveCustomReport"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <RetrieveCustomReport xmlns="http://www.lendersoffice.com/los/webservices/">
      <sTicket>string</sTicket>
      <sQueryNm>string</sQueryNm>
      <includeAllWithAccess>boolean</includeAllWithAccess>
    </RetrieveCustomReport>
  </soap:Body>
</soap:Envelope>
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <RetrieveCustomReportResponse xmlns="http://www.lendersoffice.com/los/webservices/">
      <RetrieveCustomReportResult>string</RetrieveCustomReportResult>
    </RetrieveCustomReportResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /los/webservice/Reporting.asmx HTTP/1.1
Host: secure.lendingqb.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <RetrieveCustomReport xmlns="http://www.lendersoffice.com/los/webservices/">
      <sTicket>string</sTicket>
      <sQueryNm>string</sQueryNm>
      <includeAllWithAccess>boolean</includeAllWithAccess>
    </RetrieveCustomReport>
  </soap12:Body>
</soap12:Envelope>
HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <RetrieveCustomReportResponse xmlns="http://www.lendersoffice.com/los/webservices/">
      <RetrieveCustomReportResult>string</RetrieveCustomReportResult>
    </RetrieveCustomReportResponse>
  </soap12:Body>
</soap12:Envelope>