SAP Knowledge Base Article - Public

3318820 - 'Filtering pending data is NOT supported' message is displayed after using '&filter' and '&recordStatus=pending' in the MDF entity via SF OData API

Symptom

'Filtering pending data is NOT supported' message is displayed after using '&filter' and '&recordStatus=pending' in the MDF entity via SF OData API

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

Environment

SAP SuccessFactors HXM suite

  • Integrations 
    • MDF Odata API

Reproducing the Issue

1. Set 'Pending Data' is 'Yes' on the 'Configure Object Definitions' page.

2. Using '&recordStatus=pending' and '$filter' parameters.

Get: cust_ATMA?$format=json&$filter=datetimeoffset'2023-02-01T00:00:00' le createdDateTime&recordStatus=pending
Response:
{
    "error": {
        "code": "COE_UNSUPPORTED_FEATURE",
        "message": {
            "lang": "en-US",
            "value": "[COE0025]Unsupported feature: Filtering pending data is NOT supported."
        }
    }
}

Cause

SF Odata API does not support filtering the pending data.

Resolution

Please remove the parameter '$filter' or '&recordStatus=pending'.

e.g.

Get: cust_ATMA?$format=json&recordStatus=pending

Get: cust_ATMA?$format=json&$filter=datetimeoffset'2023-02-01T00:00:00' le createdDateTime 

See Also

The help portal of 'recordStatus' parameter

Keywords

filter, pending, recordStatus, Filtering pending data is NOT supported, SF OData API, MDF entity , KBA , LOD-SF-INT-MDF , Metadata Framework API (MDF) , Problem

Product

SAP SuccessFactors HXM Core 2211