3511971 - PicklistValueV2 entity doesn't fetch all the records with paging=snapshot

The PicklistValueV2 doesn't fetch all the records with paging=snaphot where there are more than 1 Effective Start Date query as mentioned below:

https://<API URL>/odata/v2/PickListValueV2?$filter=PickListV2_id eq 'TEST'&$format=JSON&paging=snapshot

but the below query fetches all the records

https://<API URL>/odata/v2/PickListValueV2?$filter=PickListV2_id eq 'TEST'&$format=JSON

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HXM Suite

• Integration
  • ODATA API

This is an expected behaviour as the logic of Snapshot Pagination has been optimized. It can also retrieve all data for entities without a start date.

As by default the implied condition of asOfDate = <today> is added for the start date. 

Hence when you are using paging=snapshot you will have to add an addition filter of fromDate as "&fromDate=1900-01-01" to fetch multiple picklist versions.

PicklistValueV2, LOD-SF-INT, API Data missing, picklist data issue, paging=snapshot, snapshot, paging , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , Problem

SAP SuccessFactors HCM Core 2405 ; SAP SuccessFactors HCM Suite 2405