Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 16 at 12:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2018 at 03:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded