Using Filter Expressions in OData URIs in D365 F&O

https://URL/data/CustomerGroups?$filter=CustomerGroupId eq '10'

https://URL/data/ResourceRequitionLines?filter=SFReqId eq '777787'

https://URL/data/ResourceRequitionLines?$filter=SFReqId eq @title&@title='777787'

how to get the Inventory dimension combination ItemCategory in D365F&O

InventDimCombination    inventDimCombinationLoc;

InventDim               inventDimLoc,inventDimCombLoc;

select inventDimLoc where inventDimLoc.inventDimId == prodTable.InventDimId;

select inventDimCombinationLoc join inventDimCombLoc

where inventDimCombinationLoc.ItemId == prodTable.ItemId

&&    inventDimCombinationLoc.InventDimId == inventDimCombLoc.inventDimId

&&    inventDimCombLoc.InventColorId      == inventDimLoc.InventColorId

&&    inventDimCombLoc.InventSizeId       == inventDimLoc.InventSizeId

&&    inventDimCombLoc.InventStyleId      == inventDimLoc.InventStyleId

&&    inventDimCombLoc.configId           == inventDimLoc.configId;