Capture API data for your data warehouse