I have a list with lookup columns. When I get an item from the list and expand the lookup columns, I get an error if any of the lookup column values are empty.
For example if I have a list with the look up column: files, and I want to get the column: preview_link, I have a URL as follows:
/_api/web/lists/getbytitle('My List Title')/Items('39')$select=*,files/Title,files/preview_link&$expand=files
That works fine, except if one of the items in files has an empty value for preview_link. In that case I get an error:
Cannot get value for projected field files_x005f_preview_link.
Is there any way around this short of having to put some dummy value for look up items that don't have a value for preview_link? Is this what Microsoft expects developers to do? Maybe I'm missing something simple, though.