As previously explored, batching is the preferred and more efficient approach to processing a large volume of API requests. For every request, there is a call to the Microsoft Graph API and the accompanying response. With that in mind, things add up quickly as dozens, if not hundreds, of API requests are made. Batching bundles … Continue reading Graph API: SPO List Items + Batch Delete
Microsoft Graph API
Graph API: Chunky Data + Recursion
Some results are best achieved via recursion, functions being able to "call themselves from within their own code." Using the Microsoft Graph API, recursion is necessary when querying large datasets because the API responses can only return so many records at a time. Whenever there are still more records to query, the response object includes … Continue reading Graph API: Chunky Data + Recursion
Graph API: Follow SharePoint Online Sites
[SharePoint Online] has several social media-esque features baked into the solution. One such feature, choosing to "follow" specific SPO sites. But this is a manual action performed by each individual. That is, unless the Microsoft Graph API is used to follow a site on a person's behalf... Figure 1 - SharePoint Online sites being followed. … Continue reading Graph API: Follow SharePoint Online Sites
Graph API: Building and Working w/ Batches
Several of the Microsoft 365 resources are accessible through the Microsoft Graph REST API. As adoption grows, Microsoft introduces more resources and more APIs. But with this increased adoption, customers are generating more and more API requests. And when too many requests are generated too quickly, Microsoft will throttle. This results in a series of … Continue reading Graph API: Building and Working w/ Batches
Graph API: Process SPO Folders w/ Special Characters
Microsoft Graph is a RESTful web API. With these APIs, I can access many of the Microsoft 365 resources. But for now, I need to query the contents of a folder with a special character in the name. Why is this an issue? Document management systems like [SharePoint Online] will often support special characters that … Continue reading Graph API: Process SPO Folders w/ Special Characters
Power Automate: Microsoft’s “Rube Goldberg Machine”
The Microsoft 365 suite is a collection of cloud-based solutions: Outlook Online,SharePoint Online,Microsoft Teams,etc. Also included in this ensemble is Power Automate, Microsoft's workflow solution. Power Automate flows can use dozens (and dozens) of connectors to link both Microsoft and non-Microsoft solutions into automated processes: TwitterAsanaMailChimpYouTubeSalesforceetc. Essentially, an action triggers the process, then a series … Continue reading Power Automate: Microsoft’s “Rube Goldberg Machine”
SharePoint Online: File Metadata w/ Graph API
Microsoft's Graph API has endpoints for [SharePoint Online] lists and libraries. Worthy of note, document libraries are /drives when using the APIs. And although libraries are technically lists, the two resources will return different properties for the same SharePoint object. Additionally, some actions can only be performed using the /lists resources. An example of this, … Continue reading SharePoint Online: File Metadata w/ Graph API
OneDrive: Hidden List (Access Requests)
So yeah, this was an unintentional blog series. Welcome to part 4 out of #shrugs because there were more hidden lists than expected... But this time, there's a "request" to audit access requests of an individual's [OneDrive for Business] account. E.g., a PDF was shared with an external collaborator. Create the script variables. [System.String] $endUserAccount … Continue reading OneDrive: Hidden List (Access Requests)
OneDrive: Hidden List (Notifications)
[OneDrive for Business] sites are [SharePoint Online] site collections. Because of this, the ODfB sites have hidden lists which are discoverable using scripted solutions. Another of these hidden lists track user notifications. The Microsoft Graph API is again capable of querying the list and its items for reporting... E.g., list user notification types. To begin, … Continue reading OneDrive: Hidden List (Notifications)
OneDrive: Hidden List (User Activity)
[OneDrive for Business] sites are [SharePoint Online] site collections. Because of this, ODfB sites have hidden lists which are discoverable using scripted solutions. One of these hidden lists is tasked with tracking user activity. The Microsoft Graph API is again helpful to query these hidden list records for reporting... E.g., instances of user comments. To … Continue reading OneDrive: Hidden List (User Activity)
OneDrive: Hidden List (Sharing Links)
[OneDrive for Business] accounts are essentially [SharePoint Online] site collections. Because of this, ODfB sites also have several hidden lists that are discoverable with scripted solutions. One hidden list is titled Sharing Links and it keeps a record of shared items. Though the Microsoft 365 Admin center has a nice OneDrive activity report, custom solutions … Continue reading OneDrive: Hidden List (Sharing Links)
Training Session: Graph API – OneDrive vs SharePoint
Microsoft has invested heavily into their Graph API which connects with the Office 365 services. The approach of old, CSOM, not so much as of late. But that makes sense considering the services are cloud-hosted. CSOM was perfect for solutions running on the application server, but [SharePoint Online] doesn't allow this. Going forward, the Graph … Continue reading Training Session: Graph API – OneDrive vs SharePoint
Graph API: Query Teams Provisioned SPO Sites
Usage of Microsoft Teams boomed under COVID-19 shelter in place orders. For organizations with Office 365 licenses, Teams facilitated remote collaboration, but each newly created team provisions a [SharePoint Online] site collection. Post-quarantine, organizations may want to audit their Teams' provisioned SPO sites. And if end-users aren't restricted from creating teams, then there will be … Continue reading Graph API: Query Teams Provisioned SPO Sites
Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API - Part I used the Microsoft batch example as a guide, but their example created a folder in my [OneDrive for Business] account. Instead, I wanted to target a [SharePoint Online] site. And to specify which SPO site, the API requires the site ID... FYI, the Graph API site search … Continue reading Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API – Part I
Microsoft's Graph is a RESTful web API to interact with Office 365 services. Although still being developed, this currently includes CRUD operations for, but not limited to: SharePoint OnlineOneDrive for BusinessOutlookMicrosoft TeamsExcel Many of these REST requests are well documented with examples, but Microsoft examples won't address every scenario... Example: Use the Microsoft Graph Explorer … Continue reading Batching w/ Microsoft Graph API – Part I
console.log('Charles'); 