How to fetch all the data associated with the document/file on sharepoint

Question

How to fetch all the data associated with the document/file on sharepoint

Pratik, Uddeshya 26

I am looking for an API that will help me to fetch all the column's values and associated data for a specific file on SharePoint.

Currently, I am using below URL to fetch the metadata of a file:

https://{{sitename}}/_api/web/getFileByServerRelativeUrl('{{docpath}}/Shared%20Documents/Test13.docx')/listItemAllFields

Which is showing various details, but it is not showing the corresponding workflow status for associated with the file(Please check the attached screenshot in the URL)

Please refer the below link for more description:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_win10-mso_o365b/how-to-fetch-all-the-data-associated-with-the/ec1e5d38-e8fc-42d5-9ea9-54040bda3415?tm=1597910908279

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Baker Kong-MSFT 3,801

Hi PratikUddeshya-7348,

I create a document library and attach a workflow then test the above endpoint:

However when i call the endpoint '.../listItemAllFields', it will return workflow status:

Could you please check it again at your end? And how about getting all fields from its associated item?

/_api/Web/Lists(guid'61bf90e1-1a2f-4686-b689-c1e7c0991284')/Items(184)/FieldValuesAsText

Best Regards,
Baker Kong

Pratik, Uddeshya 26 Reputation points

2020-08-24T13:29:37.97+00:00

Hi Baker,

Thanks for your response!!

But I am still not getting the attached workflow details with the above URL, however Using below URL

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

I am able to get Workflow status but the comment is missing in the metadata response.

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.
Baker Kong-MSFT 3,801 Reputation points

2020-08-25T04:58:37.207+00:00
Hi PratikUddeshya-7348,

I see that you have post the new question in another thread. i have writed an answer there. REFER TO:

https://learn.microsoft.com/en-us/answers/questions/75278/how-to-fetch-the-comments-of-associated-workflow-w.html?childToView=75942#answer-75942

Thanks
Baker

Answer 2

MBS 0

is it possible to post back an approval status change?

Share via

How to fetch all the data associated with the document/file on sharepoint

1 additional answer

Your answer