SharePoint Permission & Folder Status Automation Project
Budget: $30 – $250 USD
Project Overview
Development of a Node.js application that interacts with SharePoint via Microsoft Graph API to manage folder permissions and visual status indicators. This is an R&D-focused project requiring expertise in SharePoint and Microsoft Graph API integration.
Environment & Resources Provided
- Demo SharePoint tenant access
- All necessary certificates and secrets
- Microsoft Graph API credentials
- Git repository access
- $50 Claude AI API credit for development assistance
- Test environment with sample folder structures
Technical Requirements
Core Technologies
- Node.js
- Microsoft Graph API
- SharePoint REST API
- VSCode
- Git
Configuration
- All configuration parameters must be stored in .env file
- Must support dynamic site/library URLs via server-relative URLs
- No hardcoded IDs or paths
Detailed Tasks
Task 1: Permission Management
Develop a script that:
1. Accepts a SharePoint site/library URL as input
2. Traverses folder structure: General\Folder1\Folder2\Folder3
3. Implements permission inheritance breaking at each folder level
4. Copies existing default permissions
5. Modifies Member group permissions:
- Sets Read-Only access for Folder1 and Folder2
- Maintains Read-Write access for Folder3 only
Task 2: Folder Status Visualization
Implement logic to:
1. Analyze folder structure and content
2. Apply visual indicators based on content status:
- Yellow (SharePoint default): Folders containing files in their hierarchy
- Gray: Empty folders (no files in their hierarchy)
Example scenarios:
```
General\Folder1\Folder2\Test.txt
- Folder1: Yellow (contains file in subfolder)
- Folder2: Yellow (contains file directly)
General\Folder1\Folder3
- Folder3: Gray (empty folder)
- Folder1: Yellow (has content in other branches)
General\Folder1\Folder4
- Folder4: Gray (empty folder)
- Folder1: Yellow (has content in other branches)
```
Deliverables
1. Working Node.js application with:
- Permission management module
- Folder status visualization module
- Configuration via .env file
2. Comprehensive documentation including:
- Setup instructions
- API usage examples
- Configuration guide
3. Test cases covering various folder structures
4. Clean, well-commented code following best practices
Timeline & Scope
- Estimated completion: 4-6 hours for experienced developer
- R&D-focused project with clear scope
- Emphasis on clean, maintainable code
Required Skills
- Strong experience with Microsoft Graph API
- SharePoint development expertise
- Node.js proficiency
- Understanding of permission models in SharePoint
- Experience with OAuth authentication flows
- Familiarity with AI-assisted development
- Git version control proficiency
Selection Criteria
- Previous experience with SharePoint/Graph API projects
- Strong Node.js portfolio
- Understanding of security best practices
- Clear communication skills
- Ability to work independently on R&D tasks
Additional Notes
- This is a proof-of-concept project requiring creative problem-solving
- Clean code and documentation are essential
- Solution must be scalable and reusable
- AI assistance (Claude API) available for development
Development of a Node.js application that interacts with SharePoint via Microsoft Graph API to manage folder permissions and visual status indicators. This is an R&D-focused project requiring expertise in SharePoint and Microsoft Graph API integration.
Environment & Resources Provided
- Demo SharePoint tenant access
- All necessary certificates and secrets
- Microsoft Graph API credentials
- Git repository access
- $50 Claude AI API credit for development assistance
- Test environment with sample folder structures
Technical Requirements
Core Technologies
- Node.js
- Microsoft Graph API
- SharePoint REST API
- VSCode
- Git
Configuration
- All configuration parameters must be stored in .env file
- Must support dynamic site/library URLs via server-relative URLs
- No hardcoded IDs or paths
Detailed Tasks
Task 1: Permission Management
Develop a script that:
1. Accepts a SharePoint site/library URL as input
2. Traverses folder structure: General\Folder1\Folder2\Folder3
3. Implements permission inheritance breaking at each folder level
4. Copies existing default permissions
5. Modifies Member group permissions:
- Sets Read-Only access for Folder1 and Folder2
- Maintains Read-Write access for Folder3 only
Task 2: Folder Status Visualization
Implement logic to:
1. Analyze folder structure and content
2. Apply visual indicators based on content status:
- Yellow (SharePoint default): Folders containing files in their hierarchy
- Gray: Empty folders (no files in their hierarchy)
Example scenarios:
```
General\Folder1\Folder2\Test.txt
- Folder1: Yellow (contains file in subfolder)
- Folder2: Yellow (contains file directly)
General\Folder1\Folder3
- Folder3: Gray (empty folder)
- Folder1: Yellow (has content in other branches)
General\Folder1\Folder4
- Folder4: Gray (empty folder)
- Folder1: Yellow (has content in other branches)
```
Deliverables
1. Working Node.js application with:
- Permission management module
- Folder status visualization module
- Configuration via .env file
2. Comprehensive documentation including:
- Setup instructions
- API usage examples
- Configuration guide
3. Test cases covering various folder structures
4. Clean, well-commented code following best practices
Timeline & Scope
- Estimated completion: 4-6 hours for experienced developer
- R&D-focused project with clear scope
- Emphasis on clean, maintainable code
Required Skills
- Strong experience with Microsoft Graph API
- SharePoint development expertise
- Node.js proficiency
- Understanding of permission models in SharePoint
- Experience with OAuth authentication flows
- Familiarity with AI-assisted development
- Git version control proficiency
Selection Criteria
- Previous experience with SharePoint/Graph API projects
- Strong Node.js portfolio
- Understanding of security best practices
- Clear communication skills
- Ability to work independently on R&D tasks
Additional Notes
- This is a proof-of-concept project requiring creative problem-solving
- Clean code and documentation are essential
- Solution must be scalable and reusable
- AI assistance (Claude API) available for development