{"id":3733,"date":"2023-08-31T07:48:09","date_gmt":"2023-08-31T06:48:09","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3733"},"modified":"2024-06-24T12:53:06","modified_gmt":"2024-06-24T11:53:06","slug":"get-data","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/api\/methods\/data-tables\/get-data\/","title":{"rendered":"Get data"},"content":{"rendered":"\n

DataTable collection selecting using HTTP POST method.<\/p>\n\n\n\n

<\/a><\/a>Request data format<\/strong><\/h3>\n\n\n\n

Request URL parameters:<\/p>\n\n\n\n

Element\/attribute<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
ApiKey<\/td>string<\/td>Your API key, required for authentication. Required.<\/td><\/tr>
TableName<\/td>string<\/td>Table name. Required.<\/td><\/tr>
Columns<\/td>complex<\/td>Collection of column to select (Column elements). Optional.<\/td><\/tr>
WhereConditions<\/td>complex<\/td>Collection of where conditions (Where elements). Optional.<\/td><\/tr>
OrderByColumns<\/td>complex<\/td>Collection of order by rules (OrderBy elements). Optional.<\/td><\/tr>
Limit<\/td>int<\/td>Number of rows in table. Optional.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Columns element children:<\/p>\n\n\n\n

Element\/attribute<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
Column<\/td>string<\/td>Column name. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Where element children:<\/p>\n\n\n\n

Element\/attribute<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
ColumnName<\/td>string<\/td>Column name. Required.<\/td><\/tr>
Operator<\/td>string<\/td>Operator name. Valid values are:
Equals
NotEqual
Greater
GreaterOrEqual
Lower
LowerOrEqua
Like – only for text values

Required.<\/td><\/tr>
Value<\/td>string<\/td>Value to search. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

OrderBy element children:<\/p>\n\n\n\n

Element\/attribute<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
ColumnName<\/td>string<\/td>Column name. Required.<\/td><\/tr>
Direction<\/td>string<\/td>Ordering direction. Valid values are:
Ascending
Descending

Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Response<\/strong><\/h3>\n\n\n\n

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”.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

SV output is formatted using following settings:<\/p>\n\n\n\n