restapi lookup column sharepoint

0
votes

I am trying to fetch an additional lookup column. From List A I have a field which is looked up in list B, and I have added an additional column from list A. How to fetch from the additional column using the REST API?

/_api/web/lists/getbytitle('ListB')/items?$select=Title,ListA/ProjectName,ListA/OM&$expand=ListA

I am getting "invialid column OM".

1
sharepoint
Write a separate request for ListA /_api/web/lists/getbytitle('ListA')/items?$select=Title and ListB ListA /_api/web/lists/getbytitle('ListB')/items?$select=Title - Fox

1 Answers

0
votes

Rest api $expand support below lookup additional fields only.

  • Single line of text
  • Date and Time
  • Number

For example:

enter image description here

enter image description here