Importing Timesheets via oData or other external application

(4) Share

Report

Posted on by jvermette09

We are looking to build an application that helps automate timesheet creation for our users. The proposed idea to create the timesheet was to use the odata api. The problem is that it does not support array fields, so I cannot add the Hours or external/internal comments. Does anyone have any input/ideas on how I can achieve this?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

TSTimesheetLineEntity has all the fields you want: Hours, ExternalComments and InternalComments. It's not public, i.e. it can't be used through OData, but you could utilize a data management API.

If you insist on using OData services, you'll need to create a custom entity. I'm pretty sure we could handle array fields too. If by no other means, then with virtual fields for sure.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,508 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi JVermette09,

Next to a custom public data entity for OData, you can also check out the Timesheet web service (TSTimesheetService) available in the standard application. This is used by the Dynamics 365 timesheet app for mobile devices.

Was this reply helpful? Yes No
Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

We have done something similar where we created power apps to create timesheets. As Andre and Martin mentioned, we used combination of entity and TSTimeSheetservice which is OOB custom service to build it. However depending on your requirements, you might need Extensions in these object

Was this reply helpful? Yes No
jvermette09 83 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for the suggestions. I will explore each of the options provided.

Was this reply helpful? Yes No