Integrated Data

What this page covers: A complete reference mapping every Dynamics 365 Business Central field to its Mosaic equivalent. Use this guide when configuring your integration, verifying synced data, or troubleshooting discrepancies.


Integration type	Cloud (API)
Setup complexity	Low
Prerequisite	Business Central Integration Setup

How Data Flows

Business Central (API) → Mosaic Sync Engine (field mapping) → Mosaic (3 synced data types)

The integration uses the Business Central API to access Employee, Job, and Job Task data. Mosaic syncs these records on a scheduled basis.

Integrated Data Types

The integration syncs 3 data categories from Business Central into Mosaic:

#	Data Type	Description
1	Employees	Staff records with names, emails, and job titles
2	Projects	Job records including title, number, and status
3	Phases	Job Task breakdowns under projects (includes budget, start/end dates)

This list may expand as new features are added.

Reading the Field Mapping Tables

Symbol legend for technical tables

The Technical Reference tabs below use a shorthand notation for API sources. Read this legend before reviewing the mappings.

Symbol	Meaning	Example
`.`	API entity field reference	`Employee.FirstName` = the FirstName field from the Employee entity

Detailed Field Mappings

Employees

What Syncs to Mosaic	Where It Comes From in Business Central
First Name	The employee's first name
Last Name	The employee's last name
Email	The employee's company email address
Role	The employee's job title

Projects

What Syncs to Mosaic	Where It Comes From in Business Central
Project Title	The job description
Project Number	The job number
Project Status	The job status

Phases

What Syncs to Mosaic	Where It Comes From in Business Central
Phase Title	The job task description
Phase Number	The job task number
Phase Fee	The job task budget amount
Start Date	The job task start date
End Date	The job task end date

Unsupported Data Sources

Changing field names in Mosaic to match custom labelling in Business Central
Integrating Data Types that are not explicitly listed in the Business Central Integration Documentation

Please Note:

If there is a data endpoint not listed in this documentation and it is required for your integration, it will be a customization, charged at an hourly rate. For more information, see Integration Requests.

Business Central Documentation Links

A consolidated reference of all Business Central documentation referenced in this guide:

Topic	Link
API Reference (v2.0)	Business Central API
Employee Entity	Employee API
Project (Job)	Project API
Project Task	Project Task API