Advanced API and data processing

Hello,

I am struggling with returning data from APIs and storing that data into my database. Specifically how to deal with the processing order so duplicates aren’t created, seeing what API calls are being made and returned, filtering / modifying the returned item prior to it going into my database.

Does anyone have any instructional videos or tutorials they recommend?