Unable to fetch Author Details

Question

Unable to fetch Author Details

Harsha Jha 61

Hello,

I am using the Microsoft Graph API to retrieve a SharePoint list item along with all its fields (properties) using the following request:

https://graph.microsoft.com/v1.0/sites/{siteID}/lists/{listID}/items('{itemID}')?expand=fields

This request returns the list item successfully; however, for fields such as Author, Editor, and Person fields, the response only includes the lookupId rather than the user details.

I recall that an additional GET request is required to retrieve the full user information, but I cannot remember the exact API call needed to do this.

Could someone please help me with the correct API request to fetch the Author, Editor, and Person field details? body: { ....

JSON

"fields": {
            "@odata.etag": "\"XXX,XXX\"",
            "PersonLookupId": "15",  // User Details
            "Certification": [
                {
                    "LookupId": XXX,
                    "LookupValue": "XX"
                }
            ],
            "Expires": "XXX",
            "Issued": "XXX",
            "Status": "XX",
            "id": "XXX",
            "ContentType": "Item",
            "Modified": "XXX",
            "Created": "XXX",
            "AuthorLookupId": "15", // User Details
            "EditorLookupId": "577", // User Details
            "_UIVersionString": "1.0",
            "Attachments": false,
            "Edit": "",
            "ItemChildCount": "0",
            "FolderChildCount": "0",
            "_ComplianceFlags": "",
            "_ComplianceTag": "",
            "_ComplianceTagWrittenTime": "",
            "_ComplianceTagUserId": "",
            "AppEditorLookupId": "9"
        }

.... }

1 answer

Your answer

Answer 1

Author, Editor, and person-type fields on SharePoint list items are exposed as lookup IDs in the fields facet. To get the actual user details, call Microsoft Graph on the corresponding user object using that ID.

Get the list item (already done):

GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items/{item-id}?expand=fields

This returns values like:

"AuthorLookupId": "15",
"EditorLookupId": "577",
"PersonLookupId": "15"

Use the lookup ID to get the user from Microsoft Graph:

GET https://graph.microsoft.com/v1.0/users/{user-id}

For example, for AuthorLookupId:

GET https://graph.microsoft.com/v1.0/users/15

This returns the user resource, including properties such as displayName, mail, and userPrincipalName.

Repeat for EditorLookupId, PersonLookupId, and any other person fields. If needed, use $select to limit returned properties, for example:

GET https://graph.microsoft.com/v1.0/users/15?$select=id,displayName,mail

References:

Share via

Unable to fetch Author Details

1 answer

Your answer