Acumatica REST API Filter on last modified date

Question

I'm looking to create an integration and need to be able to extract data based on last modified date. I have followed the example provided (Acumatica StockItem example) but the Get always returns all stockitems.

I have modified one stockitem and since the filter in the example is for modified dates greater than a month ago this stockitem should be only one being returned.

Looking at the Content returned the issue would appear to be a "unrecognized" date format, but I have followed the example.

It would appear I'm missing something here but can't figure out what, any advise?

Screen Capture of returned Content

JSON view of StockItem data being returned, modified item CONTABLE1 shows LastModified date of 2021-01-05

Answer 1

You are passing the value in the wrong format. You need to replace all the special codes like %3A and %2B with corresponding characters.

%3A is :
%2B is -

The below request is working without any issues.

http://localhost/ACU20193/entity/Default/20.200.001/StockItem?$top=5&$filter=LastModified gt datetimeoffset'2021-01-02T00:58:57.837-08:00'