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]
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.
14 freelancers are bidding on average $1182 for this job
We need to discuss further so that we could start the project as soon as possible. Waiting for your chat invitation and further communication on project requirements. Thanks and regards.