2760222 - "UPSERT failed for the row with key: Reason: <property> code=bad data type detail=Illegal date-value :<date>" error - Integration Center

An inbound (import) Integration Center job is failing with the error below:

"<entity>: UPSERT failed for the row with key: Reason: <property> code=bad data type detail=Illegal date-value :<date>. The row will not be processed for subsequent entities"

SAP SuccessFactors HXM Suite

1. Create an inbound IC job;
2. Run it;
3. See the error message in Execution Manager;

You are trying to import the <date> in the <property> field, but the date format is incorrect.

1. Go to OData Dictionary;
2. Search for the <entity> you are trying to import data into;
3. Search for the <property> field and check their date format (e.g. datetime);
4. Correct the input value;
5. Re-run the IC job;

OBS.: If the date format is "datetime" the correct format must be "yyyy-MM-dd'T'HH:mm:ss'Z' (e.g. 2022-12-31T00:00:00Z).

• Using the Integration Center (IC guide)
• Using the DateTimeOffset Format (OData guide)
• Using the DateTime Format (OData guide)

inbound, import, importing, input, date, format, error, issue, type, dateformat , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem