In this talk, we will delve into the nuances of extracting data from APIs, illustrate the common challenges faced during the data extraction process, solving the challenges with the schema-on-read approach. We will also see how theory translates into practice using the Ascend.io data pipeline automation platform.