SharePoint Online Rest: Lookup Values visible in list, ID column does not reveal the Ids of the item

Question

I have an odd issue today. When looking at a list I can see the lookup field is populated with an item, this is one of a few lookup fields on the list. However when I look at the results of a rest call to the list none of the IDs of the item show up, the collection in the JSON is empty and self closing.

//Lookup field Populated in list

//lookup field showing that it has no items in REST

//Another lookup field in same list presenting correctly

I had resolved this before by deleting and re-creating the column, however the issue returned the next day.

Has anyone ran into this issue before and know how to fix it?

Edit: this was the query used to get all the list data back. https://<>.sharepoint.com/teams/AIR/_api/web/lists/getbytitle('AIR%20Incidents')/items(238)

Edit: Was suggested to use a select and expand to fix issue but did not resolve problem. I have added more info related to this below.

//result of resquested query (modified slightly to show information from list)

https://<>.sharepoint.com/teams/AIR/_api/web/lists/getbytitle('AIR%20Incidents')/items(238)?$select=basicSpecificLocation,peoplePerson/ID&$expand=peoplePerson

//Column Settings

//Internal Field Name

//List Showing Lookup Exists and has values

Any further help you can provide will be appriciated.

Answer 1

Try using below URL:

https://<>.sharepoint.com/teams/AIR/_api/web/lists/getbytitle('AIR%20Incidents')/items(238)?$select=Title,peoplePerson/ID&$expand=peoplePerson 

Answer 2

Thanks for your help.

I resolved it myself, it turned out that a lookup field wont return any Id in rest if the lookup field (i.e field/Title) is empty.