Symptom
What value should I use when I upsert data in picklist field via OData API? and what for Import Employee Data
Environment
SAP SuccessFactors HCM Suite
Resolution
We will be using ecPhoneType (ecPhoneType) picklist as an example.
- If you are importing via UI, see below:
Field Name: | Values to be used | Example: |
isPrimary | Yes, No | Yes |
phone-Type | What is the label shown in Picklist Center | Home |
See sample import file below:
2. If you are upserting via OData API
Field Name: | Values to be used: | Example: |
isPrimary | true,false | true |
phoneType | Option ID | 10604 |
Sample request payload:
{
"__metadata": {
"uri": "https://apisalesdemo4./odata/v2/PerPhone(phoneType='10606',personIdExternal='XXXXXX')",
"type": "SFOData.PerPhone"
},
"areaCode": "123",
"isPrimary": true,
}
See Also
2850236 - PerPhone Odata Upsert error: Only one record can be set as primary record
2799250 - Odata API Upsert Picklists with same label behavior
Keywords
upsert picklist, import picklist, optionID , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , How To