I am trying to access the field 'ThreadIndex' using the SharePoint REST API.
When I try to include it in the select query option, I am getting a bad request response code.
Here is the URL I am trying:
https://<site>/sites/<list_name>/_api/Web/lists/GetByTitle('list name')/Items?$expand=Author&$select=GUID,ID,TargetID,ThreadIndex,ContentTypeId,Modified,Created,FileDirRef,Title,Body,Author/Id,Author/Title
What am I doing wrong?
The ContentType of the list item is Message with ThreadIndex listed as a column of type 'ThreadIndex'
UPDATE:
When I make the following call, I can see the field 'ThreadIndex' and it's value:
https://<domain>/sites/<site>/_api/Web/Lists/GetByTitle('list name')/Items(60218)/FieldValuesForEdit
Which returns:
"TrimmedBody": "",
"DiscussionLastUpdated": "2/27/2020 9:18 AM",
"MessageId": "<e160df2a47ca41c2bce7b58e64730b63@SharePoint>",
"ThreadTopic": "",
"ThreadIndex": "0x01D4CABEB71B6ABB4764158C4D4399D589D8B774A45E",
But I need to be able to get this field value without having to select a specific item.
ThreadIndex
is of a type not natively supported by REST, you may have to use the RenderListDataAsStream API. – willman Mar 5 '20 at 16:29