✏️ Explanatory Question
For real-time inventory lookup with low data volume and ad-hoc frequency:
Custom service integration is recommended
A custom service calculates physical on-hand inventory and exposes it via SOAP or REST for real-time consumption.