How to perform OData V2 read with date as part of the entity primary keys

Question

I am confused on the date format to be used while invoking OData read operation where parameters are mentioned within entityset brackets. Would be great if you can paste your answer against each

1. How to use ODataModel's read() method if we have values to be passed within the entity set parameters?

   var sPath ="/EMP_DETAILSSet(Empid='50160458'/*, ...*/)";
   oBackEndModel.read(sPath, {
     success: this._fGetDetailsSuccess.bind(this),
     error: this._fBackEndInvocationError.bind(this)
   });
   

   Is this the approach to be followed? Or do we have any other approach?

2. How to set date as entity set key parameter with OData? Please correct the below code snippet (which gives me bad request error at runtime) where dBegDate and dEndDate are JS standard date objects.

   var sPath ="/EMP_DETAILSSet(Empid='50160458',Begdate="+ dBegDate.toJSON() + ",Enddate=" + dEndDate.toJSON() + ",HAFId=' ')";
   oBackEndModel.read(sPath, {
     success: this._fGetDetailsSuccess.bind(this),
     error: this._fBackEndInvocationError.bind(this)
   });
   

3. How to execute multiple expand operation along with the entityset parameters mentioned above? Please fix the error in the below code as it is not working for me.

   var sPath ="/EMP_DETAILSSet(Empid='50160458',Begdate="+ dBegDate.toJSON() + ",Enddate=" + dEndDate.toJSON() + ",HAFId=' ')";
   oBackEndModel.read(sPath, {
     urlParameters: {
       $expand: "NAVTODETAIL,NAVTOPROFILE,NAVTOREPORTEES"
     },
     success: this._fGetDetailsSuccess.bind(this),
     error: this._fBackEndInvocationError.bind(this)
   });
   

---

Further updates

I have followed the suggestion b Sunil. sPath looked as follows at runtime:

"/EMP_DETAILSSet(Empid='50160458',Begdate=datetime'2014-03-11T14:49:52',Enddate=datetime'9999-12-31T14:49:52',HAFId=' ')"

When I tried this, it gave me the following error:

2018-06-13 10:56:31.872300 The following problem occurred: HTTP request failed404,Not Found,{"error":{"code":"005056A509B11EE1B9A8FEC11C21D78E","message":{"lang":"en","value":"Resource not found for the segment '49:52',Enddate=datetime'9999-12-31T14:49:52',HAFId=''."},"innererror":{"transactionid":"5B20F78A93457852E10000000ACD4014","timestamp":"20180613052610.2725590","Error_Resolution":{"SAP_Transaction":"Run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis ..."}}}}

Do you know why?

Please note that the following URL works fine and returned the result when executed from SAP Gateway Client: /sap/opu/odata/XXX/YYYY_SRV/EMP_DETAILSSet(Empid='50160458',Begdate=datetime'2014-03-11T14:49:52',Enddate=datetime'9999-12-31T14:49:52',HAFId=' ')?$expandNAVTODETAIL,NAVTOPROFILE,NAVTOREPORTEES&$format=json

Answer 1

1. First thing is to check, what is the primitive type defined in you SAP Netweaver gateway. Most probably, it will beEdm.DateTime. You can get this info using $metdata call on service.

2. OData has standard representation of Edm.DateTime

datetime'yyyy-mm-ddThh:mm[:ss[.fffffff]]'

NOTE: Spaces are not allowed between datetime and quoted portion. datetime is case-insensitive

Example : datetime'2000-12-12T12:00'

If its JSON Format representation,

Example: "FlightDate": "/Date(1354665600000)/"

It should look something like:

var sPath = "/EMP_DETAILSSet(Empid='50160458',Begdate=datetime'2014-03-11T14:49:52',Enddate=datetime'2014-03-11T14:49:52',HAFId = ' ')";
oBackEndModel.read(sPath, {
    urlParameters: {
        $expand: "NAVTODETAIL,NAVTOPROFILE,NAVTOREPORTEES"
    },
    success: jQuery.proxy(this._fGetDetailsSuccess, this),
    error: jQuery.proxy(this._fBackEndInvocationError, this)
});