I’m trying to download some data through Excel PowerQuery and Manager Web Interface but I cannot login into Manager. Is there a way to login into Manager giving username and password through the url of the cloud edition?
Manager supports basic authentication in URL.
Have you tried?
https://username:password@yourname.manager.io/......
Sorry but I cannot get it to work… both under Browser and under Excel
For now, this authentication method works only if retrieving URLs with .json extension.
What screen are you trying to retrieve?
I’m trying to retreive a custom reports’ table via Excel Power Query. Is there a way to retreive a .csv or an html table of a report via web adding something to the URL like .json? I cannot get Excel to decode json generate from Manager in any way.
The other way I’m thinking is to have some reports with access free from password (knowing the url obviously…).