DataService
Click here for a complete list of operations.
ExecuteStageSQLSimple
Execute simple stage sql commands on the master DevTrackDB
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/ExecuteStageSQLSimple" <?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> <ExecuteStageSQLSimple xmlns="http://www.techexcel.com/txwebservice/"> <Username>string</Username> <Password>string</Password> <sqlcmdbytes>base64Binary</sqlcmdbytes> </ExecuteStageSQLSimple> </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> <ExecuteStageSQLSimpleResponse xmlns="http://www.techexcel.com/txwebservice/"> <ExecuteStageSQLSimpleResult> <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> </ExecuteStageSQLSimpleResult> </ExecuteStageSQLSimpleResponse> </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> <ExecuteStageSQLSimple xmlns="http://www.techexcel.com/txwebservice/"> <Username>string</Username> <Password>string</Password> <sqlcmdbytes>base64Binary</sqlcmdbytes> </ExecuteStageSQLSimple> </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> <ExecuteStageSQLSimpleResponse xmlns="http://www.techexcel.com/txwebservice/"> <ExecuteStageSQLSimpleResult> <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> </ExecuteStageSQLSimpleResult> </ExecuteStageSQLSimpleResponse> </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/ExecuteStageSQLSimple?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/ExecuteStageSQLSimple 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>