tag:xero.uservoice.com,2008-02-07:/forums/5528-xero-api Xero API on UserVoice 2014-04-12T06:02:39+08:00 tag:xero.uservoice.com,2008-02-07:Event/17805900 2014-04-12T06:02:39+08:00 2014-04-12T06:02:39+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>Ben McCann said:<br /><div class="typeset"><p>This is a rather difficult API endpoint to call at the moment since the XML schema for it is missing and may client libraries are generated from the schemas: <a href="https://github.com/XeroAPI/XeroAPI-Schemas/issues/9">https://github.com/XeroAPI/XeroAPI-Schemas/issues/9</a></p></div></p> Ben McCann tag:xero.uservoice.com,2008-02-07:Event/17797463 2014-04-11T08:03:58+08:00 2014-04-11T08:03:58+08:00 give the option for cashbook clients (that are cash coding) to add accounts to the chart of accounts - not just edit bank accounts <p>Tegan suggested:<br />Giving the option for clients that have limited access to the partner edition GST or non GST cashbook, that have &quot;cash coding&quot; access - the ability to add accounts to the chart. At the moment clients can only add or delete bank accounts. Some clients I wouldn&#39;t want to give this option to, but for other clients we would and don&#39;t want to have to keep adding them for them. </p> Tegan tag:xero.uservoice.com,2008-02-07:Event/17780194 2014-04-09T20:47:04+08:00 2014-04-09T20:47:04+08:00 API Overpayments &amp; Prepayments [updated] <p>See the latest comments on this below</p><p>Brendan Saunders said:<br /><div class="typeset"><p>Any idea of when we will be able to allocate a prepayment to an invoice?</p></div></p> Brendan Saunders tag:xero.uservoice.com,2008-02-07:Event/17767080 2014-04-08T10:57:10+08:00 2014-04-08T10:57:10+08:00 Enable the upcoming Purchase Order module to link to outside applications [updated] <p>My company has an app that services a very large niche market- all of those clients (tens of thousands) also need accounting. Our current app has rudimentary accounting in it but we are seeking to set up a sync with a dedicated cloud-app for all the accounting. Purchase Orders are crucial to this niche market and if we could sync them with Xero via api it would make a huge difference. (Provide GET/PUT/POST PurchaseOrders endpoint)</p><p>Jon said:<br /><div class="typeset"><p>+1 on this - will be fantastic when available</p></div></p> Jon tag:xero.uservoice.com,2008-02-07:Event/17765601 2014-04-08T07:17:50+08:00 2014-04-08T07:17:50+08:00 Enable the upcoming Purchase Order module to link to outside applications [updated] <p>My company has an app that services a very large niche market- all of those clients (tens of thousands) also need accounting. Our current app has rudimentary accounting in it but we are seeking to set up a sync with a dedicated cloud-app for all the accounting. Purchase Orders are crucial to this niche market and if we could sync them with Xero via api it would make a huge difference. (Provide GET/PUT/POST PurchaseOrders endpoint)</p><p>Kalen Jordan said:<br /><div class="typeset"><p>Also interested in purchase orders API (read access specifically).</p> <p>Thanks.</p></div></p> Kalen Jordan tag:xero.uservoice.com,2008-02-07:Event/17707266 2014-04-02T15:22:27+08:00 2014-04-02T15:22:27+08:00 3 dec point in money <p>Shaun suggested:<br />please can we have 3 dec point in money. eg. i need to be able to enter ... @ $0.075</p> Shaun tag:xero.uservoice.com,2008-02-07:Event/17692357 2014-04-01T12:43:25+08:00 2014-04-01T12:43:25+08:00 PUT/POST tracking categories and options [updated] <p>Be able to create tracking options via the API. Also when creating invoices via the API allow the creation of tracking options within Xero&#39;s existing tracking groups if they don&#39;t exist. </p><p>Anonymous said:<br /><div class="typeset"><p>Customer of mine is copying invoices from Infusionsoft to Xero. They have a custom field in Infusionsoft which they want copied as the Region tracking category for each line item in the invoice.</p> <p>Unless I can add these on the fly, each tracking category option must already exist in Xero for all this to work. Otherwise, the API silently ignores the Region tracking category option that I try to set for each line item. </p></div></p> Anonymous tag:xero.uservoice.com,2008-02-07:Event/17683250 2014-03-31T19:43:18+08:00 2014-03-31T19:43:18+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>Cristian said:<br /><div class="typeset"><p>Being able to create repeating invoices via the API would be very useful, it would save us a lot of time</p></div></p> Cristian tag:xero.uservoice.com,2008-02-07:Event/17680648 2014-03-31T09:59:49+08:00 2014-03-31T09:59:49+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>Media Suite said:<br /><div class="typeset"><p>Awesome thanks for the update. Looking forward to being able to create repeating invoices via the API too. </p></div></p> Media Suite tag:xero.uservoice.com,2008-02-07:Event/17680417 2014-03-31T08:59:58+08:00 2014-03-31T08:59:58+08:00 Repeating invoices via the API [is now started] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p> xero tag:xero.uservoice.com,2008-02-07:Event/17680416 2014-03-31T08:59:58+08:00 2014-03-31T08:59:58+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>xero (admin) responded:<br /><div class="typeset"><p>Today we released the ability to retrieve repeating invoices via a new RepeatingInvoices endpoint: <a href="http://developer.xero.com/documentation/api/repeating-invoices/">http://developer.xero.com/documentation/api/repeating-invoices/</a></p> <p>We have not yet begun work to create repeating invoices, so this endpoint will initially only have utility for those looking to use it for reporting.</p> <p>We will leave this feature request open and update it as soon as we have further news to share on creating repeating invoices via the API.</p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17679550 2014-03-31T05:31:25+08:00 2014-03-31T05:31:25+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>James Farha said:<br /><div class="typeset"><p>Yes - please add! Would be very helpful. </p></div></p> James Farha tag:xero.uservoice.com,2008-02-07:Event/17667506 2014-03-29T04:26:50+08:00 2014-03-29T04:26:50+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>Lena Bostrom said:<br /><div class="typeset"><p>Yes,Please</p></div></p> Lena Bostrom tag:xero.uservoice.com,2008-02-07:Event/17649820 2014-03-28T09:04:07+08:00 2014-03-28T09:04:07+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>Jason said:<br /><div class="typeset"><p>Yes please, this function would be great</p></div></p> Jason tag:xero.uservoice.com,2008-02-07:Event/17645549 2014-03-28T00:23:09+08:00 2014-03-28T00:23:09+08:00 Expose which user connected the organization via OAuth <p>Ophir Horowitz suggested:<br />Currently, we have no idea which user connected via OAuth. In other platforms (QB for once), you get details (especially email) of the user, and can design behavior based on it. In Xero, we get all the data on the users (with the new email address field), but we don&#39;t which user connected. If this will be exposed, it will give the developers more tools to create a more specific experience for the users</p> Ophir Horowitz tag:xero.uservoice.com,2008-02-07:Event/17643372 2014-03-27T20:15:51+08:00 2014-03-27T20:15:51+08:00 EU Country field [updated] <p>Be able to update the EU Country field via the API. This is required and seems very strange to be left out of the API.</p><p>Luke Whittle said:<br /><div class="typeset"><p>100% needed!</p></div></p> Luke Whittle tag:xero.uservoice.com,2008-02-07:Event/17641598 2014-03-27T13:47:28+08:00 2014-03-27T13:47:28+08:00 Repeating invoices via the API [updated] <p>Be able to create and manage repeating invoices (http://help.xero.com/#Accounts_RepeatingInvoice) via the API. </p><p>Mish said:<br /><div class="typeset"><p>Yes please</p></div></p> Mish tag:xero.uservoice.com,2008-02-07:Event/17639175 2014-03-27T06:32:49+08:00 2014-03-27T06:32:49+08:00 Expose the user email address via the User endpoint [is now completed] <p>Hi, I would like to be able link the UserID with the email associated to it. knowing the email address of a xero user, is required to achieve any mash up with external services. Thanks Nicola</p> xero tag:xero.uservoice.com,2008-02-07:Event/17639174 2014-03-27T06:32:49+08:00 2014-03-27T06:32:49+08:00 Expose the user email address via the User endpoint [updated] <p>Hi, I would like to be able link the UserID with the email associated to it. knowing the email address of a xero user, is required to achieve any mash up with external services. Thanks Nicola</p><p>xero (admin) responded:<br /><div class="typeset"><p>I&#39;m pleased to confirm we have added this field to the users endpoint in our most recent release: <a href="http://developer.xero.com/documentation/api/v2-release-notes/#2.45">http://developer.xero.com/documentation/api/v2-release-notes/#2.45</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17637682 2014-03-27T04:05:33+08:00 2014-03-27T04:05:33+08:00 Make Chart of Accounts updatable via API [is now started] xero tag:xero.uservoice.com,2008-02-07:Event/17637681 2014-03-27T04:05:33+08:00 2014-03-27T04:05:33+08:00 Make Chart of Accounts updatable via API [updated] <p>xero (admin) responded:<br /><div class="typeset"><p>Recent updates allow the creation of accounts and bank accounts via the API: <br /><a href="http://developer.xero.com/documentation/api/v2-release-notes/#2.36">http://developer.xero.com/documentation/api/v2-release-notes/#2.36</a> <br /><a href="http://developer.xero.com/documentation/api/v2-release-notes/#2.41">http://developer.xero.com/documentation/api/v2-release-notes/#2.41</a></p> <p>Work continues to allow the bulk creation/replacement of a chart of accounts, and editing existing COA values.</p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17637618 2014-03-27T03:57:37+08:00 2014-03-27T03:57:37+08:00 Make Company -&gt; Line of Business readable via the API [is now completed] <p>It would be useful to be able to access the &quot;Line of Business&quot; field programatically, which would allow developers to then build analytic tools for accountants</p> xero tag:xero.uservoice.com,2008-02-07:Event/17637617 2014-03-27T03:57:37+08:00 2014-03-27T03:57:37+08:00 Make Company -&gt; Line of Business readable via the API [updated] <p>It would be useful to be able to access the &quot;Line of Business&quot; field programatically, which would allow developers to then build analytic tools for accountants</p><p>xero (admin) responded:<br /><div class="typeset"><p>The line of business field is now returned on the GET Organisation API call: <a href="http://developer.xero.com/documentation/api/organisation/">http://developer.xero.com/documentation/api/organisation/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17637613 2014-03-27T03:57:08+08:00 2014-03-27T03:57:08+08:00 GET Organisation: expose &#39;line of business&#39; field [is now completed] <p>expose the &#39;line of business&#39; field that is set in the organisation settings in Xero, to show the industry that organisation is in.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17637612 2014-03-27T03:57:08+08:00 2014-03-27T03:57:08+08:00 GET Organisation: expose &#39;line of business&#39; field [updated] <p>expose the &#39;line of business&#39; field that is set in the organisation settings in Xero, to show the industry that organisation is in.</p><p>xero (admin) responded:<br /><div class="typeset"><p>The line of business field is now returned on the GET Organisation API call: <a href="http://developer.xero.com/documentation/api/organisation/">http://developer.xero.com/documentation/api/organisation/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17627158 2014-03-26T05:53:55+08:00 2014-03-26T05:53:55+08:00 EU Country field <p>Anonymous suggested:<br />Be able to update the EU Country field via the API. This is required and seems very strange to be left out of the API.</p> Anonymous tag:xero.uservoice.com,2008-02-07:Event/17619990 2014-03-25T17:23:10+08:00 2014-03-25T17:23:10+08:00 Import bank statement lines via the API [updated] <p>Be able to import bank statement lines into a bank account in Xero. This would be useful for custom bank accounts or banks that do not have a direct feed into Xero</p><p>sysret said:<br /><div class="typeset"><p>Hi Xero</p> <p>Is there any update when this will be started?</p></div></p> sysret tag:xero.uservoice.com,2008-02-07:Event/17619786 2014-03-25T16:39:55+08:00 2014-03-25T16:39:55+08:00 Enable the upcoming Purchase Order module to link to outside applications [updated] <p>My company has an app that services a very large niche market- all of those clients (tens of thousands) also need accounting. Our current app has rudimentary accounting in it but we are seeking to set up a sync with a dedicated cloud-app for all the accounting. Purchase Orders are crucial to this niche market and if we could sync them with Xero via api it would make a huge difference. (Provide GET/PUT/POST PurchaseOrders endpoint)</p><p>Andy said:<br /><div class="typeset"><p>Hi, Kevin, could you please give us any ETA when the purchase order might be available through Xero API. We got a project demand this feature right now. Thanks</p></div></p> Andy tag:xero.uservoice.com,2008-02-07:Event/17619607 2014-03-25T16:02:17+08:00 2014-03-25T16:02:17+08:00 how to use query string with url [is now declined] <p>i want to get all the invoices where name contains abc, i am using c# for integration, i have tried this .ForUri(new Uri(&quot;https://api.xero.com/api.xro/2.0/Invoices?where=Name.Contains(abc)&quot;)) this will trough an error bad request, how to do this correctly</p> xero tag:xero.uservoice.com,2008-02-07:Event/17619606 2014-03-25T16:02:17+08:00 2014-03-25T16:02:17+08:00 how to use query string with url [updated] <p>i want to get all the invoices where name contains abc, i am using c# for integration, i have tried this .ForUri(new Uri(&quot;https://api.xero.com/api.xro/2.0/Invoices?where=Name.Contains(abc)&quot;)) this will trough an error bad request, how to do this correctly</p><p>xero (admin) responded:<br /><div class="typeset"><p>Code questions are best asked in our developer community: <a href="https://community.xero.com/developer/">https://community.xero.com/developer/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17619593 2014-03-25T16:00:42+08:00 2014-03-25T16:00:42+08:00 Provide some sort of Metadata / Documention / Help api call like $metadata for OData [is now declined] <p>We&#39;re looking to add Xero into our synchronisation tool, that would allow us to have two way syncing to other systems, such as SharePoint, MS CRM. It would be really useful if we could get a list of rest entities and there schema dynamically so the sync tool would not need to be updated.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17619592 2014-03-25T16:00:42+08:00 2014-03-25T16:00:42+08:00 Provide some sort of Metadata / Documention / Help api call like $metadata for OData [updated] <p>We&#39;re looking to add Xero into our synchronisation tool, that would allow us to have two way syncing to other systems, such as SharePoint, MS CRM. It would be really useful if we could get a list of rest entities and there schema dynamically so the sync tool would not need to be updated.</p><p>xero (admin) responded:<br /><div class="typeset"><p>Unfortunately this does not align with our strategy of focusing on our API development and supporting it via SDKs rather than discovery tools.</p> <p>There are however a set of XSD schemas available: <a href="https://github.com/XeroAPI/XeroAPI-Schemas">https://github.com/XeroAPI/XeroAPI-Schemas</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17619579 2014-03-25T15:57:55+08:00 2014-03-25T15:57:55+08:00 Allow posting to bank accounts via the API [is now completed] <p>All that is required is that the Invoice API be changed to allow posting to the bank accounts. Then it will serve as a general transaction import function.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17619578 2014-03-25T15:57:54+08:00 2014-03-25T15:57:54+08:00 Allow posting to bank accounts via the API [updated] <p>All that is required is that the Invoice API be changed to allow posting to the bank accounts. Then it will serve as a general transaction import function.</p><p>xero (admin) responded:<br /><div class="typeset"><p>We have provided this via the BankTransactions endpoint, but missed closing out this issue at the time: <a href="http://developer.xero.com/documentation/api/banktransactions/">http://developer.xero.com/documentation/api/banktransactions/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17619571 2014-03-25T15:56:09+08:00 2014-03-25T15:56:09+08:00 Compress responses (Gzip) [is now completed] <p>Responses from the API should be compressed (e.g. gzipped) as XML is very verbose and responds well to being compressed. This should be a simple setting change within IIS. I haven&#39;t tried my application with the production system so it might already be enabled there, but this would also help in the test system. As the server will only respond with compressed content if the client request says it supports it, this feature shouldn&#39;t break anyone&#39;s existing code.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17619570 2014-03-25T15:56:09+08:00 2014-03-25T15:56:09+08:00 Compress responses (Gzip) [updated] <p>Responses from the API should be compressed (e.g. gzipped) as XML is very verbose and responds well to being compressed. This should be a simple setting change within IIS. I haven&#39;t tried my application with the production system so it might already be enabled there, but this would also help in the test system. As the server will only respond with compressed content if the client request says it supports it, this feature shouldn&#39;t break anyone&#39;s existing code.</p><p>xero (admin) responded:<br /><div class="typeset"><p>This is now the default response</p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17619552 2014-03-25T15:52:54+08:00 2014-03-25T15:52:54+08:00 document api response from POST,PUT and DELETE not only GET. [is now completed] <p>i.e. on successful Contacts POST returned xml will be: &lt;write&gt;returned xml here&lt;/write&gt; while on failure, depending on the cause, the following errors can be returned:&lt;error&gt; possible error here&lt;/error&gt; And so on for all the methods in Contacts, Invoices etc. Currently only the GET responses are documented.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17619551 2014-03-25T15:52:54+08:00 2014-03-25T15:52:54+08:00 document api response from POST,PUT and DELETE not only GET. [updated] <p>i.e. on successful Contacts POST returned xml will be: &lt;write&gt;returned xml here&lt;/write&gt; while on failure, depending on the cause, the following errors can be returned:&lt;error&gt; possible error here&lt;/error&gt; And so on for all the methods in Contacts, Invoices etc. Currently only the GET responses are documented.</p><p>xero (admin) responded:<br /><div class="typeset"><p>This old issue has been fully addressed, but please feel free to let us know if there are any more documentation issues you spot.</p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17619542 2014-03-25T15:51:47+08:00 2014-03-25T15:51:47+08:00 Allow the use of Reference or InvoiceNumber on Invoices endpoint for AP invoices [is now declined] <p>Currently you have to use the InvoiceNumber element and the Reference element is ignored. </p> xero tag:xero.uservoice.com,2008-02-07:Event/17619541 2014-03-25T15:51:47+08:00 2014-03-25T15:51:47+08:00 Allow the use of Reference or InvoiceNumber on Invoices endpoint for AP invoices [updated] <p>Currently you have to use the InvoiceNumber element and the Reference element is ignored. </p><p>xero (admin) responded:<br /><div class="typeset"><p>As this reflects how the main application works, there will be no change forthcoming here.</p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17619537 2014-03-25T15:50:00+08:00 2014-03-25T15:50:00+08:00 Could Xero grab a RSS feed periodically to enter invoices [is now declined] <p>Rather than having a system push data to Xero , Xero could be set to subscribe to an RSS feed that is in the correct format to add invoices.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17619536 2014-03-25T15:50:00+08:00 2014-03-25T15:50:00+08:00 Could Xero grab a RSS feed periodically to enter invoices [updated] <p>Rather than having a system push data to Xero , Xero could be set to subscribe to an RSS feed that is in the correct format to add invoices.</p><p>xero (admin) responded:<br /><div class="typeset"><p>This doesn&#39;t fit with out API model.</p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17616161 2014-03-25T05:40:04+08:00 2014-03-25T05:40:04+08:00 Provide a space for job address on a invoice for the building and construction industry [is now declined] <p>I really need a space to enter in a job address for invoices as each invoice is allocated to a specific job.</p> xero tag:xero.uservoice.com,2008-02-07:Event/17616160 2014-03-25T05:40:04+08:00 2014-03-25T05:40:04+08:00 Provide a space for job address on a invoice for the building and construction industry [updated] <p>I really need a space to enter in a job address for invoices as each invoice is allocated to a specific job.</p><p>xero (admin) responded:<br /><div class="typeset"><p>As this forum is for developer API functionality requests and yours relates to something that would need to happen in the main application, I&#39;m afraid we have to decline this suggestion, but don&#39;t take it personally - we would still love to see you make your suggestion in the Xero Community forum: <a href="https://community.xero.com/business/">https://community.xero.com/business/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17616152 2014-03-25T05:39:12+08:00 2014-03-25T05:39:12+08:00 Change Credit Notes Editing [is now declined] <p>When trying to complete a credit note you cant amend the amount on a invoice that has already received a payment this is frustrating as we run promotions all the time and it is annoying to have to either delete the invoice and reenter it or delete the payment and re enter it, this is more work load and it would be more benifical to be able to enter the amount that you are wanting to enter rather then it automatically deleting the amount outstanding on the invoice, will they be able to make this more user friendly by entering the amount to be credited?</p> xero tag:xero.uservoice.com,2008-02-07:Event/17616151 2014-03-25T05:39:12+08:00 2014-03-25T05:39:12+08:00 Change Credit Notes Editing [updated] <p>When trying to complete a credit note you cant amend the amount on a invoice that has already received a payment this is frustrating as we run promotions all the time and it is annoying to have to either delete the invoice and reenter it or delete the payment and re enter it, this is more work load and it would be more benifical to be able to enter the amount that you are wanting to enter rather then it automatically deleting the amount outstanding on the invoice, will they be able to make this more user friendly by entering the amount to be credited?</p><p>xero (admin) responded:<br /><div class="typeset"><p>As this forum is for developer API functionality requests and yours relates to something that would need to happen in the main application, I&#39;m afraid we have to decline this suggestion, but don&#39;t take it personally - we would still love to see you make your suggestion in the Xero Community forum: <a href="https://community.xero.com/business/">https://community.xero.com/business/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17616137 2014-03-25T05:37:56+08:00 2014-03-25T05:37:56+08:00 Add an OData interface to query live transaction data directly from Microsoft Excel [is now declined] <p>Microsoft Excel is an essential tool for all accountants. It can be easily configured to consume an OData data source. OData is a standardized protocol for creating restful data APIs. This XML-based protocol supports the ability to create filtered data streams. By exposing live transaction data through a secured, well-engineered OData API, you will be adding massive value to your customers accounting data. OData combined with Excel Pivot Tables and PowerPivot creates an incredibly potent analysis and reporting tool. All your customers already own Excel. PowerPivot is a free add-in from Microsoft. All that&#39;s needed is an OData API and a bit of instruction. More info: http://www.odata.org/ http://www.microsoft.com/en-us/bi/powerpivot.aspx</p> xero tag:xero.uservoice.com,2008-02-07:Event/17616136 2014-03-25T05:37:56+08:00 2014-03-25T05:37:56+08:00 Add an OData interface to query live transaction data directly from Microsoft Excel [updated] <p>Microsoft Excel is an essential tool for all accountants. It can be easily configured to consume an OData data source. OData is a standardized protocol for creating restful data APIs. This XML-based protocol supports the ability to create filtered data streams. By exposing live transaction data through a secured, well-engineered OData API, you will be adding massive value to your customers accounting data. OData combined with Excel Pivot Tables and PowerPivot creates an incredibly potent analysis and reporting tool. All your customers already own Excel. PowerPivot is a free add-in from Microsoft. All that&#39;s needed is an OData API and a bit of instruction. More info: http://www.odata.org/ http://www.microsoft.com/en-us/bi/powerpivot.aspx</p><p>xero (admin) responded:<br /><div class="typeset"><p>We have no plans to support OData, preferring to stick with our technology agnostic web services API with OAuth authentication.</p> <p>There are however, a number of commercial add-ons available using our API, providing Excel integration: <br /><a href="http://www.businessbackbone.co.uk/xero-excel-reporting">http://www.businessbackbone.co.uk/xero-excel-reporting</a> <br /><a href="http://www.quickwindevelopment.com/addons/excel-integration-tools/">http://www.quickwindevelopment.com/addons/excel-integration-tools/</a></p></div></p> xero tag:xero.uservoice.com,2008-02-07:Event/17616111 2014-03-25T05:33:55+08:00 2014-03-25T05:33:55+08:00 Make it possible to back up and restore xero at any point [is now declined] <p>Xero makes it very difficult to undo transactions and postings if they have been done incorrectly. Could you make it so before handing xero over to clients you could take a back up of the accounts which you could then restore if nessacery and overwrite any mistakes made. Thanks Jasmine</p> xero tag:xero.uservoice.com,2008-02-07:Event/17616110 2014-03-25T05:33:55+08:00 2014-03-25T05:33:55+08:00 Make it possible to back up and restore xero at any point [updated] <p>Xero makes it very difficult to undo transactions and postings if they have been done incorrectly. Could you make it so before handing xero over to clients you could take a back up of the accounts which you could then restore if nessacery and overwrite any mistakes made. Thanks Jasmine</p><p>xero (admin) responded:<br /><div class="typeset"><p>As this forum is for developer API functionality requests and yours relates to something that would need to happen in the main application, I&#39;m afraid we have to decline this suggestion, but don&#39;t take it personally - we would still love to see you make your suggestion in the Xero Community forum: <a href="https://community.xero.com/business/">https://community.xero.com/business/</a></p></div></p> xero