Get Author Email from SharePoint Rest API request

If you want to get the Author login from the SharePoint object, for example, list item, you should use ‘expand=Author’ in the query. It’s necessary, but not sufficient. There’s one more option, which you must use.

A query, which returns the author Email, looks like this:

https://markimarta.sharepoint.com/sites/mysite/_api/web/lists/getByTitle(‘Answers’)/items?$select=ID,Title,UserSlots,Author/EMail&$expand=Author&$filter=+EventId+eq+34

‘M’ in the word ‘EMail’ must be capital.

If you think, that the register is not important, it’s a big mistake.
if you write in the query “$select=ID,Title,UserSlots,Author/Email&$expand=Author&…”, then you have an error like this:

<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<m:code>-1, Microsoft.SharePoint.SPException</m:code>
<m:message xml:lang="en-US">The query to field 'Author/Email' is not valid.</m:message>
</m:error>

Microsoft is not like Tefal, he doesn’t always think of you 🙂