Xero to Excel - using API

This project received 14 bids from talented freelancers with an average bid price of $1182 USD.

Get free quotes for a project like this
Project Budget
$750 - $1500 USD
Total Bids
Project Description

Design and build tool which extracts data from Xero ([url removed, login to view]) using their API and enables user to write SQL queries and export the data into Excel for presentation and further analysis. Ability to upload non-Xero data to online database and which can be queried alongside data from Xero. At this stage no data to be pushed into Xero.

Simple documentation to be provided on how to set-up end solution (if appropriate).

Preferred method of linking to Xero, using Public Application » [url removed, login to view]

Useful information:

Xero API » [url removed, login to view]

PHP Library » [url removed, login to view]

Possible ideas for linking database to Excel:

1. SQL drill » [url removed, login to view]

2. MS Query

Looking at this as a proof of concept and could be the start of a long term relationship - our aspirations for the future are (these points should be taken into consideration but not costed at this stage):

1. Create simple user interface that enables user to query without SQL knowledge;

2. Develop suite of standard reports to be viewed online and incorporates graphs/visuals;

3. Extend API to extract data from other online systems.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online