You're working on a pipeline that needs to pull data from external and internal services before loading it into analytics tables. The main design questions are around how you extract data from APIs, handle operational issues, and keep the pipeline reliable over time.
What is your experience with using APIs for data integration?