i have a small requirement, where in i am pulling in a lot of data from List A to List B through Rest API. but i am stuck at one place where in i am not able to pull in lookup value in List B.
Hope you guys can help me out.
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
You need to use the
&$expand=[Column internalname] and the
&$Select=[Column internalname]/Id url parameter to get the Id of the lookup item, if you need the text value from the lookup use /Title instead of /Id.
I have a lookup to a list, the column name in list which contains the lookup is "Sync", so my REST call is like this:
This returns the value from the column "Titel"and the id of the lookup column "Sync".