Monthly Game Archives

I am writing a Spark application in Scala to be able to read player's game data from the Chess.com API. Reading this data into a DataFrame, however, is difficult. Essentially my DataFrame contains one collum and one row of data called "games" because of how the JSON is formatted in the archive. I'm not sure how to get around this. Any tips or insights?

Which endpoint are you hitting for the API?

@ImperatorJM The list of available archives for certain player is here: https://api.chess.com/pub/player/{username}/games/archives

Thanks @Nevfy I'm familiar with that, but there are a few different endpoints to hit for game data for users. Curious to know if it is the monthly archives endpoint JeroenWolfe is trying to hit or another.