Using the SharePoint 2013 REST API,
Can I get more than one column from the lookup column by using the
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Yes, you can expand multiple columns:
below query finally worked for me
Cat is a lookup field(which looks above Merged column) in the MainFlat list
"?$select=Title,number,Cat/Merged&$expand=Cat" + "&$filter=Cat/Merged eq '"+Merged+"' "
Consider your lookup column name as "Field1LUP" of "List1" and "Title" field of "List2" is source to lookup field.
The REST API and OData request parameters can be used to request additional information from a lookup field. As an example, An Employee list with a Department lookup field. If we need to get the employee name and id as well as the department name and id, we can use this GET request:
This gets the employee( DepartmentId, Name, and Id). We expand the Department look up field and read the department name (Department/Name). The requirement is to expand the lookup list and prefix every field with the list name.
More information can be found at:
hope it helps.