SharePoint get “Modified By” field from Library using REST API

Question

I want to retrieve the OOTB Modified By value using REST API. I tried the below options in my REST Query:

Editor/Title&$expand=Modified By
Editor/Title&$expand=Editor

I am getting the error : The expression "Modified By" is not valid.

Please suggest how to achieve this?

To check the "Modified By" field name , I have queried all fields using below request:

https://servername/_api/web/lists/getbytitle('MyLibrary')/Fields?$select=Title,InternalName

Here's the response for "Modified By":

<d:InternalName>Editor</d:InternalName><d:Title>Modified By</d:Title>

Please help me here!

Thanks!

Hi, do you want to get the value of modified by field for the item? — Shantha Kumar Thambidurai, May 4 '17 at 16:06

Gautam Sheth · Accepted Answer · 2017-05-04 14:25:10Z

6

You need to use expand with the this Editor field.

In the $expand, you should specify the person field you want to expand.

$select=Editor/Title&$expand=Editor

Try below query:

https://servername/_api/web/lists/getbytitle('MyLibrary')/fields?$select=Title,InternalName,Editor/Title&$expand=Editor

answered May 4 '17 at 14:25

Gautam Sheth

28.2k1 gold badge27 silver badges54 bronze badges

I tried the below query: https://servername/_api/web/lists/getbytitle('Pages')/items?$Select=Created,ID,Title,Modified,Status,CurrentAuthor/Title&$expand=CurrentAuthor,Editor/Title&$expand=Editor I have two people columns - one is CurrentAuthor and other is Editor(ModifiedBy). This query works for CurrentAuthor but does not work for Editor. It throws error "The query to field 'Editor' is not valid. The $select query string must specify the target fields and the $expand query string must contains Editor." – user2598808 May 5 '17 at 6:09
1

You cant use multiple $expand. The query should be as below: https://servername/_api/web/lists/getbytitle('Pages')/items?‌$Select=Created,ID,T‌itle,Modified,Editor/Title,Status‌,CurrentAuthor/Title‌&$expand=CurrentAuth‌or,Editor – Gautam Sheth May 5 '17 at 6:54

add a comment |

Venkat Konjeti · Accepted Answer · 2017-05-04 15:25:32Z

6

You can use below syntax

$select=Editor/Title&$expand=Editor/Id

You query will turn into

https://servername/_api/web/lists/getbytitle('MyLibrary')/Items?$select=Title,InternalName,Editor/Title&$expand=Editor/Id

answered May 4 '17 at 14:04

Venkat Konjeti

4,7911 gold badge5 silver badges17 bronze badges

Thank You for the response, now am getting this error "The query to field 'Editor' is not valid. The $select query string must specify the target fields and the $expand query string must contains Editor." – user2598808 May 4 '17 at 14:13
The end point for getbytitle("mylibrary")/Fields don`t provide ModifiedBy information. – Venkat Konjeti May 4 '17 at 15:37
Is this not achievable? To fetch OOTB ModifiedBy field using REST API? Please guide me if I am missing something here. ThanQ! – user2598808 May 5 '17 at 6:11
Are you looking for field modified by or item modified by column? In the question you are referring "<d:InternalName>Editor</d:InternalName><d:Title>Modified By</d:Title>" is a peroperty of a list item not a field property. Check this query for field property siteurl/_api/web/Lists/getByTitle('listtitle')/Fields?$filter=InternalName eq 'Title' – Venkat Konjeti May 5 '17 at 15:13

add a comment |

2 Answers 2