Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OData create request body malformed

Hello everyone,

i am currently developing an SAPUI5 application which is accessing an OData service exposed by Java Olingo framework. The odata service is fine and i am also able to retrieve entities from the the service. However, i am still struggling to insert something.

I have one entity Customer with two nagivation properties to Title and Country. In the SAPUI5 i create the payload as follows:

var payload = {

  ID: nID,

  CDate: new Date(),

  UDate: new Date(),

  CustomerNumber: customer.CustomerNumber,

  Prename: customer.Prename,

  Surname: customer.Surname,

  Birth: customer.Birth,

  PhoneNumber: customer.PhoneNumber,

  FaxNumber: customer.FaxNumber,

  Street: customer.Street,

  StreetNumber: customer.StreetNumber,

  AdditionalText: customer.AdditionalText,

  ZipCode: customer.ZipCode,

  City: customer.City

  };

  payload.Title = {

  __metadata: {

  uri: this.getView().byId("selectTitle").getSelectedItem().getBindingContext().getPath()

  }

  };

  payload.Country = {

  __metadata: {

  uri: this.getView().byId("selectCountry").getSelectedItem().getBindingContext().getPath()

  }

  };

  console.log(JSON.stringify(payload));

  var oData = this.getODataModel();

  oData.create("/Customer", payload, null,

  jQuery.proxy(this.onCreateSuccessPopUp, this),

  jQuery.proxy(this.onCreateFailPopUp, this));

The resulting payload in Json looks as follows:

{

"ID":0,

"CDate":"2015-10-15T15:45:19.176Z",

"UDate":"2015-10-15T15:45:19.176Z",

"CustomerNumber":"54433422",

"Prename":"Test",

"Surname":"Test",

"Birth":"2015-10-14T22:00:00.000Z",

"PhoneNumber":"123456789",

"Street":"Test",

"StreetNumber":"14",

"ZipCode":"50126",

"City":"Bergheim",

"Title":{"__metadata":{"uri":"/Title(1L)"}},

"Country":{"__metadata":{"uri":"/Country(1L)"}

}}

The error from the odata looks as follows:

HTTP request failed400,Bad Request,{"error":{"code":null,"message":{"lang":"en","value":"The request body is malformed."}}}

Somebody know how to fix it? For the OData object i tried both version (v2.ODataModel and ODataModel).

Hope somebody can help me.

Thanks

Best regards,

Manjinder Singh

Tags:
Former Member
Former Member replied

Hello everyone,

i solved the problem. I used __deferred instead of __metadata. Furthermore, i have to cut the first character (/) from the path.

  1. payload.Title = { 
  2.   __deferred: { 
  3.   uri: this.getView().byId("selectTitle").getSelectedItem().getBindingContext().getPath().substring(1)
  4.   } 
  5.   }; 
  6.   payload.Country = { 
  7.   __deferred: { 
  8.   uri: this.getView().byId("selectCountry").getSelectedItem().getBindingContext().getPath() .substring(1)
  9.   } 

Best regards,

Manjinder Singh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question