ServiceSP Web Service

ServiceSP

Click here for a complete list of operations.

UploadSysDBDataInSP

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 /ServiceSP.asmx HTTP/1.1
Host: 203.115.193.116
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://tempuri.org/UploadSysDBDataInSP"

<?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>
    <UploadSysDBDataInSP xmlns="http://tempuri.org/">
      <parameters>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <LocaleId>int</LocaleId>
          <Precision>unsignedByte</Precision>
          <Scale>unsignedByte</Scale>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <LocaleId>int</LocaleId>
          <Precision>unsignedByte</Precision>
          <Scale>unsignedByte</Scale>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
      </parameters>
      <dsEntry>
        <xsd:schema>schema</xsd:schema>xml</dsEntry>
      <SP_Name>string</SP_Name>
      <TBL_Name>string</TBL_Name>
      <errmsg>string</errmsg>
    </UploadSysDBDataInSP>
  </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>
    <UploadSysDBDataInSPResponse xmlns="http://tempuri.org/">
      <UploadSysDBDataInSPResult>boolean</UploadSysDBDataInSPResult>
      <errmsg>string</errmsg>
    </UploadSysDBDataInSPResponse>
  </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 /ServiceSP.asmx HTTP/1.1
Host: 203.115.193.116
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>
    <UploadSysDBDataInSP xmlns="http://tempuri.org/">
      <parameters>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <LocaleId>int</LocaleId>
          <Precision>unsignedByte</Precision>
          <Scale>unsignedByte</Scale>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
        <SqlParameter>
          <CompareInfo>None or IgnoreCase or IgnoreNonSpace or IgnoreKanaType or IgnoreWidth or BinarySort or BinarySort2</CompareInfo>
          <XmlSchemaCollectionDatabase>string</XmlSchemaCollectionDatabase>
          <XmlSchemaCollectionOwningSchema>string</XmlSchemaCollectionOwningSchema>
          <XmlSchemaCollectionName>string</XmlSchemaCollectionName>
          <LocaleId>int</LocaleId>
          <Precision>unsignedByte</Precision>
          <Scale>unsignedByte</Scale>
          <SqlDbType>BigInt or Binary or Bit or Char or DateTime or Decimal or Float or Image or Int or Money or NChar or NText or NVarChar or Real or UniqueIdentifier or SmallDateTime or SmallInt or SmallMoney or Text or Timestamp or TinyInt or VarBinary or VarChar or Variant or Xml or Udt or Structured or Date or Time or DateTime2 or DateTimeOffset</SqlDbType>
          <SqlValue />
          <UdtTypeName>string</UdtTypeName>
          <TypeName>string</TypeName>
          <Offset>int</Offset>
        </SqlParameter>
      </parameters>
      <dsEntry>
        <xsd:schema>schema</xsd:schema>xml</dsEntry>
      <SP_Name>string</SP_Name>
      <TBL_Name>string</TBL_Name>
      <errmsg>string</errmsg>
    </UploadSysDBDataInSP>
  </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>
    <UploadSysDBDataInSPResponse xmlns="http://tempuri.org/">
      <UploadSysDBDataInSPResult>boolean</UploadSysDBDataInSPResult>
      <errmsg>string</errmsg>
    </UploadSysDBDataInSPResponse>
  </soap12:Body>
</soap12:Envelope>