Thank you for your replies.
Unfortunately, it's not possible to use a switch, there are 50 sites to migrate, and we want to do everything remotely.
Yes, I tried CDP/LLDP, but it's not enabled for all devices, and we do not get relevant information.
It would be so helpful to get this data with API, as it's already available on the Dashboard.
I'll then try to get data manually before, by creating an inventory from the dadhboard.
Automation, but with manual steps 😅