Get data

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