Clear table - ExpertSender Help Center

Clear table

Sending a POST request to DataTablesClearTable collection allows clearing data table contents. This is an equivalent of SQL TRUNCATE query. Please note that it is impossible to clear tables that are a destination part of relationship.

Request data format

Element/attribute	Type	Notes
ApiKey	string	Your API key, required for authentication. Required.
TableName	string	Table name. Required.

Response

Successfully clearing the table will result in HTTP 204 No Content response.

Examples

Request:

POST https://api.esv2.com/v2/Api/DataTablesClearTable/ HTTP/1.1
Accept-Encoding: gzip,deflate
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
Content-Length: 269

<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>
</ApiRequest>

OK response:

HTTP/1.1 204 No Content 
Cache-Control: private 
Server: Microsoft-IIS/7.5 
X-AspNetMvc-Version: 1.0 
X-AspNet-Version: 2.0.50727 
X-Powered-By: ASP.NET 
Date: Wed, 28 Oct 2009 15:35:17 GMT 
Content-Length: 0

Error response:

HTTP/1.1 400 Bad Request 
Cache-Control: private 
Content-Type: text/xml; charset=utf-8 
Server: Microsoft-IIS/7.5 
X-AspNetMvc-Version: 1.0 
X-AspNet-Version: 2.0.50727 
X-Powered-By: ASP.NET 
Date: Wed, 28 Oct 2009 11:32:07 GMT 
Content-Length: 273 

<ApiResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ErrorMessage>
    <Code>400</Code>
    <Message>Data tables that are destination of any relationship cannot be cleared.</Message>
  </ErrorMessage>
</ApiResponse>