query


Click here for a complete list of operations.

GetTableAsDataSet

Operacion que permite recuperar tabla de la base de datos como un dataset de ado.net en formato XML

Test

To test the operation using the HTTP POST protocol, click the 'Invoke' button.
Parameter Value
AliasName:
UserName:
Password:
TableName:
Columns:
Filter:
OrderBy:

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 /wsv/query.asmx HTTP/1.1
Host: api.maximise.cl
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://api.maximise.cl/GetTableAsDataSet"

<?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>
    <GetTableAsDataSet xmlns="http://api.maximise.cl">
      <AliasName>string</AliasName>
      <UserName>string</UserName>
      <Password>string</Password>
      <TableName>string</TableName>
      <Columns>string</Columns>
      <Filter>string</Filter>
      <OrderBy>string</OrderBy>
    </GetTableAsDataSet>
  </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>
    <GetTableAsDataSetResponse xmlns="http://api.maximise.cl">
      <GetTableAsDataSetResult>
        <xsd:schema>schema</xsd:schema>xml</GetTableAsDataSetResult>
    </GetTableAsDataSetResponse>
  </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 /wsv/query.asmx HTTP/1.1
Host: api.maximise.cl
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>
    <GetTableAsDataSet xmlns="http://api.maximise.cl">
      <AliasName>string</AliasName>
      <UserName>string</UserName>
      <Password>string</Password>
      <TableName>string</TableName>
      <Columns>string</Columns>
      <Filter>string</Filter>
      <OrderBy>string</OrderBy>
    </GetTableAsDataSet>
  </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>
    <GetTableAsDataSetResponse xmlns="http://api.maximise.cl">
      <GetTableAsDataSetResult>
        <xsd:schema>schema</xsd:schema>xml</GetTableAsDataSetResult>
    </GetTableAsDataSetResponse>
  </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 /wsv/query.asmx/GetTableAsDataSet?AliasName=string&UserName=string&Password=string&TableName=string&Columns=string&Filter=string&OrderBy=string HTTP/1.1
Host: api.maximise.cl

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<DataSet xmlns="http://api.maximise.cl">
  <schema xmlns="http://www.w3.org/2001/XMLSchema">schema</schema>xml</DataSet>

HTTP POST

The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.

POST /wsv/query.asmx/GetTableAsDataSet HTTP/1.1
Host: api.maximise.cl
Content-Type: application/x-www-form-urlencoded
Content-Length: length

AliasName=string&UserName=string&Password=string&TableName=string&Columns=string&Filter=string&OrderBy=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<DataSet xmlns="http://api.maximise.cl">
  <schema xmlns="http://www.w3.org/2001/XMLSchema">schema</schema>xml</DataSet>