The series has finally reached a conclusion. The final list, SharePointHomeCacheList, had so many items that it was divided into two posts. Part I spotlighted 3 list items and Part II will cover two additional items…

E.g., export of list object in PowerShell ISE.

• Get target items

$api = "/sites/$($siteGuid)/lists/$($listGuid)/items"
$api += "?expand=fields"

$lst1 = "SPHomeWeb:sites/feed"
$lst2 = "SPHomeWeb:activities"

##  Get List Items
foreach($objItem in ((Get-GraphAPIResponse -GraphAPIRequest "$api"))) {
    foreach($item in ($objItem.value | ? { $_.fields.LinkTitle -like "*$($lst1)*" -or $_.fields.LinkTitle -like "*$($lst2)*" })) {
        $item.fields
    }
}

SPHomeWeb:sites/feed:

Starting things off, SPHomeWeb:sites/feed. Mirroring the JSON structure of the earlier entries, the Value property is an array. And each array entry has an object type:

• Site
  • Communication sites.
  • WebTemplate: “STS”
• Group
  • Modern Team sites.
  • WebTemplate: “Group”

E.g., export of list object.

SPHomeWeb:activities:

SPHomeWeb:activities follows the same JSON structure. But this Value array is a list of [SharePoint Online] activity objects. Each object has an action Type:

• YouViewedActivity
• TrendingAroundActivity
• YouModifiedActivity
• etc.

E.g., export of list object

Fin…

Conclusion:
Once the veil is lifted, there is a lot of information available in OneDrive for Business accounts. Sometimes the content needs to be broken into smaller, digestible bites, but its possible to audit this content using the available Read access to these hidden lists…

\”But race is the child of racism, not the father. And the process of naming “the people” has never been a matter of genealogy and physiognomy so much as one of hierarchy.\”

Ta-Nehisi Coates

#blacklivesmatter