DataService


Click here for a complete list of operations.

ExecuteStageSQLSimpleDTT

Execute simple stage sql commands on the master DevTestDB

Test

The test form is only available for methods with primitive types as parameters.

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

<?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:Header>
    <SoapHeaderDatas xmlns="http://www.techexcel.com/txwebservice/">
      <IsAdmin>int</IsAdmin>
      <IsCheckOut>int</IsCheckOut>
      <EnableStaging>int</EnableStaging>
      <IsStaging>int</IsStaging>
      <StrExt>string</StrExt>
      <UserName>string</UserName>
      <Password>string</Password>
      <EnableCompression>int</EnableCompression>
      <ProductType>int</ProductType>
      <IsHosting>int</IsHosting>
      <PersonID>int</PersonID>
      <ProjectID>int</ProjectID>
      <PageID>int</PageID>
      <CustomerID>string</CustomerID>
    </SoapHeaderDatas>
  </soap:Header>
  <soap:Body>
    <ExecuteStageSQLSimpleDTT xmlns="http://www.techexcel.com/txwebservice/">
      <Username>string</Username>
      <Password>string</Password>
      <sqlcmdbytes>base64Binary</sqlcmdbytes>
    </ExecuteStageSQLSimpleDTT>
  </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>
    <ExecuteStageSQLSimpleDTTResponse xmlns="http://www.techexcel.com/txwebservice/">
      <ExecuteStageSQLSimpleDTTResult>
        <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>
      </ExecuteStageSQLSimpleDTTResult>
    </ExecuteStageSQLSimpleDTTResponse>
  </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 /DevSuiteAdminService/DataService.asmx HTTP/1.1
Host: trydevsuite.techexcel.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:Header>
    <SoapHeaderDatas xmlns="http://www.techexcel.com/txwebservice/">
      <IsAdmin>int</IsAdmin>
      <IsCheckOut>int</IsCheckOut>
      <EnableStaging>int</EnableStaging>
      <IsStaging>int</IsStaging>
      <StrExt>string</StrExt>
      <UserName>string</UserName>
      <Password>string</Password>
      <EnableCompression>int</EnableCompression>
      <ProductType>int</ProductType>
      <IsHosting>int</IsHosting>
      <PersonID>int</PersonID>
      <ProjectID>int</ProjectID>
      <PageID>int</PageID>
      <CustomerID>string</CustomerID>
    </SoapHeaderDatas>
  </soap12:Header>
  <soap12:Body>
    <ExecuteStageSQLSimpleDTT xmlns="http://www.techexcel.com/txwebservice/">
      <Username>string</Username>
      <Password>string</Password>
      <sqlcmdbytes>base64Binary</sqlcmdbytes>
    </ExecuteStageSQLSimpleDTT>
  </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>
    <ExecuteStageSQLSimpleDTTResponse xmlns="http://www.techexcel.com/txwebservice/">
      <ExecuteStageSQLSimpleDTTResult>
        <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>
      </ExecuteStageSQLSimpleDTTResult>
    </ExecuteStageSQLSimpleDTTResponse>
  </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 /DevSuiteAdminService/DataService.asmx/ExecuteStageSQLSimpleDTT?Username=string&Password=string&sqlcmdbytes=string&sqlcmdbytes=string HTTP/1.1
Host: trydevsuite.techexcel.com
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 /DevSuiteAdminService/DataService.asmx/ExecuteStageSQLSimpleDTT HTTP/1.1
Host: trydevsuite.techexcel.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

Username=string&Password=string&sqlcmdbytes=string&sqlcmdbytes=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>