SAP Knowledge Base Article - Public

2202759 - OData API call fails with an error: 400-COMDF_FILTER_ON_NOT_VISIBLE_PROPERTY

Symptom

OData API call for an "UPSERT", "QUERY" operation fails with an error message:

[EXCEPTION]ODATA Execution Error Code 400-COMDF_FILTER_ON_NOTVISIBLE_PROPERTY Bad Request-cannot filter on not visible property: lastModifiedDateTime

Same can be seen in the OData response in OData API Audit log.

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

Environment

Success Factors OData API

Cause

The issue was due to insufficient permission granted to the API User.

Resolution

  1. Logon to Successfactors system.
  2. Go to admin tool->Manage role based permission.
  3. select the role which has been assigned to API user
  4. Now, click on "Permission" tab and go to Metadata Framework and enable the  "Import Permission on Metadata Framework" as highlighted below:

If the issue still exist please have a check on below points as well.

  1. Check for the particular Object under "Configure Object definition", see if the visisbility for the field "lastModifiedDateTime" has been set as editable
  2. If not, change it and perform the metadata refresh.

 2019_08_07_05_20_04_Engineer_Assistant.png

 

See Also

2355830 - How to refresh metadata of restricted Odata MDF entities?

2171588 - SuccessFactors: OData API Metadata Refresh and Export

2515741 - How to refresh Odata Metadata via an API call

Keywords

  • Bad Request-invalid property name
  • 400-COMDF_FILTER_ON_NOT_VISIBLE_PROPERTY
  • cannot filter on not visible property
, KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , How To

Product

SAP SuccessFactors HXM Core all versions

Attachments

screen.png