skip to main content
Formulating queries : Navigating relationships : Resource Path Navigation
 

Try DataDirect Cloud 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://service.datadirectcloud.com/api/odata/OracleDS/Customers('3')/Orders

List the order items for a particular order for customer 3

https://service.datadirectcloud.com/api/odata/OracleDS/Customers('3')/Orders('5')/OrderItems

Access a particular order item

https://service.datadirectcloud.com/api/odata/OracleDS/Customers('3')/Orders('5')/OrderItems('6')

Access a particular property

https://service.datadirectcloud.com/api/odata/OracleDS/Customers('3')/Name
https://service.datadirectcloud.com/api/odata/OracleDS/Customers('3')/Orders('5')/OrderItems('6')/ItemName