Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.

All in all, your first RESTful API in Python is about piecing together clear endpoints, matching them with the right HTTP ...

If you're paying for software features you're not even using, consider scripting them.