I have a custom studio-created Relate field, in the Revenue Line Items module, that "points" to a User record. SugarCRM cloud represents this field as the user's full name when seen on the detail view of the record. I want to access this field externally using the REST API. When I access the RLI record using Method.GET in my REST API call, the custom field is returned as a blank string.
I understand its just a Relate field, but why would SugarCRM return this as an empty string when everywhere within SugarCRM cloud this field is represented as the User's full name?
Also, I don't see any other field from the complete field list (via REST) that contains an id or anything else for this field.
What is the easiest way to get any User record contents based on this relate field??