Hydeews

Click here for a complete list of operations.

executesql

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 /hydeews.asmx HTTP/1.1
Host: ad1nk123.gnway.org
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "hydeesoft/executesql"

<?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>
    <executesql xmlns="hydeesoft/">
      <verify_local>string</verify_local>
      <userid>string</userid>
      <requesttype>int</requesttype>
      <compressionlevel>int</compressionlevel>
      <timeout>int</timeout>
      <maxsize>int</maxsize>
      <input>base64Binary</input>
      <inputiscompression>boolean</inputiscompression>
      <pagesize>int</pagesize>
    </executesql>
  </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>
    <executesqlResponse xmlns="hydeesoft/">
      <executesqlResult>int</executesqlResult>
      <outdata>base64Binary</outdata>
      <outiscompression>boolean</outiscompression>
      <allsize>int</allsize>
      <sended>int</sended>
      <pagehandle>int</pagehandle>
      <pagepwd>string</pagepwd>
      <error>string</error>
    </executesqlResponse>
  </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 /hydeews.asmx HTTP/1.1
Host: ad1nk123.gnway.org
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>
    <executesql xmlns="hydeesoft/">
      <verify_local>string</verify_local>
      <userid>string</userid>
      <requesttype>int</requesttype>
      <compressionlevel>int</compressionlevel>
      <timeout>int</timeout>
      <maxsize>int</maxsize>
      <input>base64Binary</input>
      <inputiscompression>boolean</inputiscompression>
      <pagesize>int</pagesize>
    </executesql>
  </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>
    <executesqlResponse xmlns="hydeesoft/">
      <executesqlResult>int</executesqlResult>
      <outdata>base64Binary</outdata>
      <outiscompression>boolean</outiscompression>
      <allsize>int</allsize>
      <sended>int</sended>
      <pagehandle>int</pagehandle>
      <pagepwd>string</pagepwd>
      <error>string</error>
    </executesqlResponse>
  </soap12:Body>
</soap12:Envelope>