I need to get some data based on a key field from multiple lists. For this, I may need to do multiple API calls. Is there any way to avoid this ? To get all the data from multiple lists in a single API call ?
You could utilize SharePoint REST search API for that purpose, in particular to specify managed property in search query to return list items that contains value for that column.
Assume we have site column named
WorkspaceType. Since SharePoint 2013 automatically creates managed property for site columns (you could follow this great article for a details) ,then we could construct the following search query to return items that contains value
WorkspaceTypeOWSCHCS is the name of managed property.