Retrieve the List of Modified Stock Items

If you are using the contract-based REST API to integrate MYOB Acumatica with an external system, this external system can retrieve the list of stock items that have been modified within a particular period.

Testing of the Request

Before you test the code below, you need to do the following to configure your client application and the MYOB Acumatica instance to be used:

  1. Deploy a new MYOB Acumatica instance with the T100 dataset. For details on deploying an instance, see To Deploy an MYOB Acumatica Instance in the Installation Guide.
  2. On the Stock Items (IN202500) form, open the AALEGO500 inventory item, edit the value in the Description box (for example, change it to LEGO, 500 piece set), and save your changes.
  3. 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.
  4. To sign in to the instance in the client application, use the tenant name (which you specified when you created the instance) and the YOGIFON branch.

Request

You can use the following request example to retrieve the stock item that was changed today through the contract-based REST API. (You should specify today's date instead of 2019-11-14.) The only stock item that the response will contain will be AALEGO500, which you have just changed.

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 [<MYOB Acumatica instance URL>]/entity/Default/23.200.001/StockItem?
    $expand=WarehouseDetails&
    $select=InventoryID,Description,WarehouseDetails/WarehouseID,
        WarehouseDetails/QtyOnHand,ItemClass,BaseUOM&
    $filter=LastModified gt datetimeoffset'2019-11-14T00:00:00.000' HTTP/1.1
Host: localhost
Accept: application/json
Content-Type: application/json