[SharePoint 2019] OData Duplicate Properties Exception

%3CLINGO-SUB%20id%3D%22lingo-sub-1305237%22%20slang%3D%22en-US%22%3E%5BSharePoint%202019%5D%20OData%20Duplicate%20Properties%20Exception%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1305237%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20currently%20migrating%20from%20SharePoint%202016%20to%202019.%20In%20one%20of%20our%20lists%20we%20have%20a%20list%20column%20named%26nbsp%3B%3CEM%3EActivities%3C%2FEM%3E.%20Unfortunately%20on%20SharePoint%202019%20we%20now%20get%20an%20OData%20exception%20when%20querying%20this%20list%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3EGET%3A%20https%3A%2F%2Fxxx%2Fyyy%2F_api%2Fweb%2Flists%2Fgetbyid('%7B4de912c2-5e6d-44c2-9d82-825287841608%7D')%2Fitems(1)%3F%24select%3DTitle%2CActivities%3C%2FCODE%3E%3C%2FPRE%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3ERequest%20to%20'https%3A%2F%2Fxxx%2Fyyy%2F_api%2Fweb%2Flists%2Fgetbyid('%7B4de912c2-5e6d-44c2-9d82-825287841608%7D')%2Fitems(1)%3F%24select%3DTitle%2CActivities'%20failed.%20%7B%22error%22%3A%7B%22code%22%3A%22-1%2C%20Microsoft.Data.OData.ODataException%22%2C%22message%22%3A%7B%22lang%22%3A%22en-US%22%2C%22value%22%3A%22Multiple%20properties%20with%20the%20name%20'Activities'%20were%20detected%20in%20an%20entry%20or%20a%20complex%20value.%20In%20OData%2C%20duplicate%20property%20names%20are%20not%20allowed.%22%7D%7D%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20error%20only%20occurs%20on%20SharePoint%202019%20(16.0.10357.20002).%20Works%20perfectly%20fine%20on%20SharePoint%202016%20as%20well%20as%20on%20SharePoint%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditional%20information%3A%3C%2FP%3E%3CUL%3E%3CLI%3EList%20column%20type%3A%20Multi-text%3C%2FLI%3E%3CLI%3EChanging%20the%20list%20column%20type%20(eg.%20to%20single%20text)%20doesn't%20make%20any%20difference%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1305237%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPIs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

We're currently migrating from SharePoint 2016 to 2019. In one of our lists we have a list column named Activities. Unfortunately on SharePoint 2019 we now get an OData exception when querying this list:

 

GET: https://xxx/yyy/_api/web/lists/getbyid('{4de912c2-5e6d-44c2-9d82-825287841608}')/items(1)?$select=Title,Activities
Request to 'https://xxx/yyy/_api/web/lists/getbyid('{4de912c2-5e6d-44c2-9d82-825287841608}')/items(1)?$select=Title,Activities' failed. {"error":{"code":"-1, Microsoft.Data.OData.ODataException","message":{"lang":"en-US","value":"Multiple properties with the name 'Activities' were detected in an entry or a complex value. In OData, duplicate property names are not allowed."}}}

 

 

The error only occurs on SharePoint 2019 (16.0.10357.20002). Works perfectly fine on SharePoint 2016 as well as on SharePoint Online.

 

Additional information:

  • List column type: Multi-text
  • Changing the list column type (eg. to single text) doesn't make any difference

 

Any ideas?

 

0 Replies