View Resources

View resources provide access to complex query processing. You can assign security control to such resources. You cannot update view resources. The system-required view composition for View/Base Table Mapping is not provided by all databases. SQL Database Views are provided as RESTful Resource endpoints, supplying results as JSON.

Automatic Discovery

Live API Creator reads the Schema to discover the Views in your database and make them available as endpoints. You can use the Schema screen to see your views:

GET

Invoke Views using GET as shown below, using this URL:

http://localhost:8080/APIServer/rest/el-local/demo/v1/demo%3ALineItemJoinProduct

Filtering, OrderBy

View resources support filter and order parameters. Pagination is supported. View resources do not support access based on primary key.

Update

You cannot PUT, POST and DELETE views. Consider defining a Custom Resource.

Row Permissions

Live API Creator does not provide row and column access-level permission for views. Live API Creator does not have information about the SQL internals used to formulate the view.