Xero to Excel - using API

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.

Taidot: Excel, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: xero excel, sql query xero, php export xero, export xero excel, export xero add excel, can extract excel xero, xero data extract, xero export excel, xero excel data api, winadmin, php to excel export, php api developer tool, online sql developer tool, how to write reports, how to write a simple blog, how to start online blog, how to start developer in excel, how to set up a blog, how to graphs, how to develop a blog, how to create database using php, graphs online, graphs design online, excel for data analysis, design and drill

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #4267552

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, We have designed and built websites for various types of businesses very effectively. We work with all of our clients individually to easily coordinate and to keep track of the requirements and scope. We fulfill y Lisää

$1750 USD 35 päivässä
(223 arvostelua)

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$750 USD 7 päivässä
(225 arvostelua)

Please check your inbox. Thanks

$1400 USD 20 päivässä
(61 arvostelua)

I will be happy to create this web application for you. Have a great experience with API using oAUTH. Also have great experience with PHP, MySQL,Javascript, jQuery and Excel. Hope to do business with you. Thx !

$1100 USD 16 päivässä
(91 arvostelua)

Hello, I am very interested. I am familiar with oauth both version 1 and 2. Kindly please let me know more detail on what kind of information need to be retrieved using that api? All of available on api or just p Lisää

$1500 USD 30 päivässä
(13 arvostelua)

Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. ! With a good Profile in Freelancer and experience of over seven years in the Software Aren Lisää

$750 USD 30 päivässä
(19 arvostelua)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Lisää

$1300 USD 25 päivässä
(5 arvostelua)

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.

$750 USD 3 päivässä
(0 arvostelua)

KCSPL is a Software Development IT Consulting Services Provider,Serving the Industry Since 11 years

$2500 USD 35 päivässä
(0 arvostelua)

Dear Sir, We have read your project specifications & We are confident to ensure your satisfaction in the form of completing the [url removed, login to view] will glad to help you. We are quite confident to get it done ontime. Please op Lisää

$750 USD 4 päivässä
(0 arvostelua)

We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.

$750 USD 3 päivässä
(0 arvostelua)

Will provide you browser-based interface which will extract data from xero and upload into excel. Pay me on 100% satisfaction

$1500 USD 30 päivässä
(0 arvostelua)

Hello Sir, Greeting of the Day!! I am a civil engineering professional with exceptional command over MS applications. I am also assisted by an MBA (Finance), MBA (HR & Marketing), and an Electrical Engineering pr Lisää

$1000 USD 20 päivässä
(0 arvostelua)

Hello sir! Please check our portofolio. Thank you!

$750 USD 4 päivässä
(0 arvostelua)