Xero API ODBC driver
I am looking to build a XERO ODBC driver.
Can the Xero API return custom reports?
I’m using the API explorer and would like to pull the Account Transactions standard report with 2 extra columns selected, so I save this as a custom report Account Transactions Custom, but it is always a 404 for both standard and non-standard?
“Repeating invoice status must be set to DELETED” validation exception when setting an end date on an existing Repeating Invoice via the XERO API
We’re using Xero’s Xero.NetStandard.OAuth2 package to bulk update repeating invoices for our monthly invoices to customers. Almost every function works fine, except when we try to set the Schedule.EndDate property.
OAuth 2.0 Auth URL returns error 500 for the person in charge
Using my Xero trial account with accepted invitation into our company Xero account I created Xero OAuth 2.0 app. Then I need the authorization code to be able to get tokens and have access to Xero API. I sent the Auth URL to my colleague who has permissions to grant me access to our company data so she can pass me the authorization code but the Auth URL isn’t working for her. Everything is set up correctly according to Xero YouTube videos and documentation. The URL works because when I access it, it prompts me to log in and gives me selection for an organization. But I don’t have permission to select our organization which is greyed out. My colleague is supposed to grant access to me but the link is not working for her. Please give me hint what are most common reasons for this issue. Any help is highly appreciated as we need to hurry with our internal reporting and we have lack of data when we can’t access them.
Xero API Limit Always Zero [closed]
Closed 11 hours ago.
Xero api – can’t filter credit notes by date using `where` clause
I am trying to filter credit notes by a date using ‘where’ but for some reason isn’t working it just returns all credit notes. Any idea why?
Is there a way to link GET Invoices records to GET Journals?
I would like to populate my database with records from both the GET Invoices method and the GET Journals method. I cant seem to find a common field to join this data? Thank you
Batching of Credit Note allocations in the Xero API
We have a system that will processing daily Invoices (~1) and Credit Notes (1 or 2) for several thousand Contacts. We have no problem creating these using the API as all items can be batched into one call, but if we need to allocate each credit note individually we are going to go over our API rate limits. Is there a way to batch these allocations (or better yet do the allocation when creating the Credit Note)?
Where does Xero API “TenantConsent status DENIED” error come from?
I am working on a Node application that authenticates with Xero using the xero-node SDK. I have seen an error TenantConsent status DENIED
in our logs and am trying to understand exactly what scenario would result in this error being returned. Does anyone know?