38 questions
0
votes
0
answers
23
views
Xero Contacts API only updates “Bills” payment terms but ignores “Sales” payment terms
Title:
Xero Contacts API only updates “Bills” payment terms but ignores “Sales” payment terms (no error returned)
Body:
I’m working on a Salesforce → Xero integration that updates contact payment ...
0
votes
0
answers
25
views
Why is my file attachment corrupted when uploading from an S3 signed URL buffer using createInvoiceAttachmentByFileName in Xero?
I'm using Xero's createInvoiceAttachmentByFileName function to attach a file to an invoice. The file is stored in S3, so I first generate a pre-signed URL, fetch the file using that URL, convert the ...
-5
votes
1
answer
96
views
Porting Xero API Google Apps script code to C# not working
I am new to this. I am trying to interact with Xero APIs (identity initially) in C# without using the sdk. I did this successfully in Google Apps Script using UrlFetchApp.fetch but now here is my C# ...
0
votes
1
answer
151
views
Facing Error: unauthorized_client : Invalid scope for client for Xero
I am developing an integration using the Xero Accounting API and I am following the standard OAuth 2.0 Authorization Code flow. My application is registered in the Xero Developer Console, and the ...
0
votes
0
answers
27
views
XERO API Error 17 NoDataProcessedException POST Items
I've been trying to POST an Item to XERO but I'm getting the Error17 message that a lot of people seem to have faced, however I've not managed to find a solution here.
I'm using Power Automate to ...
0
votes
2
answers
72
views
Xero Webhooks Intent to Receive - Laravel
For the Xero webhooks, one needs to validate the hashed payload against the signature in the header. This should be simple, but I cannot get the hashed and base64 encoded payload to match the ...
0
votes
0
answers
28
views
API request for the sales and accounting module in Xero
Can someone help provide the API for the sales module and the accounting module. I am trying to get the sales from Xero to be integrated with Power BI. Currently I have sales invoices being raised ...
0
votes
1
answer
45
views
Xero API incorrectly updating discount fields for invoice when hitting updateInvoice endpoint
I have integrated Xero with Shopify using a 3rd party app (Parex Bridge). I've had no issues with the integration so far, apart from discounts. When I apply a discount to an order on Shopify, the ...
0
votes
1
answer
77
views
Fetching Trial Balance for a Date Range in Xero API: Alternatives & Workarounds
How can I fetch a Trial Balance report for a specific date range using the Xero API? The getReportTrialBalance method only provides a Trial Balance as of a single date, but I need to retrieve balances ...
0
votes
0
answers
50
views
Create a history note when creating an invoice
When I create an invoice via the Xero API, is it possible to create a history note along with it? If I'm reading the API documentation correctly, it isn't currently supported.
Often I want a note ...
1
vote
1
answer
116
views
Why do I get an absolute URL error in xero oauth for a valid URL?
I am using xero-node for javascript development but I am getting an error when I try and create the xero client. I call this code.
const consentUrl = await xero.buildConsentUrl()
I create the xero ...
0
votes
0
answers
76
views
Xero throwing exception "Where clause invocation error: Operations on optional fields must be preceded by a null guard, e.g. "[FieldName] != null""
Suddenly my Xero account throwing this exception with Existing Data when trying to get Invoice list
"Where clause invocation error: Operations on optional fields must be preceded by a null guard, ...
-3
votes
1
answer
38
views
Create an item with 3 diferente prices
I want to create an Item with 3 different price. How can I do that thought the API, what would be the json data that I must send as body?
0
votes
1
answer
80
views
Xero API - How to mark a credit note as sent once a payment has been made?
I'm using the xero-python SDK to send invoices and credit notes to my customers via email. Once I've sent an invoice/credit note, I wish to mark it as sent in Xero. I can do this for invoices by doing ...
1
vote
0
answers
115
views
Securing a Google Function Handling Xero Webhook Data
I have a Xero App that handles REST API calls to my Xero Company data, and also posts data as a webhook when certain records are changed.
I perform the Hmac hashing authentication for the webhook ...
0
votes
1
answer
88
views
Generic Error 500 in prod but not in dev for the same code
I have been using the developer organization for the dev environment fine and have also got a separate live project using the Xero php SDK API absolutely fine, but when I am trying to use the same ...
0
votes
2
answers
245
views
Xero custom integration app - node sdk requests failing with 403
I'm trying to set up a custom integration for my Xero organisation account, and I'm busy building it with the Demo Company. We have purchased a subscription for the actual organisation which will be ...
0
votes
0
answers
42
views
How to download raw file content using nodejs express
I am currently trying to download a file from XERO intrgrated software I am getting the response from xero but I dont know how to save or download the raw file content. I am using the xero API ...
0
votes
1
answer
44
views
How to identify Current year earning row in Xero response
I am using calling https://api.xero.com/api.xro/2.0/Reports/ endpoint to get the balance sheet report. Now from the response I need to pick the "Net income" row which is called "Crrent ...
0
votes
0
answers
211
views
Xero If-Modified-Since filter doesn't work
I tried to filter budget and set the http request header ('If-Modified-Since') with a future datetime. I still get all budget rather than the empty. Can anybody help me with the issue?
var client = ...
0
votes
1
answer
142
views
How do I send PDF Attachment/sender a copy when using Xero Invoice/:id/Email endpoint?
When sending an Invoice using the Invoice/:id/Email endpoint, I am hoping to be able to attach a PDF copy of the invoice and optionally send a copy to the invoice sender. In the UI, both of these ...
1
vote
1
answer
515
views
which Xero API to Use to Get Account Transaction Data?
I am looking for this API which will return this report data. Does Xero providing any API for same. If yes then please let me know the API details for this.
I am looking for this API which will return ...
1
vote
1
answer
489
views
How to resolve "403 Forbidden" error when trying to delete payment information in Xero API?
I am working on a project where I need to update the status of a payment invoice in Xero API to "VOIDED" and delete the associated payment information. However, when I attempt to delete the ...
0
votes
1
answer
20
views
Xero credential refresh happening in postman background but not via requests
I have a question, what are the headers it passes in the postman background when i click refresh for exprired Oauth bearer token? I need to replicate that to a Python request function
This function is ...
1
vote
1
answer
300
views
Xero Upload Invoice file using API
I am trying to upload a file to an existing invoice and running into nothing but problems using the API. I can GET the files OK so my authentication is all OK. Below is my test code and result just ...
0
votes
1
answer
65
views
Xero Accounting API adding a repayment to an AR client which has no existing entry to match to - seems impossible
I am trying to add a repayment to a client which does not match to any existing invoice, credit or prepayment (weird I know but its what my customer is asking for - it will get journalled off later on ...
0
votes
1
answer
60
views
Postman Xero API - no organisational data?
I work for a lending company and I am trying to use the Xero API to pull data out of our customers balance sheets.
I am following the postman api instructions posted by Xero, but during the ...
-3
votes
1
answer
147
views
How to perform a XERO API query within MAKE.com
Using MAKE.com, I need to feed a given Google Sheets with a table, where rows represent Journal Lines in Manual Journals from XERO. However, I only need Journal Lines associated to a given set of ...
0
votes
1
answer
294
views
Get all transactions associated with an expense account
I'm new to Xero and the Xero data model but essentially I'm looking to fetch the "Chart of accounts" data via the Xero API. I need to find all transactions allocated to each expense account, ...
0
votes
2
answers
456
views
Need all scope access for Xero Standard Web APP
We created a XERO Web App (Standard web application) and while executing the authorization token API we are getting on below scopes:
"scope": "app.connections marketplace.billing"
...
0
votes
0
answers
92
views
Xero API SocketTimeoutException
I am facing below issue while fetching data from Xero.
javax.ws.rs.ProcessingException:java.net.SocketTimeoutException: SocketTimeoutException invoking
https://api.xero.com/api.xro/2.0/Payments?page=1:...
2
votes
0
answers
78
views
How To Recreate Xero's Asset Depreciation Schedule
We are attempting to recreate Xero's asset depreciation schedule from scratch using information available from the Xero API.
The main problem that we are facing is that the depreciation rate can ...
0
votes
2
answers
993
views
Get access token for Xero with API calls
I created account without verification via auth app on a phone, because with that I wont be able to automate it.
So first I followed this instruction here
What I did is:
Step 1: Generated link just ...
0
votes
0
answers
54
views
Post New Contact: Xero changes name field when contains 2 spaces
When posting a new contact to the Api Endpoint for Contacts (repeated in the API Explorer), Xero changes the name field when it contains two consecutive spaces.
This appears to be unexpected behaviour....
-2
votes
1
answer
220
views
Getting unexpected validation error "Account must be valid/Tax rate must be valid"
I am trying to make this request through Xero API Explorer
https://api-explorer.xero.com/accounting/invoices/createinvoices?query-unitdp=4
{
"Invoices": [
{
"Type": &...
0
votes
1
answer
180
views
Xero API: Not Retrieving Full Contact Details with Invoices Endpoint
Hi I dont know if something wrong with my code but When I extract invoices its as if not all information is being extracted.
'm using the Xero API to extract invoice data in JSON format. While I'm ...
0
votes
1
answer
570
views
Automatic Xero refresh token update in Azure data factory
I use the Xero connector to extract data from xero API in Azure data factory. I use OAuth 2.0 config. The connection is successful but my refresh token expires every 30 minutes. Is there a way to ...
1
vote
0
answers
298
views
How do we import the complete schema of Xero in Azure data factory?
I copied data from Xero api to mySQL database using the Xero connector in Azure data factory. However, The copied data did not contain all the data columns. I read in a documentation that Xero data is ...