{"id":3735,"date":"2023-08-31T07:50:14","date_gmt":"2023-08-31T06:50:14","guid":{"rendered":"https:\/\/help.expertsender.com\/?post_type=es&p=3735"},"modified":"2024-03-19T13:24:31","modified_gmt":"2024-03-19T12:24:31","slug":"count-rows","status":"publish","type":"es","link":"https:\/\/help.expertsender.com\/pl\/emp\/api\/methods\/data-tables\/count-rows\/","title":{"rendered":"Count rows"},"content":{"rendered":"\n

Count rows in a data table using HTTP POST method.<\/p>\n\n\n\n

<\/a><\/a>Request data format<\/strong><\/h3>\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>
WhereConditions<\/td>complex<\/td>Collection of where conditions (Where elements). Optional.<\/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 from collection: Equals, Greater, Lower, Like. Required.<\/td><\/tr>
Value<\/td>string<\/td>Value to search. Required.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

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

Response Count element:<\/p>\n\n\n\n

Element\/attribute<\/th>Type<\/th>Notes<\/th><\/tr><\/thead>
Count<\/td>int<\/td>Number of records in table.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Examples<\/strong><\/h3>\n\n\n\n

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

<\/path><\/path><\/svg><\/span>
POST https:\/\/api.esv2.com\/v2\/Api\/DataTablesGetDataCount HTTP\/1.1<\/span><\/span>\nAccept-Encoding: gzip,deflate<\/span><\/span>\nContent-Type: text\/xml<\/span><\/span>\nUser-Agent: Jakarta Commons-HttpClient\/3.1<\/span><\/span>\nHost: api.esv2.com<\/span><\/span>\nContent-Length: 346<\/span><\/span>\n<\/span>\n<<\/span>ApiRequest<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xs<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span>><\/span><\/span>\n   <\/span><<\/span>ApiKey<\/span>><\/span>test_api_key1<\/span><\/<\/span>ApiKey<\/span>><\/span><\/span>\n   <\/span><<\/span>TableName<\/span>><\/span>Tabela<\/span><\/<\/span>TableName<\/span>><\/span><\/span>\n   <\/span><<\/span>WhereConditions<\/span>><\/span><\/span>\n      <\/span><<\/span>Where<\/span>><\/span><\/span>\n         <\/span><<\/span>ColumnName<\/span>><\/span>Kolumna8<\/span><\/<\/span>ColumnName<\/span>><\/span><\/span>\n         <\/span><<\/span>Operator<\/span>><\/span>Like<\/span><\/<\/span>Operator<\/span>><\/span><\/span>\n         <\/span><<\/span>Value<\/span>><\/span>test<\/span><\/<\/span>Value<\/span>><\/span><\/span>\n      <\/span><\/<\/span>Where<\/span>><\/span><\/span>\n   <\/span><\/<\/span>WhereConditions<\/span>><\/span><\/span>\n<\/<\/span>ApiRequest<\/span>><\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Response:<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
HTTP\/1.1 200 OK<\/span><\/span>\nCache-Control: private<\/span><\/span>\nContent-Type: text\/xml; charset=utf-8<\/span><\/span>\nContent-Encoding: gzip<\/span><\/span>\nVary: Accept-Encoding<\/span><\/span>\nServer: Microsoft-IIS\/7.5<\/span><\/span>\nX-AspNetMvc-Version: 3.0<\/span><\/span>\nX-AspNet-Version: 4.0.30319<\/span><\/span>\nX-Powered-By: ASP.NET<\/span><\/span>\nDate: Wed, 23 Jan 2013 13:01:02 GMT<\/span><\/span>\nContent-Length: 212<\/span><\/span>\n<\/span>\n<<\/span>ApiResponse<\/span> <\/span>xmlns<\/span>:<\/span>xsd<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema<\/span>"<\/span> <\/span>xmlns<\/span>:<\/span>xsi<\/span>=<\/span>"<\/span>http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/span>"<\/span>><\/span><\/span>\n   <\/span><<\/span>Count<\/span>><\/span>2<\/span><\/<\/span>Count<\/span>><\/span><\/span>\n<\/<\/span>ApiResponse<\/span>><\/span><\/span><\/code><\/pre><\/div>\n","protected":false},"author":5,"featured_media":0,"parent":3729,"menu_order":270,"template":"","format":"standard","emp-category":[],"class_list":["post-3735","es","type-es","status-publish","format-standard","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es"}],"about":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/types\/es"}],"author":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":2,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3735\/revisions"}],"predecessor-version":[{"id":8846,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3735\/revisions\/8846"}],"up":[{"embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/es\/3729"}],"wp:attachment":[{"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/media?parent=3735"}],"wp:term":[{"taxonomy":"emp-category","embeddable":true,"href":"https:\/\/help.expertsender.com\/pl\/wp-json\/wp\/v2\/emp-category?post=3735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}