SAP Knowledge Base Article - Public

3669556 - No Data Returned When Filtering On Installation ID In OData API Call For ServiceRequestServiceReferenceObjectCollection.

Symptom

When a user performs an OData API call to retrieve data from the ServiceRequestServiceReferenceObjectCollection entity using only the Installation ID as a filter, no data is returned in the response.

Environment

SAP Cloud for Customer core applications

Reproducing the Issue

  1. Go to Administrator Work Center.
  2. Click on OData Service Explorer view.
  3. Select the service named c4codataapi and click on Test.
  4. The OData Console opens.
  5. Select the entity ServiceRequestServiceReferenceObjectCollection.
  6. Modify the OData API call to filter by Installation ID, as shown below:

    https://my******.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestServiceReferenceObjectCollection?$filter=InstallationPointID eq '12345'

    Note: ****** represents the tenant ID and 12345 is the Installation Point ID.

  7. Execute the GET call.
  8. No data is returned in the response.

Cause

Service Requests and Installation Points are maintained as separate business objects in SAP Cloud for Customer. When a Service Request is linked to an Installation Point—either by manually associating it or creating a ticket from an Installation Point—a reference node is created to link the two entities.

The ServiceRequestServiceReferenceObjectCollection entity is designed to return reference object relationships, not standalone Installation Points. Therefore, filtering only by InstallationPointID without using the associated Reference Node ID will not return any results. This is because the relationship between the Service Request and Installation Point is stored in the reference node, not directly in the Installation Point field.

Resolution

To retrieve data from the ServiceRequestServiceReferenceObjectCollection entity, include the Reference Node ID in your OData API call. This ensures the API fetches the correct association between the Service Request and the Installation Point.

If you only use the Installation Point ID without referencing the associated node, the system cannot identify the correct relationship and thus returns no data.

Keywords

ServiceRequestServiceReferenceObjectCollection, OData API Call, Filter using Installation ID, No Response for OData API Call, OData filtering issue , KBA , LOD-CRM-SRP-API , Ticket API & Odata , Problem

Product

SAP Cloud for Customer core applications all versions