Hi Franco,
If it helps, I did put an example of how I managed to connect to the API using Powerquery in the below article. I appreciate you have solved your issue for now, but you never know, it could be useful for you going forward.
Hope it helps!