VIEW operation by LAC

book

Article ID: 129666

calendar_today

Updated On:

Products

CA Live API Creator

Issue/Introduction



Is it possible to POST (insert) or PUT (update) to VIEW with "REST Lab" on LAC?

I tested it.
However, it failed.
The following error shown.
{
"statusCode": 500,
"errorCode": 50069,
"errorMessage": "You cannot insert, update or delete in table main:Test_View1 because it has no primary key."
}

Environment

Release:
Component: APILAC

Resolution

You can use REST Lab to call any REST operations on your API endpoints. 

For views, you need to define a virtual primary key in LAC and the underlying database supports updatable views. More information available here: 

Manage Views - CA Live API Creator - 5.1 - CA Technologies Documentation