SAP Knowledge Base Article - Public

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


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.


Success Factors OData API


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


  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.



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


  • Bad Request-invalid property name
  • 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


SAP SuccessFactors HXM Core all versions