Microsoft Office
Askel connects to your customer's Microsoft 365 tenant and lets your product read and write Excel workbooks, Word documents, and OneDrive files using the Microsoft Graph API, without requiring the customer to export or import anything manually.
What you can do
Read and write Excel worksheets
Use the Graph workbook API to read cell ranges, update values in a named range or by address, and add rows to a table without overwriting adjacent data.
Create Word documents from templates
Upload a pre-filled DOCX to OneDrive using the Drive API, giving the customer a ready-to-review Word document in their file storage.
List and navigate OneDrive folders
Enumerate drives, folders, and files in the customer's personal OneDrive or SharePoint document library, and resolve paths to file IDs for subsequent operations.
Upload and download files
Put files into specific OneDrive folders using simple upload or resumable upload for large files, and download files back into your product for processing.
Set sharing links and permissions
Create sharing links scoped to organisation-wide view access, or add specific users as collaborators on a file or folder.
Audit every Graph API call
Askel logs each request with the resource path, HTTP method, and response summary so your team can trace any file operation.
Writing weekly summary data into a customer's Excel tracker
You sell a field-service management tool. Meridian DevTools maintains a weekly operations tracker in Excel on their SharePoint site. Every Monday, they want your product to append the prior week's job counts, completion rates, and billable hours into the tracker automatically.
- 1
Connect once
Meridian's Microsoft 365 admin completes OAuth in your product, approving the Files.ReadWrite and Sites.ReadWrite.All scopes. Askel stores the refresh token.
- 2
Locate the workbook
Askel navigates the SharePoint document library to find the Operations Tracker workbook and stores its Drive item ID for subsequent calls.
- 3
Read the current last row
Askel queries the workbook's used range to determine the last populated row so the next week's data is appended in the correct position.
- 4
Write the week's summary
Your product computes the weekly metrics and passes them to Askel, which writes the values into the next empty row using the worksheet range PATCH endpoint.
- 5
Confirm and log
Askel confirms the write succeeded and records the updated cell range in your product's audit log. Meridian's team sees the new data in their Excel file the next time they open it.
OAuth 2.0
The customer's Microsoft 365 admin or a delegated user completes the Azure AD OAuth consent flow, approving the Files.ReadWrite scope for OneDrive access and Sites.ReadWrite.All if SharePoint document libraries are involved. Askel stores the refresh token and handles silent renewal. If admin consent is required by the tenant's Azure AD policy, Askel provides a tenant-admin consent URL.
How Askel sits between your product and the customer's system
FAQ for Microsoft Office
Does this work with SharePoint document libraries as well as personal OneDrive?+
Can we edit Excel files that are currently open in a browser?+
What scopes does Askel request?+
What happens if the customer moves or renames the target file?+
catching drift before it breaks, and hitting go-live dates.
© 2025 Askel.ai. All rights reserved.