I'm loading a record and writing to it for every JSON item that gets return from an API, I can see the API returned all of the expected items (2234 items) but some of the items were clearly not written too. It's writing the current date and the stock level returned by the api. some of the items have a previous date which means it was not updated.

Have you tried using any of the summary objects