How to pull data for internal reporting using API?