- 1 minutes to read

Use API in Excel with Power Query

Nodinite can be used as an API and the data from a Log View can be transmitted to Microsoft Excel through Power Query.


Instructions

Download Power Query

Power Query can be downloaded here as 64 or 32-bit, in your preferred language.

Download

Copy API URL

In the Log View, after a search is done, there's an option to Copy API URL.
Options

Copy the URL
Copy API URL


Excel

From web

Open Excel and go to the Power Query tab and click "From web".

From the web

Paste URL

Paste the URL.

URL

Authentication

Click Windows and "Use alternative authentication".

Log in with your user name and password from Nodinite.

Authentication

Parse to JSON

Go to the "Transform" tab and click "Parse" and choose JSON.

Parse to JSON

Choose Data

If too much data is selected, it won't fit in Excel.

Therefore, in this example, a limited amount of data is selected.
Button

Collection

Tip

Uncheck the box at the bottom to save space in the columns.

Items

Unmark all columns and choose "Items" Items

Data

Data

Message Type

Message Type

All

Mark All

Result

Ready

Close

Go to the start tab and hit "Close".
Close

Finished

Now you can use the data with Excel. Finish