DataWarehouse


Click here for a complete list of operations.

SelectRowsFromDwTable

Selects details of rows in a DWTable. The reference column is defined by Key and Value pair.

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 /ecomm/DataWarehouse.asmx HTTP/1.1
Host: ws.euromsg.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://ws.euromsg.com/datawarehouse/SelectRowsFromDwTable"

<?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>
    <SelectRowsFromDwTable xmlns="http://ws.euromsg.com/datawarehouse">
      <ServiceTicket>string</ServiceTicket>
      <DwTableName>string</DwTableName>
      <Key>string</Key>
      <Value>string</Value>
    </SelectRowsFromDwTable>
  </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>
    <SelectRowsFromDwTableResponse xmlns="http://ws.euromsg.com/datawarehouse">
      <SelectRowsFromDwTableResult />
      <DemograficData>
        <ArrayOfEmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
        </ArrayOfEmKeyValue>
        <ArrayOfEmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
        </ArrayOfEmKeyValue>
      </DemograficData>
    </SelectRowsFromDwTableResponse>
  </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 /ecomm/DataWarehouse.asmx HTTP/1.1
Host: ws.euromsg.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:Body>
    <SelectRowsFromDwTable xmlns="http://ws.euromsg.com/datawarehouse">
      <ServiceTicket>string</ServiceTicket>
      <DwTableName>string</DwTableName>
      <Key>string</Key>
      <Value>string</Value>
    </SelectRowsFromDwTable>
  </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>
    <SelectRowsFromDwTableResponse xmlns="http://ws.euromsg.com/datawarehouse">
      <SelectRowsFromDwTableResult />
      <DemograficData>
        <ArrayOfEmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
        </ArrayOfEmKeyValue>
        <ArrayOfEmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
          <EmKeyValue>
            <Key>string</Key>
            <Value>string</Value>
          </EmKeyValue>
        </ArrayOfEmKeyValue>
      </DemograficData>
    </SelectRowsFromDwTableResponse>
  </soap12:Body>
</soap12:Envelope>