Home > SQL Developer Dialog Boxes ... > Create/Edit Resource Handler
This dialog box is displayed if you right-click on the resource template name in the RESTful Services Administration pane and select New Handler, then the method type (GET, POST, PUT, or DELETE), or if you edit an existing handler. (If a handler already exists, the menu item for that method type is disabled.) The specific options depend on the method type.
Method: HTTP request method for this handler: GET (retrieves a representation of a resource), POST (creates a new resource or adds a resource to a collection), PUT (updates an existing resource), or DELETE (deletes an existing resource). Only one handler for each HTTP method is permitted.
Requires Secure Access: Indicates whether the resource should be accessed through a secure channel such as HTTPS.
Source Type: Source implementation for the selected HTTP method:
Feed: Executes a SQL query and transforms the results into a JSON Feed representation. Each item in the feed contains a summary of a resource and a hyperlink to a full representation of the resource. The first column in each row in the result set must be a unique identifier for the row and is used to form a hyperlink of the form: path/to/feed/{id}, with the value of the first column being used as the value for {id}. The other columns in the row are assumed to summarize the resource and are included in the feed. A separate resource template for the full representation of the resource should also be defined. Result Format: JSON
Media Resource: Executes a SQL Query conforming to a specific format and turns the result set into a binary representation with an accompanying HTTP Content-Type header identifying the Internet media type of the representation. Result Format: Binary
PL/SQL: Executes an anonymous PL/SQL block and transforms any OUT or IN/OUT parameters into a JSON representation. Available only when the HTTP method is DELETE, PUT, or POST. Result Format: JSON
Query: Executes a SQL Query and transforms the result set into either a JavaScript Object Notation (JSON) or CSV representation, depending on the format selected. Available when the HTTP method is GET. Result Format: JSON or CSV
Query One Row: Executes a SQL Query returning one row of data into a JSON representation. Available when the HTTP method is GET. Result Format: JSON
Data Format: If the Source Type is Query Source, the Data Format that is available is JSON or CSV.
Pagination Size (GET handler): Default pagination size for the module's resource templates: size of the pagination window, or the number of rows to return for a database query.
MIME Types (PUT and POST handlers): Content types.
Related Topics: