Service Web Service

Service

Click here for a complete list of operations.

GetTableInfo

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 /MasterServer/Service.asmx HTTP/1.1
Host: mc.brainysoft.biz
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "Master/GetTableInfo"

<?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>
    <SessionHeader xmlns="Master">
      <SessionId>string</SessionId>
      <UserHost>string</UserHost>
      <SystemClient>string</SystemClient>
    </SessionHeader>
  </soap:Header>
  <soap:Body>
    <GetTableInfo xmlns="Master">
      <connectionString>string</connectionString>
      <providerName>string</providerName>
      <useMainConnection>boolean</useMainConnection>
      <tableName>string</tableName>
      <schema>string</schema>
      <connectionParams>
        <KeyParameter>
          <Name>string</Name>
          <TypeName>string</TypeName>
          <Value />
        </KeyParameter>
        <KeyParameter>
          <Name>string</Name>
          <TypeName>string</TypeName>
          <Value />
        </KeyParameter>
      </connectionParams>
    </GetTableInfo>
  </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>
    <GetTableInfoResponse xmlns="Master">
      <GetTableInfoResult>
        <TableColumnDescriptor>
          <ColumnName>string</ColumnName>
          <DataTypeName>string</DataTypeName>
          <Nullable>boolean</Nullable>
        </TableColumnDescriptor>
        <TableColumnDescriptor>
          <ColumnName>string</ColumnName>
          <DataTypeName>string</DataTypeName>
          <Nullable>boolean</Nullable>
        </TableColumnDescriptor>
      </GetTableInfoResult>
    </GetTableInfoResponse>
  </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 /MasterServer/Service.asmx HTTP/1.1
Host: mc.brainysoft.biz
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>
    <SessionHeader xmlns="Master">
      <SessionId>string</SessionId>
      <UserHost>string</UserHost>
      <SystemClient>string</SystemClient>
    </SessionHeader>
  </soap12:Header>
  <soap12:Body>
    <GetTableInfo xmlns="Master">
      <connectionString>string</connectionString>
      <providerName>string</providerName>
      <useMainConnection>boolean</useMainConnection>
      <tableName>string</tableName>
      <schema>string</schema>
      <connectionParams>
        <KeyParameter>
          <Name>string</Name>
          <TypeName>string</TypeName>
          <Value />
        </KeyParameter>
        <KeyParameter>
          <Name>string</Name>
          <TypeName>string</TypeName>
          <Value />
        </KeyParameter>
      </connectionParams>
    </GetTableInfo>
  </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>
    <GetTableInfoResponse xmlns="Master">
      <GetTableInfoResult>
        <TableColumnDescriptor>
          <ColumnName>string</ColumnName>
          <DataTypeName>string</DataTypeName>
          <Nullable>boolean</Nullable>
        </TableColumnDescriptor>
        <TableColumnDescriptor>
          <ColumnName>string</ColumnName>
          <DataTypeName>string</DataTypeName>
          <Nullable>boolean</Nullable>
        </TableColumnDescriptor>
      </GetTableInfoResult>
    </GetTableInfoResponse>
  </soap12:Body>
</soap12:Envelope>