The complete interface is also documented in two other forms:
_output
query parameter may be used to specify the media type. See Media Types for more discussion.
Method | Path | Request Body | Description | Detail |
---|---|---|---|---|
GET | /res/{resName}/{resId} | Returns row matching path parameters | ResGetPath | |
GET | /res/{resName}?{name}={value} | Returns rows matching query parameters | ResGetQuery | |
POST | /res/{resName} | URL Enc | Inserts row | ResPostUrlEnc |
POST | /res/{resName} | XML or JSON | Inserts rows | ResPostXmlOrJson |
POST | /res/{resName}/{resId} | XML or JSON | Inserts children rows for parent matching path parameters | ResPostPathXmlOrJson |
PUT | /res/{resName} | XML or JSON | Updates rows | ResPutXmlOrJson |
PUT | /res/{resName}/{resId} | URL Enc | Updates row matching path parameters | ResPutPathUrlEnc |
PUT | /res/{resName}/{resId} | XML or JSON | Updates children rows for parent matching path parameters | ResPutPathXmlOrJson |
PUT | /res/{resName}?{name}={value} | URL Enc | Updates rows matching query parameters | ResPutQueryUrlEnc |
DELETE | /res/{resName} | XML or JSON | Deletes rows | ResDeleteXmlOrJson |
DELETE | /res/{resName}/{resId} | Deletes row matching path parameters | ResDeletePath | |
DELETE | /res/{resName}/{resId} | XML or JSON | Deletes children rows for parent matching path parameters | ResDeletePathXmlOrJson |
DELETE | /res/{resName}?{name}={value} | Deletes rows matching query parameters | ResDeleteQuery |
GET | /res | Returns listing all SQL Resources and links for each to limited query, definition and metadata as HTML |
GET | /wadl | Returns restSQL WADL as XML with XSLT style sheet |
GET | /conf/system | Returns general framework configuration in structured text |
GET | /conf/log | Returns logging configuration in structured text |
GET | /conf/security | Returns security configuration, currently the privileges for authorization, in structured text |
GET | /conf/definition/{resName} | Returns SQL Resource definition (from user-provided XML file) |
GET | /conf/metadata/{resName} | Returns SQL Resource metadata as understood by restSQL |
GET | /conf/reload/{resName} | Reloads SQL Resource definition (from user-provided XML file) |
GET | /log | Returns browsable list of current and rollover access, error and trace log files, if any |
GET | /log/access | Returns current access log content |
GET | /log/error | Returns current error log content |
GET | /log/trace | Returns current trace log content |
GET | /log/trace | Returns current internal log content |
GET | /stats | Returns summary statistics such as number of requests, errors and average response times in structured text |