How to access Parent , child , and grandchild table's data in just one OData REST API method?

cuiwenyuan

Hello everyone,

Here is my 3 Entity Types

Entity Types - SalesOrder - tdsls400

Entity Types - SalesOrderLine - tdsls401

Entity Types - Item - tcibd001

Then I create

SalesOrderLineRef for SalesOrder by using the Navigation Properties

ItemRef for SalesOrderLine by using the Navigation Properties

I wish to get the SalesOrder with SalesOrderLineRef & ItemRef when I call the SalesOrder API method, but actually I can only get SalesOrder with SalesOrderLineRef.

In the SalesOrderRef response, there is no ItemRef at all.

Is there any setting to achieve my goal? or what's the correct way to pull data from more than 2 tables(Parent table, child table, and grandchild table) in just one API method?

Thanks in advice.