{"id":3749,"date":"2023-08-31T08:15:11","date_gmt":"2023-08-31T07:15:11","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3749"},"modified":"2024-06-25T13:06:24","modified_gmt":"2024-06-25T12:06:24","slug":"delete-rows","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/api\/methods\/data-tables\/delete-rows\/","title":{"rendered":"Delete rows"},"content":{"rendered":"\n

DataTablesDeleteRows collection allows deleting existing rows using HTTP POST method. It is possible to delete rows based on criteria in filters.<\/p>\n\n\n\n

Important!
Remeber to carefully check filter setting because incorrect use of filters can end up with removing too many records.<\/strong><\/p>\n\n\n\n

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

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

Parameter<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
ApiKey<\/td>string<\/td>Your API key, required for authentication. Required.<\/td><\/tr>
TableName<\/td>string<\/td>Name of Data Table. Required.<\/td><\/tr>
Filters<\/td>complex<\/td>Collection of Filter elements. This is an equivalent of SQL “WHERE” directive. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

Parameter<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
Name<\/td>string<\/td>Column name. Required.<\/td><\/tr>
Operator<\/td>string<\/td>Operator. Required. Can be one of the following:
EQ (equals, “=”). Default value
GT (greater than, “>”)
LT (lower than, “<“)
GE (greater or equal, “>=”)
LE (lower or equal, “<=”)<\/td><\/tr>
Value<\/td>string<\/td>Value. Required. See below for supported types.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Column element Value supported types:<\/p>\n\n\n\n