ES5 Address Complex is invalid

[Former Member]

I'm retrieving a BusinessPartnerContact from the ES5 system and then trying to update it.

I keep running into "Address Complex is Invalid".

The Error: 400 Bad Request {"error":{"code":"/IWCOR/CX_DS_EP_PROPERTY_ERROR/005056A509B11ED1BF822D2D09171A04","message":{"lang":"en","value":"Property 'AddressComplex' is invalid"},"innererror":{"application":{"component_id":"OPU-BSE-SDE","service_namespace":"/IWBEP/","service_id":"GWSAMPLE_BASIC","service_version":"0001"},"transactionid":"B9E0A2A100BE0050E005B8CFB3EAD730","timestamp":"20180903091801.0259130","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 (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[]}}}

I can't figure out what I should change to the update: (Note that I had to change an x into @ to prevent the word Se@ from appearing in the forum).

The update: { "DateOfBirth": null, "BusinessPartnerID": "0100000006", "AddressComplex": { "Building": "2", "PostalCode": "135-0064", "Street": "Aomi Chome-4-32", "Country": "JP", "City": "Tokyo", "AddressType": "02" }, "FirstName": "Yoko Updated", "Se@": "F", "Title": "", "MiddleName": "", "Initials": "", "EmailAddress": "yoko.nakamura@asia-ht.com", "Language": "EN", "FaxNumber": "9078563004", "PhoneNumber": "9078563412", "ContactGuid": "0050568c-901d-1ed8-abe3-a81ca57320fa", "LastName": "Nakamura", "Nickname": "" } The BusinessPartnerContacts that I retrieved before the update: { "d": { "results": [{ "__metadata": { "id": "https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/ContactSet(guid'0050568c-901d-1ed8-abe3-a81ca57320fa')", "uri": "https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/ContactSet(guid'0050568c-901d-1ed8-abe3-a81ca57320fa')", "type": "GWSAMPLE_BASIC.Contact" }, "Address": { "__metadata": { "type": "GWSAMPLE_BASIC.CT_Address" }, "City": "Tokyo", "PostalCode": "135-0064", "Street": "Aomi Chome-4-32", "Building": "2", "Country": "JP", "AddressType": "02" }, "ContactGuid": "0050568c-901d-1ed8-abe3-a81ca57320fa", "BusinessPartnerID": "0100000006", "Title": "", "FirstName": "Yoko", "MiddleName": "", "LastName": "Nakamura", "Nickname": "", "Initials": "", "Se@": "F", "PhoneNumber": "9078563412", "FaxNumber": "9078563004", "EmailAddress": "yoko.nakamura@asia-ht.com", "Language": "EN", "DateOfBirth": null, "ToBusinessPartner": { "__deferred": { "uri": "https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/ContactSet(guid'0050568c-901d-1ed8-abe3-a81ca57320fa')/ToBusinessPartner" } } }, { "__metadata": { "id": "https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/ContactSet(guid'0050568c-901d-1ed8-abe3-a81ca57340fa')", "uri": "https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/ContactSet(guid'0050568c-901d-1ed8-abe3-a81ca57340fa')", "type": "GWSAMPLE_BASIC.Contact" }, "Address": { "__metadata": { "type": "GWSAMPLE_BASIC.CT_Address" }, "City": "Tokyo", "PostalCode": "160-0004", "Street": "Yotsuya Chome-3-1", "Building": "3", "Country": "JP", "AddressType": "02" }, "ContactGuid": "0050568c-901d-1ed8-abe3-a81ca57340fa", "BusinessPartnerID": "0100000006", "Title": "", "FirstName": "Hidehisa", "MiddleName": "Masaaki", "LastName": "Koshiishi", "Nickname": "", "Initials": "", "Se@": "M", "PhoneNumber": "9078563413", "FaxNumber": "9078563004", "EmailAddress": "hidehisa.koshiishi@asia-ht.com", "Language": "EN", "DateOfBirth": null, "ToBusinessPartner": { "__deferred": { "uri": "https://sapes5.sapdevcenter.com/sap/opu/odata/iwbep/GWSAMPLE_BASIC/ContactSet(guid'0050568c-901d-1ed8-abe3-a81ca57340fa')/ToBusinessPartner" } } }] } }

[volkerdrees · Accepted solution]

Hello Jacob,

I guess the name of the complex property is "Address" and not "AddressComplex". Try to adjust your request.

Best Regards,
Volker

[Former Member]

Thanks Volker you pointed me in the right direction.

I had to do some tweeking in the Mendix datamodel that is generated automatically from the GWSAMPLE_BASIC metadata. For those Mendix engineers that run into same issue: I solved it by renaming the association "Addresscomplex_BusinessPartner_CT_Address" into "Address_BusinessPartner_CT_Address". Must be an issue with the oData / domainmodel generator.