Docs‎ > ‎CA Live API Creator‎ > ‎Create‎ > ‎Resources‎ > ‎

View Resources

SQL Database Views are provided as RESTful Resource End Points, supplying results as JSON.

Automatic Discovery

Live API Creator reads the Schema to discover the Views in your database and make them available as End Points.  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 fully supported.  View Resources do not support access based on primary key.


Update

Live API Creator does not currently support PUT, POST and DELETE operations on views.   Consider defining a Custom Resource.

Row Permissions

Row and Column access level permission is not currently supported for views since Live API Creator has no information about the SQL internals used to formulate the view.
Support for Row and Column access level permission tied to the VIEW only is planned for a future release.