How to fetch the comments of associated workflow with the document/file on sharepoint

Question

Hi Team,

I am looking for the API, that returns the entire workflow metadata associated with a document

Currently, I am using the below API, that returns the associated workflow with status but the comments is missing in the response.

api/Web/Lists(guid'6f970319-5211-4a7f-a66d-d2b7da0fadce')/Items(256)/FieldValuesAsText

Please find the attached screenshots for the reference.

I have rejected the document with a comment, but it's not coming in the response.
I want to retrieve that comment as well.

Best Regards,
Uddeshya Pratik

Answer 1

Hi PratikUddeshya-7348,

'Approval Status' and 'Approver Comments' come from the built-in feature 'Content approval', you can enable it in 'versioning setting'

And its comments stores in the field 'OData__ModerationComments' :

Check https://www.c-sharpcorner.com/blogs/getting-approval-status-and-comments-in-flow

And there is an approval workflow :

It will add a 'xxxworkflow status' column into the list. But note that this is a different feature.

And its comments store in taks item:

So you can retrevel it in the task list (the list that is assoicated with the workflow) , and you can filter the task item by WorkflowItemId/WorkflowListId (or other fields).

More Reference:

• https://social.technet.microsoft.com/Forums/en-US/18c48e2e-1e7d-43e0-86a8-9929469e155f/how-to-add-sp2010-workflow-approval-comments-and-update-consolidated-comments-using-client-side?forum=sharepointgeneralprevious

Best Regards,
Baker Kong