X-ray Spectroscopy of a Rare-Earth Molecular System Measured at the Single Atom Limit at Room Temperature