DataService
Click here for a complete list of operations.
ExecuteStageSQLComplexDTT
Execute complex stage sql commands on the master DevTestDB
Test
To test the operation using the HTTP POST protocol, click the 'Invoke' button.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: optuminsight.techexcel.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.techexcel.com/txwebservice/ExecuteStageSQLComplexDTT"
<?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>
<ExecuteStageSQLComplexDTT xmlns="http://www.techexcel.com/txwebservice/">
<Username>string</Username>
<Password>string</Password>
<sqlcmd>string</sqlcmd>
</ExecuteStageSQLComplexDTT>
</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>
<ExecuteStageSQLComplexDTTResponse xmlns="http://www.techexcel.com/txwebservice/">
<ExecuteStageSQLComplexDTTResult>
<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>
</ExecuteStageSQLComplexDTTResult>
</ExecuteStageSQLComplexDTTResponse>
</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: optuminsight.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>
<ExecuteStageSQLComplexDTT xmlns="http://www.techexcel.com/txwebservice/">
<Username>string</Username>
<Password>string</Password>
<sqlcmd>string</sqlcmd>
</ExecuteStageSQLComplexDTT>
</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>
<ExecuteStageSQLComplexDTTResponse xmlns="http://www.techexcel.com/txwebservice/">
<ExecuteStageSQLComplexDTTResult>
<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>
</ExecuteStageSQLComplexDTTResult>
</ExecuteStageSQLComplexDTTResponse>
</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/ExecuteStageSQLComplexDTT?Username=string&Password=string&sqlcmd=string HTTP/1.1 Host: optuminsight.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/ExecuteStageSQLComplexDTT HTTP/1.1 Host: optuminsight.techexcel.com Content-Type: application/x-www-form-urlencoded Content-Length: length Username=string&Password=string&sqlcmd=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>