Overview
The AGR Public API allows you to fetch forecast data and other calculations that AGR generates, enabling you to perform analysis using a BI tool of your choice.
This article covers how to get Forecast and Item data since they depend on each other.
Below is a step-by-step guide on connecting to your data feed using PowerBI, although it is applicable in Excel too.
Open AGR and ask for an access token to the AGR Public API through the help chat.
A Customer Success Manager will supply you with a very long jumble of characters. This is your API token.
Open PowerBI, click Get Data and select Web:
We will start by getting the forecast values and then the Items.
In the window that pops up, select Advanced.
Paste the following URL into the URL parts text box (https://api.agrinventory.net/api/Forecast/values/all/stream).
Write "Authorization" into the HTTP request header parameters text box.
Write "Bearer " into the text box to the right.
Finally, paste the API token you received in step 2 behind the Bearer keyword. Your window should look like this:
Note that it is important to have a space between the "Bearer" keyword and your API token!
Press OK to get another modal. Select Anonymous in the top left and press Connect.
A Power Query Editor window will open. You should see something like the image below:
For this example, we won't transform or modify the data. Click Close & Apply in the top left. You now have a data stream for forecast values generated by AGR.
To get the Item list and supporting information, in the same PowerBI window, repeat steps 3. to 5. but put the following URL into the URL parts textbox (https://api.agrinventory.net/api/Item/stream).
A Power Query Editor window will open. This one should look like the image below:
Now is a good time to rename the two queries we have set up to something more descriptive.
In this example, we have renamed the Forecast and Items queries to ForecastValues and ItemInfo, respectively. When done, press Close & Apply in the top left.
If you click on the Model View in the left sidebar, you can see a small model for the two previously created queries. PowerBI usually creates relationships automatically, so your model will look similar to the image below.
You should now have a functioning data set in PowerBI and can start analyzing!
Please note that the refresh schedule needs to be set to once per day.