The API method provides customers access to information such as machines that are connected to the network and productivity data of the machine. Once you have an API access key, a URL is created according to your provider.


Importing Data into Excel:

1. Open Excel and open a new workbook.

2. Go to the Data Tab and click on Get Data. Select the option From Other Sources > From Web.

A screenshot of a computer

Description automatically generated

3. Paste the URL created based on your API key, and select OK.

A white rectangular object with a long line

Description automatically generated with medium confidence

4. Select the appropriate data set to display and click on Transform Data. 

A screenshot of a computer

Description automatically generated

5. Now in the Power Query Editor, go to the Home Tab, on the top left select Close & Load

A screenshot of a computer

Description automatically generated

Your data has now been imported into Excel.

Note:

  • If you want to access one data point, input the same URL except add the name of the data point. For example, using this URL from ei3 https://api.ei3.com/mds/ei3Corp/v1/machines/dataPoints/values?for=TotalMaterial&apiKey “for=TotalMaterial” was added so we can view the specific data from Total Material.
  • Make sure that all of your API tag descriptions do not have any special characters i.e. “!,-,$,$,&”. Special characters are not supported, thus, an error message will pop up when trying to import these into Excel. If this is the case, your tag descriptions must be modified. If you do not have Admin rights, please contact care@ei3.com to modify tag descriptions.

Adding Columns to Table:

1. If you want to go back in to make changes to any columns or add data go to the Query Tab, and click Edit.

A screenshot of a computer

Description automatically generated

2. The Power Query window will open. Select Add Column Tab, then Custom Column.

A screenshot of a computer

Description automatically generated

3. Add the new column name and input the columns formula for the new data, click OK.

A screenshot of a computer

Description automatically generated

4. The new column should be added. Click the Home Tab, then Close & Load.

A screenshot of a computer

Description automatically generated


Refreshing Data:

Automatically Refresh Data:

1. Click on the chart, go to the Query Tab, and select Properties.

A screenshot of a computer

Description automatically generated

2. A window will open titled “Query Properties”. Under usage, there are many different refresh options.

A screenshot of a computer

Description automatically generated

3. If you want your data to refresh every few minutes, check the box labeled Refresh every – minutes, then you can input the desired amount of time to refresh.

4. Click OK when you have selected your desired options. Your data will now refresh automatically.

Manually Refresh Data:

1. Select the Query Tab at the top of the page, then select the Refresh button.

A screenshot of a computer

Description automatically generated

2. Your data will then be manually updated.


Graphing in Excel:

1. After the table has loaded, go to the Query Tab and select Edit.

A screenshot of a computer

Description automatically generated

2. The “Power Query Editor” will appear, stay on the Home tab.

3. Highlight the desired column, select Data Type, then drop-down options will appear. Select the option that pertains to your data.

A screenshot of a computer

Description automatically generated

4. Repeat this with the next column. After editing each column, click Close & Load.

A screenshot of a computer

Description automatically generated

5. After your table has been refreshed, select the desired data to be graphed.

6. Go to the Insert tab and choose the appropriate graph. Some examples include line graphs, bar charts, and pie charts.

A screenshot of a computer

Description automatically generated

Note: If the data shows a date and time, select Data Type < Date/Time option. If there is a whole number being shown, you can select Whole Number or Decimal Number.

© 2024 ei3 Corporation. Content of this web page is proprietary to ei3 Corporation.

Print Friendly, PDF & Email