Skip to content

Get data

DataTable collection selecting using HTTP POST method.

Request data format

Request URL parameters:

Element/attributeTypeNotes
ApiKeystringYour API key, required for authentication. Required.
TableNamestringTable name. Required.
ColumnscomplexCollection of column to select (Column elements). Optional.
WhereConditionscomplexCollection of where conditions (Where elements). Optional.
OrderByColumnscomplexCollection of order by rules (OrderBy elements). Optional.
LimitintNumber of rows in table. Optional.

Columns element children:

Element/attributeTypeNotes
ColumnstringColumn name. Required.

Where element children:

Element/attributeTypeNotes
ColumnNamestringColumn name. Required.
OperatorstringOperator name. Valid values are:
Equals
NotEqual
Greater
GreaterOrEqual
Lower
LowerOrEqua
Like – only for text values

Required.
ValuestringValue to search. Required.

OrderBy element children:

Element/attributeTypeNotes
ColumnNamestringColumn name. Required.
DirectionstringOrdering direction. Valid values are:
Ascending
Descending

Required.

Response

The response from this method is always data in CSV format, rather than XML, because the amount of data returned can be substantial. CSV response minimizes overheads and allows for seamless integration with third party code/systems. Response content type is “text/csv”.

Returned data contains a header with column names in the first row only when Columns element have been specified in the request. If the Columns element have not been specified the CSV file will include data from all the columns in a data table without the header.

SV output is formatted using following settings:

  • Field separator: comma (,)
  • Quoting character: (“)
  • Escape character: (“)
  • Encoding: UTF-8

Examples

Request:

POST https://api.esv2.com/v2/Api/DataTablesGetData HTTP/1.1
Accept-Encoding: gzip,deflate
Content-Type: text/xml
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
Content-Length: 563

<ApiRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <ApiKey>test_api_key1</ApiKey>
    <TableName>Table1</TableName>
    <Columns>
        <Column>Column1</Column>
        <Column>Column5</Column>
    </Columns>
    <WhereConditions>
         <Where>
             <ColumnName>Column1</ColumnName>
             <Operator>Equals</Operator>
             <Value>test</Value>
         </Where>
    </WhereConditions>
    <OrderByColumns>
         <OrderBy>
             <ColumnName>Column1</ColumnName>
             <Direction>Ascending</Direction>
         </OrderBy>
    </OrderByColumns>
    <Limit>50</Limit>
</ApiRequest>

Response:

HTTP/1.1 200 OK
Cache-Control: private
Content-Type: text/csv; charset=utf-8
Content-Encoding: gzip
Vary: Accept-Encoding
Server: Microsoft-IIS/7.5
X-AspNetMvc-Version: 3.0
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
Date: Wed, 23 Jan 2013 12:18:23 GMT
Content-Length: 201


Column1,Column5 
Example string,1/14/2012 12:00:00 AM