...

Excelインポートデータ

Selecting data to export

In the dRofus client, go to Reports and Exports → Excel exports. Find the relevant export to use as starting point. In the example below we want to get a list of rooms with a few relevant properties;

...

The API request URI and API key will be used for the query and authentication in Excel

Connect and authenticate in Excel

Create a new Excel-sheet, and select Data → From Web

...

First time you use the API you will be asked to authenticate. Use Basic as authentication method. In the field for “Password”, paste in the API key as shown in the dRofus power query dialogue. Leave “User name” field blank.

...

Creating your report

The data will initially be shown in one column. To expand data to a table Expand data to Table select Convert → To Table in the upper left side of the Excel query window and expand columns (optional).

...