Layer7 API Management

We are using a MySQL database and are trying to update a table with no primary key ( with PUT, POST) for particular columns using a condition in 'sys filter' in CA LIVE API Creator. However, it is not getting updated, showing an error stating " you cannot insert, update, or delete in table main: tableName because it has no primary key.

Kindly suggest, is it not possible to update a table without a primary key?

Found the answer in the document. Writing the solution below for others,

It can be done by adding virtual primary keys to your views or table in LAC.

#virtualprimarykeys

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

Thanks!!