3082158 - SFOdata Querying with Key Predicate does not support additional query options like $top and $skip in its expand is not supported

2. If you query with below request, as expected you get all three records/userId

> Query :

https://apisalesdemo4.successfactors.com/odata/v2/User?$expand=directReports&$select=userId,directReports/userId&$format=json&$filter=userId eq '100112'

> Response :

{
    "d": {
        "results": [
            {
                "__metadata": {
                    "uri": "https://apisalesdemo4.successfactors.com:443/odata/v2/User('100112')",
                    "type": "SFOData.User"
                },
                "userId": "100112",
                "directReports": {
                    "results": [
                        {
                            "__metadata": {
                                "uri": "https://apisalesdemo4.successfactors.com:443/odata/v2/User('100115')",
                                "type": "SFOData.User"
                            },
                            "userId": "100115"
                        },
                        {
                            "__metadata": {
                                "uri": "https://apisalesdemo4.successfactors.com:443/odata/v2/User('100113')",
                                "type": "SFOData.User"
                            },
                            "userId": "100113"
                        },
                        {
                            "__metadata": {
                                "uri": "https://apisalesdemo4.successfactors.com:443/odata/v2/User('108729')",
                                "type": "SFOData.User"
                            },
                            "userId": "108729"
                        }
                    ]
                }
            }
        ]
    }
}

3.  However if you query with key predicate and request for the top 2 records of the user's directReports, the top parameter is not being considered. You still get 3 / all three records.

> Query : 

https://apisalesdemo4.successfactors.com/odata/v2/User('100112')/directReports?$top=2&$format=json&$select=userId,directReports/userId

> Response : 

SAP Successfactors HXM Suite

• SAP Successfactors Odata API

KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , Problem