We'll show you a quick guide how to use Microsoft Excel Power Query add-in tool, which is an add-in for Microsoft Excel.
Download the Microsoft Power Query for Excel
Before we dive into the fun part, let's review how to retrieve the Project Insight API Token from the Project Insight Application.
Enable API Token Access and copying the API Token to be used for REST API requests.
Swagger your REST API requests!. Click on the button to launch the tool, which includes documentation and definitions of the REST API classes!
Requesting a new AuthorizationToken using Swagger UI tool.
Try it out! Returning a new Authorization Token from the response.
Leave a comment below if you have any questions about this video and/or tutorial.