You can translate the question and the replies:

SharePoint List XML get all versions of each list item

We are having an issue with connecting to a SharePoint list via OData2. The list is using Append Changes for some of the columns so there are version of each list item. We cannot see the various versions ONLY the most current one. https://mycompany.sharepoint.com/teams/lms_help/portal/_vti_bin/owssvr.dll?XMLDATA=1&List={29329E39-175F-435A-ADB5-D7632A1CD143}&View={DFA2F380-17B7-4A5E-B4E8-F9D45459577B}&IncludeVersions=TRUE&RowLimit=0 Is there a way to use a similar URL string for another list but leverage the same authenitcation information I have for the OData2 connection?
user
26-07-2021 23:43:45 -0400
code

1 Answer

Hi, The OData 2 Custom Wrapper is an OData 2 connector, hence if the Sharepoint Odata endpoint allows connection to get all versions of the List and I would use the respective SharePoint endpoint to get the needed versions of the list. You could take a look at the** Sharepoint OData 2 API **documentation for more details on available API calls in SharePoint. As for extracting information from another List, I would create a new Datasource using the OData Custom Wrapper and provide the information to authenticate once again for the new datasource. You can take a look at the Knowledge Base Article [How to connect Denodo to Sharepoint Online using OData with OAuth authentication](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20Denodo%20to%20Sharepoint%20Online%20using%20OData%20with%20OAuth%20authentication) for more information on how to create a datasource pointing to Sharepoint. If you still need help and you are valid support user, then you can raise a new Support case at the[ Denodo Support Site](https://support.denodo.com/) so that our Support Team will assist you. Hope this helps!
Denodo Team
02-08-2021 09:01:46 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here