API connections 2017-06-25T20:58:41+00:00

API connections

Data is likely to be one of the most, if not THE most valuable assets your business has.
 
API’s are the keys to that data. They are hence poised, to become an increasingly valuable part of your business.
 
Excel is one of the best consumers of API’s on the market. Hence it is very likely that you will want to use this power.

 
 

How API Connections work:

What are API’s

 
API’s are protocols, specifications, that allow the exchange of information and online services, between organisations.
 
Put more simply, API’s let computers and datasets talk to each other.
 
This means, that API’s allow companies to share services with external agents. Its akin to the how the World Wide Web opended up the potential for the internet to billions of other users.
 

Example Of Using an API:

Suppose you ran an amusement park. You realised that people are more likely to click, on your web based adverts (such as Adwords), on sunny days.
 
Your aim then, is to increase your bids on days when the weather is sunny. So how do you do this?
 
Adwords has a scripting language, which will allow you to connect to online services. In this example, the BBC Weather map could be a good choice.
 
By using the API offered by the BBC, you could read the latest weather forecasts and update your Adwords bids. This could happen automatically at regular intervals.
 
Many companies have exploited the Salesforce and Ebay API’s. Generating large growths in revenue for all parties.
Sharing, and consuming data can be very profitable.
 
With the internet forever pushing further into our lives. Through the ‘internet of things’ for example. API’s can only become more important.

API’s and Excel

You can communicate with an API by sending and receiving text strings. The most common formats for these strings are known as JSON and REST .

Where we as developers, and Excel excel, with API’s is in building and format these strings in a dynamic and data contextual manner.

An Excel API connection is a classic example of Excel being a one-stop-shop for software solutions. We have direct experience of building fully automated applications that work in real time.

Excel & API Case Studies

Leave your details, we will call you!

Or use our quote form!