Using the value from a lookup column, obtained with REST, as a dataview parameter

Question

I was wondering if you could help me with something.

I have a list called Site Configuration. One of the columns is called Package Level (Package_x0020_Level) and is a lookup that looks at the Packages list and pulls back an order number (Order0).

There is only ever one item in the Site Configuration list. I want to access this item, get the number in Package Level, and use it as a parameter in dataviews throughout the site.

The site is rolled out to different clients, so I want to show/hide different list items throughout the site based on the package level.

I'm not sure of the best way to do this. I tried REST:

http://<domain>/_vti_bin/ListData.svc/SiteConfiguration(1)/?$select=Package_x0020_Level  

or

http://<domain>/_vti_bin/ListData.svc/SiteConfiguration(1)/?$expand=Package_x0020_Level&$select=Package_x0020_Level/Order0

or lots of other variations. But that's giving me 'HTTP 400 Bad Request'...

And I tried a CAML query with lists.asmx - I can get the value back with this but it returns data from the Site Config list, and the lookup list, so not sure how to take the first digit and use it as a parameter for my dataviews.

I've hope I've made all this clear. Thanks in advance for any help.

Answer 1

Please try using "PackageLevel" in the REST Query instead of "Package Level" which is the display name of the field. What I have observed is that neither display name of the field nor its internal name work. It is actually the display name minus spaces which works. I have written a blog post about it here: http://sharepointnadeem.blogspot.in/2012/01/sharepoint-2010-rest-api.html and here: http://sharepointnadeem.blogspot.in/2012/06/field-names-in-rest-query-are-case.html