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.
You need to clean database after your test cases, you can do it simply with only one call. type - 'truncate' - DEFAULT: use truncate to clear all tables in database and restart sequences - 'delete' - ...