Difference between revisions of "NATS5 REST API Maintenance PATCH table"
From TMM Wiki
Jump to navigationJump to searchm (TMMJoe moved page NATS4 REST API Maintenance PATCH table to NATS5 REST API Maintenance PATCH table: Renaming NATS5 API pages) |
|||
| Line 1: | Line 1: | ||
| − | {{ | + | {{NATS5 Manual |
| show_api_admin_section = true | | show_api_admin_section = true | ||
}} | }} | ||
== '''PATCH /maintenance/table''' == | == '''PATCH /maintenance/table''' == | ||
| + | |||
'''Description''' | '''Description''' | ||
* Cleanup table | * Cleanup table | ||
| 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''']] |
*PATCH | *PATCH | ||
'''Response Format''' | '''Response Format''' | ||
*JSON | *JSON | ||
| − | '''[[ | + | '''[[NATS5_REST_API_Overview#Authentication|Authentication]]''' |
*HTTP headers | *HTTP headers | ||
| Line 34: | Line 35: | ||
** optional | ** optional | ||
| + | == '''Example Request''' == | ||
| + | Method: '''PATCH'''<br/> | ||
| + | URL: <nowiki>http://domain/api/maintenance/table</nowiki><br/> | ||
| + | Form Data:<br/> | ||
| + | * table: trigger_tour_program_log | ||
| + | * before: 2019-06-10 | ||
| + | |||
| + | Response: | ||
| + | <pre> | ||
| + | { | ||
| + | "success": true, | ||
| + | "result": "table cleanup started" | ||
| + | } | ||
| + | </pre> | ||
| + | |||
| + | |||
| + | |||
== '''Example Code''' == | == '''Example Code''' == | ||
| Line 47: | Line 65: | ||
$url = 'http://yourdomain.com'; //set your NATS URL here | $url = 'http://yourdomain.com'; //set your NATS URL here | ||
| − | $data = | + | $data = Array( |
| − | + | 'table' => 'trigger_tour_program_log', | |
| + | 'before' => '2019-06-10', | ||
); | ); | ||
| Line 90: | Line 109: | ||
</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: | + | [[Category:Autogenerated_Rest_Sample]]<!-- This article has a generated REST API Sample from our unit testing system. Also remove if customizing the wiki article --> |
Revision as of 15:45, 9 August 2019
PATCH /maintenance/table
Description
- Cleanup table
Resource URL
- http://domain/api/maintenance/table
- Replace domain with the nats domain
- PATCH
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
- backup
- type: trinary_digit (0, 1, or 2)
- optional
Example Request
Method: PATCH
URL: http://domain/api/maintenance/table
Form Data:
- table: trigger_tour_program_log
- before: 2019-06-10
Response:
{
"success": true,
"result": "table cleanup started"
}
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' => 'trigger_tour_program_log',
'before' => '2019-06-10',
);
$request = Array(
'method' => 'PATCH',
'path' => 'v1/maintenance/table',
'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);
?>
