Integrated Data
Microsoft Project Online
What this page covers: A complete reference mapping every Microsoft Project Online data type to its Mosaic equivalent. Use this guide when configuring your integration, verifying synced data, or troubleshooting discrepancies.
| Integration type | Cloud (Project Online REST API) |
| Setup complexity | Low |
| Prerequisite | Project Online Integration Setup |
How Data Flows
Project Online (REST API) → Mosaic Sync Engine (field mapping) → Mosaic (4 synced data types)
Integrated Data Types
The integration syncs 4 data categories from Project Online into Mosaic:
| # | Data Type | Description |
|---|---|---|
| 1 | Employees | Resources mapped to Mosaic employees |
| 2 | Projects | Projects mapped to Mosaic projects |
| 3 | Phases | Summary Tasks mapped to Mosaic phases |
| 4 | Time Entries | TimesheetLine entries mapped to Mosaic time entries |
This list may change as Mosaic works on adding more data points to the integration.
Detailed Field Mappings
Jump to a section: Employees | Projects | Phases | Time Entries
Employees
| What Syncs to Mosaic | Where It Comes From in Project Online |
|---|---|
| Employee Name | Resource Name |
| Employee Email | Resource Email |
Projects
| What Syncs to Mosaic | Where It Comes From in Project Online |
|---|---|
| Project Title | Project Title |
| Project Fee | Project Fee |
| Project Number | Project Number |
Phases
| What Syncs to Mosaic | Where It Comes From in Project Online |
|---|---|
| Phase Title | Summary Task Title |
| Project Number | Summary Task Project Number |
| Phase Number | Summary Task Phase Number |
| Phase Fee | Summary Task Fee |
| Start Date | Summary Task Start Date |
| End Date | Summary Task Finish Date |
Time Entries
| What Syncs to Mosaic | Where It Comes From in Project Online |
|---|---|
| Date | TimesheetLine Date |
| Hours | TimesheetLine Hours |
| Project | TimesheetLine Project |
| Phase | TimesheetLine Phase |
| Description | TimesheetLine Description |
| Employee | TimesheetLine Employee |
Microsoft Project Online Documentation Links
A consolidated reference of all Microsoft Project Online documentation referenced in this guide:
| Topic | Link |
|---|---|
| Project Server Developer Docs | Project Development |
| Project OData Reference | ProjectData - OData |
Related Documentation
Unsupported Data Sources: Integrating data types that are not explicitly listed in this documentation is not supported. If there is a data endpoint not listed here and it is required for your integration, it will be a customization, charged at an hourly rate.
Updated about 1 month ago