cancel
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?

Thanks

Irfan

Accepted Solutions (1)

Accepted Solutions (1)

ANKIT_CHAUHAN
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,

ANKIT CHAUHAN

SAP Business One Support

Answers (1)

Answers (1)

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Irfan Malvi,

Unfortunately, the fields CreateDate & CreateTS for Business Partners & Item Master Data are not exposed in DI API yet. Therefore, you will not be able to use these fields in Service Layer too.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support