How can I generate a report of app store purchases? (iOS/macOS)

I am preparing to clean up the apps on my iOS devices by grouping similar apps, deleting apps that perform similar functions, and maintaining a list of the apps I've deleted in case I need them again.

To get a report of all of my app downloads, the only way seems to be to open the App Store on each iOS device (iPad/iPhone etc.) and view the Purchased tab and create a spreadsheet manually. However, since I've downloaded several pages worth on multiple devices, this will prove to be a time-consuming process.

Is there a way to generate a report from my Apple ID account of all of my purchases and downloads from the various app stores, so that I could then manage the list in a spreadsheet program to help me to plan my reorganization project?

Otherwise, is there an open API that I could use as a resource if I were to program a script?