SharePoint 2010 Rest query for Lookup fields

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 


May 18th, 2015 2:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics