NAV project data for time tracking
in production
Technology
- C#
- REST
- OAuth 2.0
- SQL
- Dynamics NAV
Outcome
New projects are ready for time bookings in the HR system right away. Filtered records and error messages go straight to the responsible team.
Context, contribution and decision
- Context
- The previous HR system was cancelled and replaced by a new one. There was no transfer of project data from Dynamics NAV into the new system.
- My contribution
- I built the connection from Dynamics NAV to the HR system, including data mapping, SQL queries, error handling and monitoring.
- Decision
- Data moves over REST with OAuth 2.0. All projects are uploaded first, then the status is checked with a delay because of the API limits.
Process in 6 steps
Project created in Dynamics NAV
Projects collected via SQL
A SQL query finds new projects.
Data checked and cleaned
Faulty data is transformed or filtered out.
Records filtered out
The responsible team is notified.
Uploaded one by one
Through the HR system REST interface with OAuth 2.0.
Status queried after a delay
Only after all uploads, because of the API limits.
Status evaluated
Every status other than waiting is logged.
Error reported
The responsible team is notified.