I have tried both CAML query and REST API to retrieve data from the Discussions List in the community site but I am unable to accesss the Replies column.

How to access this column and sort data?

Please help.

1 Answer 1


To get the list of replies

_api/lists/getByTitle('listname')/items?$filter=ContentType eq 'Message'


/_api/lists/getByTitle('listname')/items?$filter=FSObjType eq 0

To get the list of Discussions with the replies count:

/_api/lists/getByTitle('listname')/items?$select=ID,Title,Body,Folder/ItemCount &$expand=Folder/ItemCount &$filter=ContentType eq 'Discussion'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.