Dynamics Community Forum Thread Details

Odata service to access timesheets lines/detail

I started a Microsoft Business Central trial period to test various Odata services (for example read and write "Sales order" "Jobs" and "Timesheet" objects) in preparation for a new installation. I need to understand if an integration is possible with our existing software.

Some services are working ok: reading the list of the Jobs returns the expected result, but the Timesheet object is returning an empty list.

I performed the setup as per the documentation: defined timesheet administrator, resources, Jobs.

Via browser application I can also create timesheet entries and approve them, but the service (object ID 951/952) keep giving back an empty response.

I've defined the odata services through the "Web services" page setup:

created two services of type "Page", object ID 951 and 952, set the Published flag.

Posting a GET HTTP request in Postman with the URL:

api.businesscentral.dynamics.com/.../Timesheet952

gives the following response

{
    "@odata.context": "">api.businesscentral.dynamics.com/.../$metadata,
    "value": []
}

I'd like to understand if

whether the timesheet integration is feasible or not
if the trial account has any limitations (I have found no informations in this sense)
what can I do to understand what's going wrong (any log or checks i can investigate)

Thanks for any help

Quick Links