eWebService


Click here for a complete list of operations.

SqlDb

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 /eWebService.asmx HTTP/1.1
Host: emonitor.epicor.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://emonwebservice.com/SqlDb"

<?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>
    <SqlDb xmlns="http://emonwebservice.com/">
      <packet>
        <accountId>string</accountId>
        <customerId>string</customerId>
        <locationId>string</locationId>
        <machineName>string</machineName>
        <id1>string</id1>
        <dbName>string</dbName>
        <poll>short</poll>
        <changePoll>short</changePoll>
        <bNewValues>boolean</bNewValues>
        <dtDbBackup>dateTime</dtDbBackup>
        <dtLogBackup>dateTime</dtLogBackup>
        <recoveryMode>string</recoveryMode>
        <status>string</status>
        <missedBackups>int</missedBackups>
        <missedTlogs>int</missedTlogs>
      </packet>
    </SqlDb>
  </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>
    <SqlDbResponse xmlns="http://emonwebservice.com/">
      <SqlDbResult>
        <status>string</status>
        <poll>short</poll>
        <changePoll>short</changePoll>
        <newUrl>string</newUrl>
        <bCheckUpdates>boolean</bCheckUpdates>
        <bForceUpdates>boolean</bForceUpdates>
      </SqlDbResult>
    </SqlDbResponse>
  </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 /eWebService.asmx HTTP/1.1
Host: emonitor.epicor.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>
    <SqlDb xmlns="http://emonwebservice.com/">
      <packet>
        <accountId>string</accountId>
        <customerId>string</customerId>
        <locationId>string</locationId>
        <machineName>string</machineName>
        <id1>string</id1>
        <dbName>string</dbName>
        <poll>short</poll>
        <changePoll>short</changePoll>
        <bNewValues>boolean</bNewValues>
        <dtDbBackup>dateTime</dtDbBackup>
        <dtLogBackup>dateTime</dtLogBackup>
        <recoveryMode>string</recoveryMode>
        <status>string</status>
        <missedBackups>int</missedBackups>
        <missedTlogs>int</missedTlogs>
      </packet>
    </SqlDb>
  </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>
    <SqlDbResponse xmlns="http://emonwebservice.com/">
      <SqlDbResult>
        <status>string</status>
        <poll>short</poll>
        <changePoll>short</changePoll>
        <newUrl>string</newUrl>
        <bCheckUpdates>boolean</bCheckUpdates>
        <bForceUpdates>boolean</bForceUpdates>
      </SqlDbResult>
    </SqlDbResponse>
  </soap12:Body>
</soap12:Envelope>