Pull records from a custom object

Hello Community!

As part of the database analysis project, I've been tasked with addressing the following scenario:

Our Eloqua contacts are linked to a custom object in a one-to-many relationship. Specifically, I need to extract the most recently created record in the custom object for each contact. I'm seeking advice on the optimal method to retrieve this information from Eloqua. Your guidance is greatly appreciated. Thank you!