3082158 – SFOdata Querying with Key Predicate does not support additional query options like $top and $skip in its expand is not supported
{
“d”: {
“results”: [
{
“__metadata”: {
“uri”: “apisalesdemo4.successfactors.com:443/odata/v2/User(‘100112’)”,
“type”: “SFOData.User”
},
“userId”: “100112”,
“directReports”: {
“results”: [
{
“__metadata”: {
“uri”: “apisalesdemo4.successfactors.com:443/odata/v2/User(‘100115’)”,
“type”: “SFOData.User”
},
“userId”: “100115”
},
{
“__metadata”: {
“uri”: “apisalesdemo4.successfactors.com:443/odata/v2/User(‘100113’)”,
“type”: “SFOData.User”
},
“userId”: “100113”
},
{
“__metadata”: {
“uri”: “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.
{
“d”: {
“results”: [
{
“__metadata”: {
“type”: “SFOData.User”
},
“userId”: “100115”,
“directReports”: {
“__deferred”: {
}
}
},
{
“__metadata”: {
“type”: “SFOData.User”
},
“userId”: “100113”,
“directReports”: {
“__deferred”: {
}
}
},
{
“__metadata”: {
“type”: “SFOData.User”
},
“userId”: “108729”,
“directReports”: {
“__deferred”: {
}
}
}
]
}
}
Read more here: Source link