Symptom
What value should I use when upserting data in a picklist field when using OData API?
Environment
SAP SuccessFactors HCM Suite
Resolution
You need to use the Option ID of the picklist value you want to upsert. For example:
In ecPhoneType (ecPhoneType) picklist we have "Home" value, with Option ID = 10604:

So you need to use the value 10604 when you want to refer to this "Home" value in an Upsert.
Sample request payload:
{
"__metadata": {
"uri": "https://apisalesdemo4./odata/v2/PerPhone(phoneType='10604',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 , 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