0

I am trying to get the data from an additional lookup column with REST API. I have two lists. The main list is "OIE Alerts" and the second list is Countries. The main list has the field "Country" which is a lookup column. It is connected with the field LandName in the Countries list. The additional field is "LandCode". How can I retrieve the additional column with $expand?

0

Use below endpoint:

/_api/web/lists/getbytitle('listtitle')/items?$select=Title,Country/LandName,Country/LandCode&$expand=LandName

LandCode column type should not be lookup/user/multi text in Countries.

  • Thanks Praveen, LandCode is a single line textfield. So I don't have to add LandCode in the $expand? – Marco Nov 4 '17 at 17:43
  • not required, you have to mention in the Select only – Praveen Pudi Nov 5 '17 at 2:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.