Interrogating the Electronic Structure and Photochemistry of Molecules with Transient X-ray Absorption Spectroscopy