An API that connects multiple Microsoft services, enabling data access and automation across platforms
Unable to fetch Author Details
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"
}
.... }