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?

1 Answer 1


Use below endpoint:


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, 2017 at 17:43
  • not required, you have to mention in the Select only Nov 5, 2017 at 2:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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