Atomic-level engineering and in-situ spectroscopy studies of metal-organic frameworks in heterogeneous catalysis