Search for Time Entries by Date

Through the contract-based REST API, the time spent on project tasks can be retrieved from MYOB Acumatica to an external system. For more information about tracking time on projects, see Employee Time Billing: General Information.

Testing of the Request

Before you test the code below, you need to configure your client application and the MYOB Acumatica instance to be used as follows:
  1. Deploy a new MYOB Acumatica instance with the U100 dataset. For details on deploying an instance, see To Deploy an MYOB Acumatica Instance.
  2. On the Enable/Disable Features (CS100000) form, make sure the Projects feature is enabled.
  3. To sign in to the instance in the client application, use the tenant name (which you specified when you created the instance) and the HEADOFFICE branch.
  4. If you use Postman as the client application for testing, in the IntegrationDevelopmentGuide.postman_collection.json collection (which is located in the IntegrationDevelopment\Help folder of the Help-and-Training-Examples repository on GitHub), make sure the collection variables have the proper values.

Request

You can use the following request example to obtain time entries through the contract-based REST API.

Tip: In the request example below, <MYOB Acumatica instance URL> is the URL of the MYOB Acumatica instance (such as https://my.acumatica.com/MyInstance). You can omit the instance name in the URL (that is, you can use https://my.acumatica.com) if the instance is installed in the root of the website.
GET ?$filter=cf.DateTime(f='Items.Date')%20ge%20datetimeoffset'2022-08-17'
          %20and%20cf.DateTime(f='Items.Date')%20le%20
          datetimeoffset'2022-08-18T23%3A59%3A59.999%2B04%3A00'&
          $select=Date,ProjectID,TimeSpent,BillableTime HTTP/1.1
Host: [<MYOB Acumatica instance URL>]/entity/Default/23.200.001/TimeEntry
Accept: application/json
Content-Type: application/json

Usage Notes

To filter time entries by date, you cannot use the TimeEntry.Date field of the Default/23.200.001 system endpoint. Instead of this field, you should use the custom Items.Date field, as shown in this example.