I'm new to using the SP API's and I am having an issue getting the required result using $expand on list lookup columns.
I have 3 lists named ProjectList, SiteList, RegionList with relating lookup's as below.
- ProjectList with 'Site' lookup
- SiteList with 'Region' lookup
Project > Site > Region
For example I want to a result which includes RegionTitle, SiteTitle and projectTitle. I'm trying this..
but an getting an error
"The query to field 'Site/Region' is not valid."
However if I try..
this works fine?
Can anyone shed some light on this? can SP only expand to a single lookup level?
Thanks in advance
See this also, a question asking the same thing but was unanswered..