SAP Knowledge Base Article - Public

2855996 - What value to use when upserting a picklist field via OData API?

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:

picklistKBA.PNG

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