...
First time you use the API you will be asked to authenticate. Use Basic as authentication method. Insert your username. As password paste In the field for “Password”, paste in the API key as shown in the dRofus power query dialogue. Leave “User name” field blank.
...
Your dRofus username
API key
...
Creating your report
The data will initially be shown in one column. To expand data to a table Expand data to Table
...
Expand columns, (optional) do not use original column names, then select Convert → To Table in the upper left side of the Excel query window and expand columns (optional).
...
Close And Load to fill sheet your Excel spreadsheet with data.
...
You now have live data from API in Excel. To refresh data from source, right-click anywhere and select Refresh. :
...
...