Integration
With FlyingFleet, you can effortlessly extract data from the web and analyze it using your preferred tools, such as Excel or PowerBI.
Excel
For this tutorial, we'll use the English version of Excel. While menu names may differ in other languages, the underlying functions and features are the same.
Inside your Excel Workbook, open the "Data" tab, and choose on top "From Web"
A window will appear asking the URL of the web page you want to load. Enter here the URL of the site and the API Url for example: https://demo.flying-fleet.com/api/Aircrafts/CAMO/HB-SCP
After the URL selection, an access control window will be displayed:
Select "Basic" authentication and provide your usual email as username and the password.
A "Power Query Editor" will then be presented which can be either used as is or customized for example to load the data depending on the value provided in a cell. (More on this later on this page)
Choose the button on top left "Into Table" and then finally "Close & Load".
At the end of all those manipulation a new sheet will be added to the Workbook containing the data loaded from FlyingFleet.
Refreshing the data is then just matter of pressing the "Refresh All" button available in the "Data" tab.
Modify the linked data
Once the data has been added to the Workbook it is possible to edit the link from FlyingFleet by choosing the "Query" tab within the linked sheet. Then clicking the "Edit" button.
The URL can be then modified by choosing the "Data source settings" and then the "Change Source..." button.
To change the "Load" step, click the "Source" line of the "APPLIED STEPS" found on the bottom right part of the window.
Dynamic URL based on cell content
First define a "named cell". Go to the cell in the spreadsheet which shall be used as parameter in the URL. On the top left appears the default name:
In this example E2. Click on this field and enter a name you want to use, for example CallSign. Now your cell has a logical name you can use everywhere.
While editing the source step the formula presented on top can be edited.
By entering a formula like the following, the URL can be composed together with the value of a cell, and be therefore dependent of the Workbook.
= Json.Document( Web.Contents("https://demo.flying-fleet.com/api/Aircrafts/CAMO/" & Excel.CurrentWorkbook(){[Name="CallSign"]}[Content]{0}[Column1]&""))Updating credentials
Wrong credentials are displayed as a popup starting with [DataSource.Error]
Go to the "Data" tab and choose "Queries & Connections".
A list on the right of the window should show
Double click the desired query which opens the "Power Query Editor". Click the "Data Source settings"
A list of URLs will be displayed. On the bottom, click the "Edit Permissions..." button.
Click the button "Edit".
Make sure the "basic" mode is selected and provide the username / password in the fields and finally press save.
