API connections 2017-05-28T18:19:07+00:00

API connections

Don’t write code from scratch, don’t reinvent the wheel.

Most of the time the solution is already ‘out there’. It will be much cheaper to buy and use ‘off the shelf’ than writing it yourself. (or paying us to write it.)

With Excel API connections it is possible to connect with any other server or web server offering an API (Application Program Interface) connection.

The most common Excel API connections in business are those with Google, EBay, Amazon, PayPal and similar. Excel can both send and receive data through these connections. This enables huge time and error saving applications. With the Google API automated SEO becomes possible. With the likes of EBay and Amazon real time stock information. This eliminates unfilled orders and enables immediate dispatch.

How API Connections work:

First of all API connections work by sending a query to a computer. This takes the form of a text string. As a result the answer is then returned, also as a text string. These text strings are generated (assembled) and parsed (dissembled) using specific formats and rules. The most common of these formats are JSON (JavaScript Object Notation). Also REST (REpresentational State Transfer) an HTML based architecture.

Where Excel excels with using API’s is with its ability to build and format these strings. Doing so on demand using the clients data. Then parsing the response into usable data usable by the client. API connections have to be set up before use. This is done by registering with the API service and obtaining an authorisation code. Provided by the likes of Google, Ebay, or Amazon in the case of ecommerce.

An Excel developer can do this for you. But there are many downloadable software programs that do this for you as well. Functionality is very limited in the free versions. It is only by buying or with subscribing the client is given the ability to export the data. This begs the question why not build the whole thing in Excel in the first place. Therefore this is exactly what we do.

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. With API’s like Google not just for obtaining daily or weekly statistics.

The kinds of questions our customers ask us.

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Excel & API Case Studies

Leave your details, we will call you!

Or use our quote form!

Request a Free Quote