Monday, February 25, 2019

Getting Look up values using Rest API Call - SP Online

Hello All

This is a short description about how to get the look up column values using reapi calls

In my scenario, I have two list.

1. Employee
2.State

Employee has a field Names State which is a look up value from another custom list 'State'.
The normal rest api call only returns the ID , to get the details from the look up list we need to use the below format.

<yoursite url> + _api/web/lists/GetByTitle('ListName')/Items?$select=State/State,EmployeeName&$expand=State

Hope this helps.

Regards,
Saveesh.S