hey @Stanford de Jong ,
You can use the List products attached to a deal endpoint to get that information. you need some programming skills to get the best of that endpoint, it is however a endpoint that is time and resources consuming.
You can also get some ETL to make the hard works for you, we use Stichdata for that job, and transfer that to our Postgree DB and then consume it.
Hope it gives you a way to do that.