You can translate the question and the replies:

Adding or Editing Items in a Sharepoint list via a Denodo view/query

Please advise if there is anyway to Edit or Add Items on a Sharepoint List via an existing OData connection view. is this possible or are you only able to "read" a SharePoint list via Denodo?
user
15-07-2021 09:02:32 -0400

3 Answers

Hi, I would access Sharepoint list using the Denodo OData2 custom wrapper which allows for the pulling of data. This custom wrapper however, does not allow for inserts or updates of complex fields. For clarification on the OData2 Custom wrapper, please take a look at the [Denodo OData2 Custom Wrapper](https://community.denodo.com/docs/html/document/denodoconnects/8.0/Denodo%20OData2%20Custom%20Wrapper%20-%20User%20Manual) section in DenodoConnect Components in the user manual. Hope this helps! [](http://)
Denodo Team
15-07-2021 13:52:06 -0400
To clarify, is this possible to insert or update **ANY** fields? you mentioned complex ones. Just want to be clear.
user
15-07-2021 15:10:52 -0400
Hi, I can insert and update normal fields in the Denodo OData2 custom wrapper after the base view has been created. That does not mean though that the information in the data source will be updated. The underlying data source will remain unchanged. To change the data in the underlying data source, I will need to go in and change the information in the SharePoint list directly rather than changing the base view. Hope this helps!
Denodo Team
28-07-2021 11:58:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here