"404 - Resource not found" when query OData v2 with empty key field
I have an SAP CDS View exposed via Gateway and hosted on APIM. This CDS has CRUD operations enabled using @ObjectModel annotations.
One of the key fields from the CDS (SAP table) can be empty as per business process, but when I try to query for this full key via APIM service (with the empty property) I receive 404 - Resource not found:
The same query works fine inside SAP Gateway:
What should I do in order to APIM understand that this key field can receive empty (or null?) values?
It is interesting to see this from the APIM service and gateway query, the result is different given the same query parameter, the only explanation to me is that there is a conversion at ABAP side and this cause no result can be loaded. Can you enable gateway trace at ABAP side to check the exact request when ABAP tries to query data when you use APIM client? Use transaction /IWNFD/TRACES to see the traces for your user at ABAP side.
Regards, Derek
- Accessing Azure DevOps Board custom field using OData query
- InvalidOperationException: Can't use schemaId .. The same schemaId is already used for type
- Formatter not called despite passing the same binding path
- SAPUI5 OData V4 Read
- Odata Global PageSize
- ASP.NET WebAPI OData server side paging
- How to order the results by date?
- SAPUI5: FileUploader Not Working
- ASP.NET Core 8 Web API with OData
- ODataController erroring after return
- Paging in .NET Web API
- Odata override behaviour of orderby
- OData services with Elastic search
- How to best perform paging and sorting from multiple sources in JavaScript mashup
- OData client obsolete credentials property in version 8.x
- ASP.NET Core OData 8: allow deep navigation
- System.Text.Json.JsonException: The JSON value could not be converted to enum
- How to get only Odata.Count without value
- odata v4 - pass multiple parameters
- Azure Devops odata query returns UserEmail:Unknown
- How to remove multi-origin composition
- 415 Unsupported Media Type - POST json to OData service in lightswitch 2012
- Why odata Trippinservice returns only 8 pages?
- Comparing dates in Get Items step using ODATA QUERY
- Does OData query support nested filters with AND/OR operators?
- Azure Data Factory: Get the max-value from a table with the help of CreatedAt-column within an variable expression
- The Id cannot be computed, since the navigation source 'values' cannot be resolved to a known entity set from model
- OData query in swagger ui
- Project Online Authenticate OData Feed using Azure AD and Postman
- Binding Item data to the Detail View