I am writing a REST query to retrieve data from child parent list.
States is the parent list with "Title" column. LocalGovernment is the child list with "State_Territory(InternalName) and State / Territory(Display name)" as a lookup column.
Following is the output without any filter
I am trying to get "title" of the state from the parent list.
Query = /_vti_bin/listdata.svc/LocalGovernmentAreas?$select=State_Territory/Id&$expand=State_Territory/Id
Type 'Microsoft.SharePoint.DataService.LocalGovernmentAreasItem' does not have a property named 'State_Territory' - I am using "State_Territory" because it is the internal name.
I have also tried
/_vti_bin/listdata.svc/LocalGovernmentAreas?$select=StateTerritory/Id&$expand=StateTerritory/Id
but error is
Only properties specified in $expand can be traversed in $select query options. Property
I have also tried
/_vti_bin/listdata.svc/LocalGovernmentAreas?$select=State_Territory/Id&$expand=State_Territory
but error is
Type 'Microsoft.SharePoint.DataService.LocalGovernmentAreasItem' does not have a property named 'State_Territory'
