Difference between revisions of "NATS5 REST API Maintenance GET table-clean-count"
From TMM Wiki
Jump to navigationJump to search| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | {{NATS5 Manual |
| − | | | + | | show_api_admin_maintenance_section = true |
}} | }} | ||
== '''GET /maintenance/table-clean-count''' == | == '''GET /maintenance/table-clean-count''' == | ||
| + | |||
'''Description''' | '''Description''' | ||
* Get estimated rows for table cleanup | * Get estimated rows for table cleanup | ||
| Line 9: | Line 10: | ||
*Replace domain with the nats domain | *Replace domain with the nats domain | ||
| − | '''[[ | + | '''[[NATS5_REST_API_Overview#Allowed_HTTP_Request_Methods|Request Method''']] |
*GET | *GET | ||
'''Response Format''' | '''Response Format''' | ||
*JSON | *JSON | ||
| − | '''[[ | + | '''[[NATS5_REST_API_Overview#Authentication|Authentication]]''' |
*HTTP headers | *HTTP headers | ||
| Line 34: | Line 35: | ||
Method: '''GET'''<br/> | Method: '''GET'''<br/> | ||
URL: <nowiki>http://domain/api/maintenance/table-clean-count</nowiki><br/> | URL: <nowiki>http://domain/api/maintenance/table-clean-count</nowiki><br/> | ||
| − | Query String: <nowiki>table=transaction_summary&before=4+June+2017</nowiki><br/> | + | Query String: <nowiki>table=transaction_summary&before=4+June+2017&max_rows=60</nowiki><br/> |
Response: | Response: | ||
| Line 62: | Line 63: | ||
'table' => 'transaction_summary', | 'table' => 'transaction_summary', | ||
'before' => '4 June 2017', | 'before' => '4 June 2017', | ||
| + | 'max_rows' => 60, | ||
); | ); | ||
| Line 103: | Line 105: | ||
</pre> | </pre> | ||
| − | [[Category: | + | [[Category:NATS5_REST_APIs]] |
| − | [[Category: | + | [[Category:NATS5_REST_maintenance_Collection]] |
[[Category:Autogenerated_Wiki_Article]]<!-- Remove this tag when customizing a wiki article. The article will no longer be automatically updated --> | [[Category:Autogenerated_Wiki_Article]]<!-- Remove this tag when customizing a wiki article. The article will no longer be automatically updated --> | ||
[[Category:Autogenerated_Rest_Sample]]<!-- This article has a generated REST API Sample from our unit testing system. Also remove if customizing the wiki article --> | [[Category:Autogenerated_Rest_Sample]]<!-- This article has a generated REST API Sample from our unit testing system. Also remove if customizing the wiki article --> | ||
Latest revision as of 15:59, 9 August 2019
GET /maintenance/table-clean-count
Description
- Get estimated rows for table cleanup
Resource URL
- http://domain/api/maintenance/table-clean-count
- Replace domain with the nats domain
- GET
Response Format
- JSON
- HTTP headers
Parameters
Parameters can be sent as url encoded params
- table
- type: string
- required
- before
- type: datetime (A date string to be parsed by php strtotime, or a unix timestamp integer)
- required
- max_rows
- type: digit
- optional
Example Request
Method: GET
URL: http://domain/api/maintenance/table-clean-count
Query String: table=transaction_summary&before=4+June+2017&max_rows=60
Response:
{
"success": true,
"count": 0
}
Example Code
PHP
<?php
$headers = array( //set your username and API key here
'api-key: 44b5498dbcb481a0d00b404c0169af62',
'api-username: tmm1phrvezsbu'
);
$url = 'http://yourdomain.com'; //set your NATS URL here
$data = Array(
'table' => 'transaction_summary',
'before' => '4 June 2017',
'max_rows' => 60,
);
$request = Array(
'method' => 'GET',
'path' => 'v1/maintenance/table-clean-count',
'data' => $data
);
/*code below is the same for (almost) every API call */
$curl = curl_init();
$url = $url.'/api/'.$request['path'];
$query = http_build_query($request['data']);
if($request['method'] == 'GET'){
//add query string parameters to the end of the url
$url = $url.'?'.$query;
}else{
//send parameters as POST fields
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_POSTFIELDS, $query);
if($request['method'] != 'POST'){
$headers[] ='X-HTTP-Method: '.$request['method']; //send custom request method
}
}
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
$resp = curl_exec($curl);
//dumps an associative array representation of the json
var_dump(json_decode($resp, true));
// Close request to clear up some resources
curl_close($curl);
?>
