DataService


Click here for a complete list of operations.

GetDataFromDatabase

Select rowsets from database

Test

To test the operation using the HTTP POST protocol, click the 'Invoke' button.
Parameter Value
Username:
Password:
sqlcmd:
PageSize:
CurrentPage:
NeedCompress:

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 /TXCWWebService/DataService.asmx HTTP/1.1
Host: fujitsu.devsuite.net
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.techexcel.com/txwebservice/GetDataFromDatabase"

<?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>
    <GetDataFromDatabase xmlns="http://www.techexcel.com/txwebservice/">
      <Username>string</Username>
      <Password>string</Password>
      <sqlcmd>string</sqlcmd>
      <PageSize>int</PageSize>
      <CurrentPage>int</CurrentPage>
      <NeedCompress>int</NeedCompress>
    </GetDataFromDatabase>
  </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>
    <GetDataFromDatabaseResponse xmlns="http://www.techexcel.com/txwebservice/">
      <GetDataFromDatabaseResult>
        <ErrorType>int</ErrorType>
        <ErrorID>int</ErrorID>
        <ReturnMessage>string</ReturnMessage>
        <XMLData>base64Binary</XMLData>
        <XMLSchema>base64Binary</XMLSchema>
        <TableName>string</TableName>
        <IsDataCompressed>int</IsDataCompressed>
        <IsSchemaCompressed>int</IsSchemaCompressed>
        <SqlCommand>string</SqlCommand>
      </GetDataFromDatabaseResult>
    </GetDataFromDatabaseResponse>
  </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 /TXCWWebService/DataService.asmx HTTP/1.1
Host: fujitsu.devsuite.net
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>
    <GetDataFromDatabase xmlns="http://www.techexcel.com/txwebservice/">
      <Username>string</Username>
      <Password>string</Password>
      <sqlcmd>string</sqlcmd>
      <PageSize>int</PageSize>
      <CurrentPage>int</CurrentPage>
      <NeedCompress>int</NeedCompress>
    </GetDataFromDatabase>
  </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>
    <GetDataFromDatabaseResponse xmlns="http://www.techexcel.com/txwebservice/">
      <GetDataFromDatabaseResult>
        <ErrorType>int</ErrorType>
        <ErrorID>int</ErrorID>
        <ReturnMessage>string</ReturnMessage>
        <XMLData>base64Binary</XMLData>
        <XMLSchema>base64Binary</XMLSchema>
        <TableName>string</TableName>
        <IsDataCompressed>int</IsDataCompressed>
        <IsSchemaCompressed>int</IsSchemaCompressed>
        <SqlCommand>string</SqlCommand>
      </GetDataFromDatabaseResult>
    </GetDataFromDatabaseResponse>
  </soap12:Body>
</soap12:Envelope>

HTTP GET

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

GET /TXCWWebService/DataService.asmx/GetDataFromDatabase?Username=string&Password=string&sqlcmd=string&PageSize=string&CurrentPage=string&NeedCompress=string HTTP/1.1
Host: fujitsu.devsuite.net

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<RetStruct xmlns="http://www.techexcel.com/txwebservice/">
  <ErrorType>int</ErrorType>
  <ErrorID>int</ErrorID>
  <ReturnMessage>string</ReturnMessage>
  <XMLData>base64Binary</XMLData>
  <XMLSchema>base64Binary</XMLSchema>
  <TableName>string</TableName>
  <IsDataCompressed>int</IsDataCompressed>
  <IsSchemaCompressed>int</IsSchemaCompressed>
  <SqlCommand>string</SqlCommand>
</RetStruct>

HTTP POST

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

POST /TXCWWebService/DataService.asmx/GetDataFromDatabase HTTP/1.1
Host: fujitsu.devsuite.net
Content-Type: application/x-www-form-urlencoded
Content-Length: length

Username=string&Password=string&sqlcmd=string&PageSize=string&CurrentPage=string&NeedCompress=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<RetStruct xmlns="http://www.techexcel.com/txwebservice/">
  <ErrorType>int</ErrorType>
  <ErrorID>int</ErrorID>
  <ReturnMessage>string</ReturnMessage>
  <XMLData>base64Binary</XMLData>
  <XMLSchema>base64Binary</XMLSchema>
  <TableName>string</TableName>
  <IsDataCompressed>int</IsDataCompressed>
  <IsSchemaCompressed>int</IsSchemaCompressed>
  <SqlCommand>string</SqlCommand>
</RetStruct>