changing file properties using HTTTP sharepoint Request

(0) Share

Report

Posted on by artivo36

Hello all,

i was following this post:

http://johnliu.net/blog/2019/2/flowninja-hack-78-modifying-modified-by-and-modified-time-with-microsoft-flow

which seem to be working fine.

However, when the file is located in a subfolder i cannot find out the correct syntax.

The offical MS page doesn't help much:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest

e.g. Uri: "_api/web/lists/getbytitle ('/subfolder/subfolder/subfolder')/items(1)/validateUpdateListItem" always throws the error that the folder does not exist.
Can someone give me a hint how the REST:Api Call should look like when the file is located in a subfolder ?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!
Hi @artivo

You cannot use getByTitle and then pass in the folder hierarchy. Please follow the below steps and it was tested from my end and its working.

Use the below API method to find the file and its item id.

_api/web/GetFolderByServerRelativeUrl('Sample Documents/Folder 1/Folder 11/Folder 111/')/Files('Most Viewed Policies.csv')/ListItemAllFields

Again use the HTTP action with the following query to update the item

_api/web/lists/getbytitle('Sample Documents')/items(@{outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['Id']})/validateUpdateListItem

You have to pass the item id from the first HTTP action and then follow the same as described in the link. It should work. Please try it out and let me know.

Was this reply helpful? Yes No
artivo36 78 on at

Like (0)

Report
Copy link

Link copied!

Hello @sudharsan1985 ,

i tried around with your hints but running through various error messages. Latest states that the JSON is malformatted.
To avoid some pingpong posting - would you be available for a remote session ?

Was this reply helpful? Yes No