skip to main content
Querying with OData Version 2 : Formulating queries with OData Version 2 : Navigating relationships with OData Version 2 : Resource path navigation
  

Try Now
Resource path navigation
Resource path navigation allows a query to reference a related entity from a parent or child entity. For example, with the following table structure, a customer's orders can be referenced from a Customer record, as shown below.
Customer ---> Order ---> OrderItem
|
---> Contact

List the orders for a particular customer

https://<myserver>:<port>/api/odata/OracleDS/Customers('3')/Orders

List the order items for a particular order for customer 3

https://<myserver>:<port>/api/odata/OracleDS/Customers('3')/Orders('5')/OrderItems

Access a particular order item

https://<myserver>:<port>/api/odata/OracleDS/Customers('3')/Orders('5')/OrderItems('6')

Access a particular property

https://<myserver>:<port>/api/odata/OracleDS/Customers('3')/Name
https://<myserver>:<port>/api/odata/OracleDS/Customers('3')/Orders('5')/OrderItems('6')/ItemName