When working with OData APIs in Azure API Management, it is indeed necessary to create an intermediate product to manage subscription keys. OData APIs do not appear directly in the subscription creation dropdown, which can lead to the issues you've described, such as increased administrative overhead and a more complex management process.
To create subscription keys for OData APIs, you must follow these steps:
- Create a new Product in API Management.
- Navigate to the OData API settings.
- Associate the newly created Product with the OData API.
- Create subscription keys through the Product instead of directly through the API.
This workflow is different from that of REST APIs, where subscription keys can be created directly for the APIs. The expectation for OData APIs to behave similarly is valid, and this inconsistency can lead to confusion and potential configuration errors.
It may be beneficial to provide feedback to Microsoft regarding this behavior to improve the user experience in future updates.