Showing results for 
Search instead for 
Did you mean: 

Filter not working on CreateDate and CreateTime for Items in SAP SL through GET Data API

0 Kudos

Hi All,

I am trying to get Items filter by CreateDate and CreateTime. I want to get all Items which are created after specific time only. I am trying to get using folowing request url.

GET: https://XXX.XXX.X.X:50000/b1s/v1/Items?$filter=(CreateDate ge '2018-10-10' and (CreateTime ge '09:45:30' or CreateDate gt '2018-10-10'))

Here I am getting error.

{ "error": { "code": -1000, "message": { "lang": "en-us", "value": "Property 'CreateDate' of 'Item'is invalid" } } }

It is working fine with UpdateDate and UpdateTime. but when new Item is created then UpdateDate and UpdateTime is null.

Could you please provide us any clue regarding this?



View Entire Topic
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Irfan Malvi,

The fields CreateDate & CreateTS for Business Partners & Item Master Data are now exposed in DI API from SAP Business One Version 9.3 PL05.

Refer to SAP Note 2441154 for the same.

Kind regards,


SAP Business One Support