Importing Data into Excel from the Connections Online API

API Documentation:

First we need to get the address of the data we want to view. For this example we will look at projects. You can find all of the possible calls in the API documentation. When you look at the documentation you will see a screen that looks like this.

1. Actions that can be performed using the API.

• GET - Reads data from Connections Online
• POST - Creates a new item
• PUT - Updates a single item
• DELETE - Deletes an item

2. Route for the calls. We just need to add the desired route to the end of https://api.connectionsonline.net/v4 if it requires a parameter to be passed in you will see that between the { }.

Examples:

• GET /projects = https://api.connectionsonline.net/v4/projects
• GET /projects/{id} = https://api.connectionsonline.net/v4/projects/FEB35CC0-CA92-4BF8-A339-A8F8F40D4586

3. Description of what the action/route does.

We want to use the GET /projects for this so we will be using https://api.connectionsonline.net/v4/projects. You can go there now if you want, but the data that is returned won't be easy to read.

Tech Tip:
You can use this portal to try out any of these calls you would like. 
If there are required parameters you will have to fill them in, but 
after that you can hit "Try it out!" and see the data you will receive 
when you call it from another application.

Excel:

Open an Excel window and go to the data tab. Once there you will want to click on the "From Web" option. Paste the address into the Address bar and hit Go.

Once you navigate to the page you will be greeted with some data. You don't need worry about what it looks like at this point just import it and it should load into Excel.

Once in Excel you can do whatever you want with the data. Keep in mind that any changes that you make in the excel file will not be synced back into Connections Online. At any time you can hit the Refresh button to get the current data. When you do this it will keep any columns you renamed and any columns you removed. However, it will reset your filters.