OneDrive Business Node
Overview
The OneDrive Business Node is a document synchronization component that automates document syncing and processing from Microsoft OneDrive Business accounts. This node supports various file types including PDFs, Word documents, Excel files, and other compatible formats, providing secure integration with Lamatic Flow for automated document intelligence and RAG workflows.
Node Type Information
Type | Description | Status |
---|---|---|
Batch Trigger | Starts the flow on a schedule or batch event. Ideal for periodic data processing. | ✅ True |
Event Trigger | Starts the flow based on external events (e.g., webhook, user interaction). | ❌ False |
Action | Executes a task or logic as part of the flow (e.g., API call, transformation). | ❌ False |
This node is a Batch Trigger node that automates document syncing and processing from OneDrive Business accounts on a scheduled basis.
This node is a Batch Trigger node that automates document collection from OneDrive repositories and enables RAG workflows with organizational knowledge.
This integration connects to your OneDrive Business account to sync documents for processing in Lamatic Flow.
Features
Key Functionalities
- Document Syncing: Automatically syncs documents from OneDrive drives and folders with configurable scheduling.
- File Type Support: Handles PDFs, Word documents, Excel files, and other compatible formats for comprehensive document processing.
- Scheduled Processing: Supports automated sync schedules with cron expressions for regular document updates.
- Selective Filtering: Use glob patterns to filter specific file types and paths for targeted document processing.
- Multiple Sync Modes: Supports both incremental (new/modified files only) and full-refresh (all files) synchronization modes.
- Search Scope Control: Configurable search scope including accessible drives, shared items, or all files.
Benefits
- Automated Document Collection: Automates document collection from OneDrive repositories, reducing manual effort and ensuring consistency.
- RAG Workflow Enablement: Enables RAG workflows with organizational knowledge for intelligent document processing.
- Granular Control: Provides granular control over file selection and processing through glob patterns and search scopes.
- Secure Integration: Offers secure integration with Microsoft 365 accounts and OneDrive Business environments.
- Flexible Processing: Supports various parsing strategies for different document types and quality requirements.
Prerequisites
Before using OneDrive Business Node, ensure the following:
- Microsoft 365 Account: A Microsoft 365 account with OneDrive Business access.
- OneDrive Permissions: Appropriate permissions to access OneDrive files and drives.
- Tenant ID: Your organization's Tenant ID from Microsoft Entra Admin Center.
- Folder Structure Knowledge: Understanding of OneDrive folder structure and file organization.
- API Permissions: Proper OneDrive API permissions for accessing selected files and drives.
Installation
Step 1: Set Up Microsoft 365 Credentials
Please refer to the OneDrive Integration documentation to complete the setup and obtain the necessary credentials.
Ensure you have appropriate OneDrive API permissions to access the selected files and drives.
Step 3: Set Up Lamatic Flow
- Add OneDrive Node: Drag the OneDrive node to your flow
- Enter Credentials: Provide your Microsoft 365 Tenant ID
- Configure Drive Name: Enter the name of your OneDrive drive (usually "OneDrive")
- Set Folder Path: Specify the folder path within the drive (use
"."
for all folders)
Configuration Reference
Batch Trigger Configuration
Parameter | Description | Required | Default | Example |
---|---|---|---|---|
Credentials | Microsoft 365 credentials with access to OneDrive files | ✅ | - | Microsoft 365 |
Drive Name | Name of the connected OneDrive drive | ✅ | - | OneDrive |
Folder Path | Path within the drive to target. Use "." to sync all folders | ✅ | - | . |
Globs (Path Patterns) | Glob pattern for matching files | ❌ | ** | **/*.pdf , **/*.docx |
Sync Mode | Controls how files are re-indexed: full_refresh or incremental | ✅ | incremental | incremental |
Sync Schedule | Schedule for automated syncs | ❌ | - | Every 24 hours |
Search Scope | Scope of files to include: ACCESSIBLE_DRIVES , SHARED_ITEMS , or ALL | ✅ | ALL | ALL |
Parsing Strategy | Strategy for extracting content: fast , ocr_only , or hi_res | ✅ | fast | hi_res |
Days To Sync If History Is Full | Limit sync to files modified in the last N days if sync state is full | ❌ | 30 | 30 |
Start Date | Ignore files modified before this UTC datetime (ISO format) | ❌ | - | 2024-01-01T00:00:00.000000Z |
Sync Configuration Options
Sync Modes
# Incremental Sync (recommended)
sync_mode: "incremental" # Only sync new/modified files
# Full Refresh
sync_mode: "full_refresh" # Re-index all files
Schedule Examples
# Daily at midnight
sync_schedule: "0 0 * * *"
# Every 6 hours
sync_schedule: "0 */6 * * *"
# Weekdays only at 9 AM
sync_schedule: "0 9 * * 1-5"
File Filtering Patterns
Common Glob Patterns
# All PDF files
globs: "**/*.pdf"
# All Word and Excel files
globs: "**/*.docx", "**/*.xlsx"
# Files in specific folders
globs: "HR/**/*", "Legal/**/*"
# Exclude draft folders
globs: "**/*", "!**/draft/**"
Search Scope Options
ACCESSIBLE_DRIVES
: Only files in drives you have direct access toSHARED_ITEMS
: Files shared with you by othersALL
: All accessible files (recommended)
Low-Code Example
triggerNode:
nodeId: triggerNode_1
nodeType: onedriveBusinessNode
nodeName: OneDrive Business
values:
credentials: Microsoft 365
drive_name: OneDrive
folder_path: .
globs: ["**/*.pdf", "**/*.docx"]
sync_mode: incremental
sync_schedule: "0 2 * * *"
search_scope: ALL
parsing_strategy: fast
days_to_sync_if_history_full: 30
start_date: "2024-01-01T00:00:00.000000Z"
Event Trigger Output
The OneDrive Business node outputs document data in the following format:
Example Output
{
"document_key": "document_name.pdf",
"content": "Extracted text content from the document",
"metadata": {
"file_type": "pdf",
"file_size": 1024000,
"last_modified": "2024-01-01T00:00:00.000Z",
"drive_name": "OneDrive",
"folder_path": "./Documents",
"parsing_strategy": "fast"
}
}
Output Schema
document_key
: String identifier for the document (filename)content
: String containing the extracted text content from the documentmetadata
: Additional information about the documentfile_type
: Type of the processed filefile_size
: Size of the file in byteslast_modified
: Timestamp of last modificationdrive_name
: Name of the OneDrive drivefolder_path
: Path within the driveparsing_strategy
: Strategy used for content extraction
Output Schema
Batch Trigger Output
document_key
: String identifier for the document (filename)content
: String containing the extracted text contentmetadata
: Additional document informationfile_type
: String indicating file type (pdf, docx, xlsx, etc.)file_size
: Integer size in byteslast_modified
: ISO timestamp of last modificationdrive_name
: String name of the OneDrive drivefolder_path
: String path within the driveparsing_strategy
: String indicating parsing method usedsync_mode
: String indicating sync mode usedsearch_scope
: String indicating search scope used
Usage Examples
Basic OneDrive Sync
# Basic configuration for syncing all documents
credentials: "Microsoft 365"
drive_name: "OneDrive"
folder_path: "."
globs: "**/*.pdf", "**/*.docx"
sync_mode: "incremental"
search_scope: "ALL"
parsing_strategy: "fast"
Advanced Configuration
# Advanced setup with scheduling and filtering
credentials: "Microsoft 365"
drive_name: "OneDrive"
folder_path: "./Documents"
globs: "**/*.pdf", "**/*.docx", "!**/draft/**"
sync_mode: "incremental"
sync_schedule: "0 2 * * *" # Daily at 2 AM
search_scope: "ALL"
parsing_strategy: "hi_res"
days_to_sync_if_history_full: 30
start_date: "2024-01-01T00:00:00.000000Z"
Selective Document Sync
# Sync only specific document types from Work folder
credentials: "Microsoft 365"
drive_name: "OneDrive"
folder_path: "./Work"
globs: "**/*.pdf", "**/*.docx"
sync_mode: "incremental"
search_scope: "ACCESSIBLE_DRIVES"
parsing_strategy: "ocr_only" # Better for scanned documents
Troubleshooting
Common Issues
Problem | Solution |
---|---|
Authentication Failed | Verify Tenant ID is correct and you have OneDrive access permissions |
Drive Not Found | Check the Drive Name and ensure you have access to the specified OneDrive |
Files Not Syncing | Verify folder path exists and glob patterns are correctly formatted |
Permission Denied | Ensure your Microsoft 365 account has appropriate OneDrive API permissions |
Sync Not Scheduled | Check cron expression format and ensure sync schedule is properly configured |
Parsing Errors | Verify parsing strategy is appropriate for the document types being processed |
Large File Issues | Check file size limits and consider using incremental sync for large repositories |
Debugging
- Check Lamatic Flow logs for detailed error messages
- Verify Microsoft 365 credentials and Tenant ID
- Test OneDrive drive access in your browser
- Validate folder path exists and is accessible
- Test glob patterns to ensure they match your documents
- Monitor sync logs for specific file processing errors
- Verify network connectivity and API rate limits
- Test with a small folder before processing large repositories
Best Practices
- Use
incremental
sync mode for better performance - Implement specific glob patterns to avoid syncing unnecessary files
- Schedule syncs during off-peak hours to minimize impact
- Use
hi_res
parsing for scanned documents and images - Regularly monitor sync logs for any issues
- Set appropriate
days_to_sync_if_history_full
to limit historical data - Test parsing strategies with sample documents before full deployment
Example Use Cases
Document Intelligence Workflows
- Business Documents: Sync reports, contracts, and spreadsheets for automated processing
- Internal Wikis: Index knowledge bases and team documentation
- Legal Documents: Process compliance and audit-related content
- Team Collaboration: Automate access to shared folders and project files
RAG Applications
- Semantic Search: Enable natural language search across OneDrive documents
- Question Answering: Build AI assistants that can answer questions about business documents
- Document Summarization: Automatically summarize lengthy reports and documents
- Content Discovery: Help users find relevant information across OneDrive repositories