SAP Knowledge Base Article - Public

2251624 - How to Update/Upsert/Insert a blank value for a required field using Odata from Boomi

Symptom

Unable to Update/Upsert/Insert a blank or empty value for a required field using any of the Odata APi entities from Boomi middleware.

When passing a blank value for a required field for one of the Odata entities in the Successfactors Boomi connector, the field does not get included in the Update/Upsert/Insert.

Environment

Boomi

Cause

  1. "Respect Min Occurs?" need to be checked in the request profile
  2. In the XML profile, the “Min Occurs” dropdown in the “Types” tab needs to be changed to 1

Resolution

  1. Open up the XML profile in Boomi.
  2. Click on the "Options Tab".
  3. Check "Respect Min Occurs?" in the request profile.

    RespectMinOccurs_checked.PNG

  4. Next go to "Types Tab"
  5. Click on the field which you want to use.
  6. Change min occurs of that field to "1":

    MinOccurs.PNG

  7. This means, that if the field value is not specified, it'll simply pass a <id /> value, which means blank.

Keywords

Boomi, OData API, Blank, Value, Empty , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-BOM , Standard SF to 3rd Party Boomi Content , How To

Product

SAP SuccessFactors HXM Core all versions