Hello Dear,
I am Ibrahim and I am a data scientist, I can build a script in python, in jupyter lab, and this would connect to different APIs and into Pandas, currently working on something very similar, but you have to provide APIs and their accesses, for each piece of information you require.
Regards,
Ibrahim Anjum