You can translate the question and the replies:

Post -xml derived view "Insert operation is not allowed". using Postman

I am trying to use POST type request in derived view using POSTMAN.Below is body which i am using <dv_test xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v1="http://gsk.com/Contract/RD/LotMetadata/LotMetadataInterface_BioReg_CF/v1" xmlns:v11="http://gsk.com/RD/BaseTypes/MessageContextObjectType/v1" xmlns:v12="http://gsk.com/RD/Services/LotMetadata/ComplexTypes/LotMetadataType/v1"> <upn>sk486486@gsk.com</upn> <lotsubmitingscientistupn>sk486486@gsk.com</lotsubmitingscientistupn> <cosubmitterupn>sk486486@gsk.com</cosubmitterupn> <lnbref>N12239-98-707</lnbref> </dv_test> with same root element derived view is created, but when i try to submit via postman i am getting below error <__errors__ xmlns="http://www.denodo.com/restful"> <error code="50202" message="View 'dv_test'. Insert operation is not allowed"></error> </__errors__> Could you please help.
user
08-09-2021 05:30:37 -0400

1 Answer

Hi, The error ***“View ’XXX’. Insert operation is not allowed”*** may occur when the user performing INSERT operation does not have enough privilege over the view or the view is not updateable. Hence, I would ensure that the user performing the INSERT operation has enough privilege, and also the view where the user tries to insert is updateable. You can refer to the section [Inserts, Updates and Deletes Over Views](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/inserts_updates_and_deletes_over_views/inserts_updates_and_deletes_over_views#inserts-updates-and-deletes-over-views) of the Virtual DataPort VQL Guide which lists the views which cannot be updated. If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support site](https://support.denodo.com/) so that the support team can assist you. Hope this helps!
Denodo Team
09-09-2021 08:35:10 -0400
You must sign in to add an answer. If you do not have an account, you can register here