Retrieve a single record. Any "empty" fields (e.g. "", [], or false) in the record will not be returned.
Note If we can't locate the record on a given table, the request will fallback to a base wide search and will still return the record if the Record ID is valid and the record is located within the same base.