SAP Knowledge Base Article - Public

2855996 - What value to use when upserting via OData API or Import Employee data of a picklist field?

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.

picklistKBA.PNG

  1. 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:

sampleimportfileKBA.PNG

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

Product

SAP SuccessFactors HCM Suite 1511 ; SAP SuccessFactors HCM Suite 1602 ; SAP SuccessFactors HCM Suite 1605 ; SAP SuccessFactors HCM Suite 1608 ; SAP SuccessFactors HCM Suite 1611 ; SAP SuccessFactors HCM Suite 1702 ; SAP SuccessFactors HCM Suite 1705 ; SAP SuccessFactors HCM Suite 1708 ; SAP SuccessFactors HCM Suite 1711 ; SAP SuccessFactors HCM Suite 1802 ; SAP SuccessFactors HCM Suite 1805 ; SAP SuccessFactors HCM Suite 1808 ; SAP SuccessFactors HCM Suite 1811 ; SAP SuccessFactors HCM Suite 1902 ; SAP SuccessFactors HCM Suite 1905 ; SAP SuccessFactors HCM Suite 1908 ; SAP SuccessFactors HXM Suite 1911 ; SuccessFactors HCM Suite 1204 ; SuccessFactors HCM Suite 1207 ; SuccessFactors HCM Suite 1210 ; SuccessFactors HCM Suite 1302 ; SuccessFactors HCM Suite 1305 ; SuccessFactors HCM Suite 1308 ; SuccessFactors HCM Suite 1311 ; SuccessFactors HCM Suite 1402 ; SuccessFactors HCM Suite 1405 ; SuccessFactors HCM Suite 1408 ; SuccessFactors HCM Suite 1411 ; SuccessFactors HCM Suite 1502 ; SuccessFactors HCM Suite 1505 ; SuccessFactors HCM Suite 1508