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?

Improve this question

1 Answer 1

Reset to default
1

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.

Improve this answer
2
  • Thanks Praveen, LandCode is a single line textfield. So I don't have to add LandCode in the $expand?
    – Marco
    Nov 4, 2017 at 17:43
  • not required, you have to mention in the Select only
    – Praveen Pudi
    Nov 5, 2017 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.