E1WAR_Services


Click here for a complete list of operations.

Warehouse_DoRead

Reads data from a data warehouse table.

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 /t1prtest/app/E1war_services.asmx HTTP/1.1
Host: t1.marlborough.govt.nz
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://TechnologyOneCorp.com/Public/Services/Warehouse_DoRead"

<?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>
    <Warehouse_DoRead xmlns="http://TechnologyOneCorp.com/Public/Services">
      <request WarehouseName="string" WarehouseTableName="string" RetrieveColumns="boolean">
        <Criteria>
          <Criterion PropertyName="string" OperatorCode="string" Value="string" Value2="string" />
          <Criterion PropertyName="string" OperatorCode="string" Value="string" Value2="string" />
        </Criteria>
      </request>
    </Warehouse_DoRead>
  </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>
    <Warehouse_DoReadResponse xmlns="http://TechnologyOneCorp.com/Public/Services">
      <Warehouse_DoReadResult>
        <Columns>
          <ColumnInfo Index="int" Name="string" Type="string" MaxLength="int" Unique="boolean" Nullable="boolean" />
          <ColumnInfo Index="int" Name="string" Type="string" MaxLength="int" Unique="boolean" Nullable="boolean" />
        </Columns>
        <Rows>
          <Row>string</Row>
          <Row>string</Row>
        </Rows>
      </Warehouse_DoReadResult>
    </Warehouse_DoReadResponse>
  </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 /t1prtest/app/E1war_services.asmx HTTP/1.1
Host: t1.marlborough.govt.nz
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>
    <Warehouse_DoRead xmlns="http://TechnologyOneCorp.com/Public/Services">
      <request WarehouseName="string" WarehouseTableName="string" RetrieveColumns="boolean">
        <Criteria>
          <Criterion PropertyName="string" OperatorCode="string" Value="string" Value2="string" />
          <Criterion PropertyName="string" OperatorCode="string" Value="string" Value2="string" />
        </Criteria>
      </request>
    </Warehouse_DoRead>
  </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>
    <Warehouse_DoReadResponse xmlns="http://TechnologyOneCorp.com/Public/Services">
      <Warehouse_DoReadResult>
        <Columns>
          <ColumnInfo Index="int" Name="string" Type="string" MaxLength="int" Unique="boolean" Nullable="boolean" />
          <ColumnInfo Index="int" Name="string" Type="string" MaxLength="int" Unique="boolean" Nullable="boolean" />
        </Columns>
        <Rows>
          <Row>string</Row>
          <Row>string</Row>
        </Rows>
      </Warehouse_DoReadResult>
    </Warehouse_DoReadResponse>
  </soap12:Body>
</soap12:Envelope>