You can translate the question and the replies:

Able to Connect to a SharePoint list but all Multi-select fields are missing

I am able to connect with OAuth2 to our Sharepoint site and pull down various lists, without issues. However, I have noticed that any fields that are "multi-select" are missing from the schema. Is there a setting I need to change to get this to work?
user
30-09-2020 20:41:20 -0400

2 Answers

Hi, In scenarios where there are multi-value enabled columns, I would check the option "Expand Related Entities" while creating the base view. In case, if this option is checked, the references to other entities would appear directly in the main entity as [arrays or registers](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_derived_views/creating_flatten_views/creating_flatten_views). You could take a look at the Knowledge Base (KB) articles [Microsoft SharePoint as data source](https://community.denodo.com/kb/view/document/Microsoft%20SharePoint%20as%20data%20source?category=Data+Sources) and [How to connect Denodo to Sharepoint Online using OData with OAuth authentication](https://community.denodo.com/kb/view/document/How%20to%20connect%20Denodo%20to%20Sharepoint%20Online%20using%20OData%20with%20OAuth%20authentication?category=Security) for more information. Also, you could refer to [Denodo OData2 Custom Wrapper - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/latest/Denodo%20OData2%20Custom%20Wrapper%20-%20User%20Manual#h.fj64zz50lz0a) to know more about the features, limitations, etc. about the wrapper. Hope this helps!
Denodo Team
01-10-2020 07:54:37 -0400
Yes, thank you - I found this in the materials. It seems to be working and I was able to parse the values using the flatten feature.
user
01-10-2020 08:05:36 -0400
You must sign in to add an answer. If you do not have an account, you can register here