SAP Knowledge Base Article - Public

2404144 - Unable to query a picklist using picklist Id

Symptom

Tried to query a picklist using entities 'PicklistOption, PickListValueV2' but unable to retreive the desired result as the result comes blank.

Trying to retreive values corresponding to picklist id eg:

  • event
  • ecEmailType
  • employee-status
  • employee-type
  • regular-temp

Environment

Successfactors

Cause

Incorrect query formation

Resolution

Please use a query like below and you will be able to retrieve the correct results-

https://apiX.successfactors.com:443/odata/v2/Picklist?$filter=picklistId eq 'employee-type' &$expand=picklistOptions &$format=json

Keywords

How to query a picklist using a picklist id? Unable to fetch results for picklist id 'employee-type' , KBA , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Suite all versions