What's new in OdataLink

2026.9.16.349

QuickBooks

First integration to support QuickBooks data files.

2026.9.7.344

Xero Practice Manager

Resolved a connection issue where the odata feeds to Xero Practice Manager broke on the 3rd of September when Xero enforced the requirement for the content-type header. OdataLink was using the legacy text/xml as the requested format whereas Xero required application/xml as the format.

2026.8.25.343

Models

Updated Paging By option to include Week and Day (Troubleshooting) options.

Added Default Sort option to control whether OdataLink applies the default sort when no sort is specified.

2026.8.18.335

Miscellaneous

Resolved issue with some endpoints with % symbols such as the ExecutiveSummary

2026.8.4.334

Xero

Rolled back advanced Statuses filtering on the following endpoints as it appears not to be compatible.

• Invoices

2026.7.30.333

Xero

Resolve issue with polling mechanism to not fold filters when polling in order to accurately detect changes.

Enhanced the following endpoint to support advanced Statuses filtering to increase performance.

• Invoices
• InvoicesExpanded
• InvoicesExpandedTable
• PurchaseOrders
• Quotes

2026.7.24.332

Xero

Enhanced polling mechanism to support additional endpoints.

• Accounts
• BankTransactions
• BankTransactionsExpanded
• CreditNotes
• CreditNotesExpanded
• ManualJournals
• ManualJournalsExpanded
• Payments
• PaymentsTable
• PurchaseOrders
• Quotes

2026.6.22.313

Models

Added the ability to select the OdataLink server and choose between Default, Australian or UK.

OdataLink v2026.05.22.309

Models

Added the ability to Page By Quarter.

Added the ability to poll for changes to increase performance and reduce usage.

The Developer archive type has been phased out in favour of a Developer Option can be turned on as part of the Live (with archive) archive type. This was done to simplify the archive type and allow you to toggle the developer setting without losing other configuration options.

Miscellaneous

New Usage tab included to line up with the fair use policy. This has been added to the account, model, data file and user pages.

OdataLink v2026.04.10.306

Xero

Fix for the Xero Assets Endpoint: Assets to resolve issue with paging.

Fix for the Xero Accounting Endpoint: CreditNotesExpandedTable to resolve issue with the ContactUID and ContactName fields coming through as null.

Miscellaneous

Primed codebase to support new mailing list notification (not yet active though).

OdataLink v2026.03.25.303

Odata Feeds

Resolved issue with parsing nulls to ensure they are returned as 0 from Profit and Loss, Balance Sheet and Trial Balance endpoints.

OdataLink v2026.03.23.301

Xero Practice Manager (XPM)

Added the following endpoints for Xero Practice Manager (XPM).

• CustomFields
• GetCustomFieldsClient
• GetCustomFieldsContact
• GetCustomFieldsJob
• GetCustomFieldsJobTask
• GetCustomFieldsTime

OdataLink v2026.03.10.300

Odata Feeds

Enhanced request queueing mechanism to better support concurrent calls to the same data.

Enhanced to provide poll for changes mechanism.

Enhanced logging mechanism to provide more information.

OdataLink v2026.01.22.298

MYOB

Enhanced how to attach MYOB data file to support new scopes requirements from MYOB.

Xero

Enhanced how to attach Xero data file to line up process with MYOB.

OdataLink v2026.01.15.297

Odata Feeds

Enhanced to track usage as required by Xero.

OdataLink v2025.12.05.295

Odata Feeds

Enhanced logging to use temp folder mechanism before uploading to cloud to reduce costs and collate as many entries in one go as possible. This change is to ensure the costs of logging are managed and to keep the cost of the service down. This will cause up to a 30 seconds delay before logs appear in app.odatalink.com

OdataLink v2025.11.27.293

Model

Added the ability to clone a model.

Enhanced screen that list endpoints to show the date last used.

Xero

Added notification that the ExpenseClaims and GetExpenseClaimDetail endpoints are being removed by Xero.

OdataLink v2025.10.21.288

Miscellaneous

Small enhancements to subscription process.

OdataLink v2025.10.8.286

Xero

Reverted Quotes endpoint to not use the Page Size option as it appears Xero's API doesn't support it.

Added the GetInvoiceUrl endpoint.

OdataLink v2025.10.2.285

Xero

Enhanced handling of the 5 concurrent calls limitation of Xero when timeouts occur.

OdataLink v2025.10.1.283

MYOB

Changed the default Page Size to 1000 records.

Xero

Changed the default Page Size to 1000 records for Xero Accounting Models.

Enhancement to the PurchaseOrders endpoint for Xero to support filtering.

Enhancement to the Quotes endpoint for Xero to support filtering.

Odata Feeds

Detection of most recent logs has been improvement so that the logs page defaults correctly.

OdataLink v2025.9.18.281

Odata Feeds

Major improvements and changes to the error handling archicture such that OdataLink will return the error message to Excel and Power BI to parse.

Major improvements to the authentication process for OdataLink such that Power BI and Excel should prompt for login details more reliably.

Some slight improvement to the logging system to resolve issues introduced in the august update.

OdataLink v2025.9.3.280

Xero

Added additional endpoints for Xero for Azure Data Factory, SSIS, Solver and Tableau compatibility.

CreditNotesExpandedTable

CreditNotesTable

OdataLink v2025.8.15.273

Odata Feeds

Major improvements and changes to the logging architecture.

OdataLink v2025.7.30.271

MYOB

Added a new LineIndex field to the JournalTransactions, JournalTransactionsTable and JournalTransactionsHistory endpoints.

Xero

Applied a hot fix to resolve issues in the ContactsExpandedTable relating to area codes, country code and balances.

OdataLink v2025.7.4.270

Xero Payroll (NZ)

Applied fix to the EmployeesTaxDetails to resolve date format issue for kiwiSaverOptOutDate, kiwiSaverContributionHolidayEndDate and studentLoanAsAt.

OdataLink v2025.6.19.269

Models

Added (and exposed) the OData Client Compatibility option to the models. The (Auto Detect) mechanism is how OdataLink operated but now a specific mechanism can be chosen for each model.

OdataLink v2025.6.4.268

Xero

Updated the Xero Accounting Endpoint: BatchPayments endpoint to include new fields.

Account.CurrencyCode

Payments.BankAmount

Payments.Invoice.CurrencyCode

OdataLink v2025.5.27.266

Odata Feeds

Major enhancements to the archiving mechanism to move towards provisioning servers in other regions.

OdataLink v2025.4.23.263

MYOB

Resolved issue with the ProfitAndLossSummaryReportMultiPeriodTable and BalanceSheetSummaryReportMultiPeriodTable endpoints to list fields in the correct order and default the use the model default date range if parameters are not specified.

OdataLink v2025.4.8.262

MYOB

Resolved issue with the JobsTable endpoint for MYOB to have fields appearing in the correct order to match the schema which is required for Solver to work correctly.

OdataLink v2025.4.4.261

MYOB

Enhanced the following endpoints to include the Status field.

SalesAllQuotes

SalesItemQuotes

SalesMiscellaneousQuotes

SalesProfessionalQuotes

SalesServiceQuotes

SalesTimeBillingQuotes

Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.

PurchasesAllInvoicesTable

SalesAllInvoicesTable

SuppliersTable

OdataLink v2025.4.3.260

MYOB

Resolved issue with the GeneralJournalsTable to ensure the LineAccountNumber comes through correctly.

Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.

JobsTable

ReceiveMoneyTransactionsTable

SpendMoneyTransactionsTable

OdataLink v2025.3.28.259

MYOB

Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.

AccountsTable

GeneralJournalsTable

Xero

Enhanced some CreditNotesExpanded, InvoicesExpanded and InvoicesExpandedTable to include 4 decimal places for line unit price.

Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.

ContactsExpandedTable

OdataLink v2025.3.19.256

Consolidation

Enhanced consolidation odata feeds to support filtering by data files for flattened table endpoints.

OdataLink v2025.3.12.254

Xero

Resolved issue with the BudgetsAmounts endpoint when requesting data for a single month. It was not capping to a single month but to a full year.

OdataLink v2025.3.11.253

Models

Renamed the Live (with Archive) archive type from Live to be explicit that it includes an archive.

Enhanced the Live (with Archive) archive type to include the Cut Off Date settings.

OdataLink v2025.2.25.251

Xero

Resolved issue with the BudgetsAmounts endpoint to accept and handle requesting more than 1 years worth of data.

If the start date or end date parameters are omitted from the BudgetsAmounts, it will now use the Default Date Range of the model.

OdataLink v2025.2.12.249

OData Feeds

Important fix to the Archive Paging algorithm to resolve issue with MYOB and race condition where some months or years would get skipped if MYOB was particularly slow at returning data.

Subscription

Enhanced Account / Subscription page to allow users to select the user that will receive invoices.

OdataLink v2025.2.4.248

Firewall

Major enhancements to the OdataLink Firewall.

OdataLink v2024.11.22.246

Xero Practice Manager

Updated schema to add 2 missing fields to the ClientsDetails endpoint.

OdataLink v2024.11.20.244

Xero

Fixed minor session logging issue relating to Journals when filtering by journal number.

OdataLink v2024.11.14.243

Xero

Added the ability to sign in with Xero and launch OdataLink from within Xero itself.

OdataLink v2024.11.7.242

Xero

Updated Xero Payroll error handling to not error out when requesting data for incompletely setup employees. In these cases, Xero returned an error but for the purpose of OdataLink we will now treat it as not having any data instead of being error 99999.

Functions

Updated function parameter parsing to convert years without millennium to be based on the year 2000 (e.g. 24-01-01 will be treated as 2024-01-01).

Updated function parameter parsing to convert financial years without millennium to be based on the year 2000 (e.g. FY 24 will be treated as FY 2024).

Free Edition

Applied fixes to a loophole in the free edition that would allow it to be used.

OdataLink v2024.11.6.239

Xero Practice Manager

Added Xero Practice Manager Models and Xero Practice Manager Endpoints.

Xero

Added LineItemID to the CreditNotesExpanded endpoint.

Fixed issue with the AssetsExpanded not working as intended.

OdataLink v2024.10.23.238

Xero

Added the ExpenseClaims and GetExpenseClaimDetail for Xero.

Added the ability to filter the Projects endpoint by projectId, contactId and status.

OdataLink v2024.9.30.233

MYOB

Work through fixes to resolve the constant reauthorising issue raised by the latest MYOB API update.

OdataLink v2024.9.26.232

MYOB

Work through fixes to resolve the constant reauthorising issue raised by the latest MYOB API update.

OdataLink v2024.9.25.231

MYOB

Work through fixes to resolve the constant reauthorising issue raised by the latest MYOB API update.

Enhanced logs to itemise when tokens are reauthorised.

Xero

Enhanced logs to itemise when tokens are reauthorised.

OdataLink v2024.9.19.230

MYOB

Work through fixes to resolve the constant reauthorising issue raised by the latest MYOB API update.

OdataLink v2024.9.10.227

Xero

Resolved bug with filtering the RemainingCredit field in the Overpayments and OverpaymentsExpanded endpoints.

OdataLink v2024.9.5.225

Xero

Added the BalanceSheetByTrackingOption and BalanceSheetAdvanced functions to Xero Accounting Models.

Added the GetTasks and GetTimes functions to Xero Projects Models.

Resolved issues with the ProfitAndLossByMonth for those whose financial year ends on a month with less than 31 days.

OdataLink v2024.8.28.224

Models

Added the new Archive Paging settings to model to control how the data is paged by MYOB or Xero.

Cosmetic changes to the models page.

Xero

Added a new error code to support the new High Volume Threshold Limit restrictions from Xero.

Enhanced endpoints to support the ifmodifiedsince header.

Logs

Updated the formatting of the urls in the logs to make them easier to read.

OdataLink v2024.8.15.222

Xero

Added the PaymentsTable endpoint for Xero.

Added the following history and notes endpoints for Xero.

GetHistoryBankTransaction

GetHistoryBatchPayment

GetHistoryContact

GetHistoryCreditNote

GetHistoryInvoice

GetHistoryItem

GetHistoryManualJournal

GetHistoryOverpayment

GetHistoryPayment

GetHistoryPrepayment

GetHistoryPurchaseOrder

GetHistoryQuote

GetHistoryRepeatingInvoice

Enhancements

Added mandatory fields tooltip to various pages.

Added credit card migration process for those still paying via the older payment gateway.

OdataLink v2024.8.8.221

MYOB

Fixed connection issues with MYOB after recent MYOB update on 08/08/2024.

OdataLink v2024.7.24.219

Enhancements

Major performance improvements to enhance the speed at which data is provided.

OdataLink v2024.7.2.212

Azure Data Factory

Applied enhancements to OData Feeds for for Azure Data Factory to ensure functions can be used as Entity Sets instead.

Applied enhancements to OData Feeds for Azure Data Factory to ensure Dates, DatesByMonth and DatesByYear endpoint are compatible.

OdataLink v2024.5.31.209

MYOB

Hot fix to the AccountRegister, CategoryRegister and JobRegister endpoints to resolve performance issue that requested too much data.

OdataLink v2024.5.22.209

Xero

Updated LeaveApplications endpoint for Payroll (AU) to use v2 that provides access to REQUESTED and REJECTED leave applications.

OdataLink v2024.5.20.208

Xero

Applied fixes to the Invoices endpoint to remove optimised filtering as Xero confirmed they are not compatible with unpaged endpoints.

Applied fixes to the parsing odata feed urls when identifying optimised filters.

OdataLink v2024.5.16.207

Xero

Enhanced the Invoices, InvoicesExpanded, InvoicesExpandedTable endpoints to have optimised filters for Status column as per Xero recommendation.

Enhanced the CreditNotesExpanded, InvoicesExpanded and RepeatingInvoices endpoints to include additional Item field.

Enhanced the InvoicesExpandedTable endpoint to include additional LineID, LineItemID, LineItemCode and LineItemName field.

Enhanced parsing algorithm when parsing odata feed urls.

OdataLink v2024.5.8.203

Fixes

Applied fix for the Dates, DatesByMonth and DatesByYear to always create 3 future or historical year if no start date specified.

Applied fix for the JournalsAccrual, JournalsAccrualTable, JournalsCash to fix bug raised in recent updates that did not filter data correctly.

Applied fox for the BankSummary endpoint to include the FXGainLossAmount and parse all columns correctly whether they are present or not.

Applied fox for the ProfitAndLossByMonth to increase performance when parsing columns.

Applied fix for many functions to ensure they parse the data correctly.

OdataLink v2024.5.6.202

MYOB

Updated the AccountRegister, CategoryRegister and JobRegister endpoints to included TotalAmount as the sum of all actitivy and adjustment values.

Updated the AccountRegister, CategoryRegister and JobRegister endpoints to allow filtering by DatesByMonthID field.

OdataLink v2024.5.1.200

MYOB

Added two new endpoints for MYOB: ProfitAndLossSummaryReportMultiPeriodTable and BalanceSheetSummaryReportMultiPeriodTable. These have been added to make it easier to create Profit and Loss and Balance Sheet reports.

Enhanced the AccountBudgets endpoint for MYOB to include the DatesByMonthID field.

Enhanced the Dates, DatesByMonth and DatesByYear to allow filtering them in order to dynamically generate the dates needed for your report.

Xero

Enhanced the Dates, DatesByMonth and DatesByYear to allow filtering them in order to dynamically generate the dates needed for your report.

Miscellaneous

Architectural changes to the Odata feeds engine to increase performance.

OdataLink v2024.3.12.190

Xero

Applied fix to BankTransactionsExpanded, ContactsExpanded, CreditNotesExpanded, ManualJournalsExpanded, OverpaymentsExpanded, RepeatingInvoices to ensure Xero provides all fields.

OdataLink v2024.2.13.187

Released on 06/02/2024.

New Functionality

Added support for Two-Factor Authentication via Authenticator APPS (Google Authenticator, Authy, FreeOTP and others).

Fixes

Resolved issues with the TrackingCategories endpoint of the Xero Payroll (AU) model when tracking categories are not setup for both the Employee Groups and Timesheet Categories settings in Xero.

OdataLink v2024.2.6.186

Released on 06/02/2024.

Fixes

Changing the billing user will prompt to transfer to latest payment gateway if needed.

OdataLink v2024.2.1.184

Released on 01/02/2024.

Fixes

Fixed an issue with the firewall which couldn't allow calls made with proxy servers that used a mix of IPv4 AND IPv6. They would always get rejected.

Fixed an issue with MYOB to support large data sets using GZIP,DEFLATE.

OdataLink v2024.1.19.182

Released on 19/01/2024.

New Functionality

Added the ability to manage email notifications.

Xero

Resolved issues with the JournalsAccrual endpoint when filtering out all data.

OdataLink v2023.12.20.178

Released on 20/12/2023.

MYOB

Added the JournalTransactionsHistory endpoint for MYOB which provides an audit trail of when transactions were added, edited or deleted.

OdataLink v2023.12.19.177

Released on 19/12/2023.

Xero

Added the Xero Payroll (UK) Models to Xero.

OdataLink v2023.10.26.167

Released on 26/10/2023.

Xero Accounting

Added the AccountID field to the following endpoints: CreditNotesExpanded, InvoicesExpanded, InvoicesExpandedTable and RepeatingInvoices.

Added the GetImage endpoint to allow downloading image logos into Power BI.

Miscellaneous

Enhanced parsing of URL to support the GetImage endpoint.

OdataLink v2023.10.20.166

Released on 20/10/2023.

Xero Accounting

Applied a fix for JournalsAccrual, JournalsAccrualTable and JournalsCash where the archive data and optimisation table could get corrupt in specific situations.

OdataLink v2023.10.13.164

Released on 13/10/2023.

Xero Payoll (AU)

Applied a Hotfix to the EmployeesExpanded endpoint of the Xero Payroll (AU) model to ensure the latest data is always retrieved regardless of the UpdatedDateUTC timestamp.

Miscellaneous

Enhanced subscription process.

Enhanced performance regarding tracking stats applicable to the Free Edition.

Resolved bugs regarding tracking stats applicable to the Free Edition.

OdataLink v2023.08.29.151

Released on 29/08/2023.

Xero

Resolved issues with the Xero Projects Endpoint: Tasks and Xero Projects Endpoint: Times endpoint of the xero projects model.

Resolved preview issues with the JournalsAccrual, JournalsCash and JournalsAccrualTable.

Email Notifications

Added email notification when a data file needs to be reauthorised.

Updated email notification regarding Power BI (cloud) IP addresses.

OdataLink v2023.08.17.150

Released on 17/08/2023.

Odata Feeds

Improved performance of Xero JournalsAccrual, JournalsCash and JournalsAccrualTable.

Improved performance of Xero Projects Tasks and Times.

OdataLink v2023.08.01.148

Released on 01/08/2023.

Email Notifications

Added email notification when the model's archive type is set to developer.

Added email notification when the model's default end date will start cutting off current data.

Added email notification when the model's default start date is very old to warn about possible increase in performance.

OdataLink v2023.07.25.144

Released on 25/07/2023.

Preview

Resolved issues preventing the preview of data on the website from working.

Logs

Enhanced logs to allow to however over error number.

OdataLink v2023.07.17.143

Released on 17/07/2023.

Archive

Released an update to the archive to increase performance and support multiple regions.

OdataLink v2023.06.29.142

Released on 29/06/2023.

MYOB

Resolved issue with rounding numbers, specifically for exchange rates.

Xero

Resolved issue with rounding numbers, specifically for exchange rates.

Added AccountsTable endpoint for Xero.

Added InvoicesExpandedTable endpoint for Xero.

Added ItemsTable endpoint for Xero.

Added TaxRatesTable endpoint for Xero.

Added TrackingCategoriesTable endpoint for Xero.

OdataLink v2023.06.22.141

Released on 22/06/2023.

MYOB

Resolved issue with DateBeforeConversion error preventing consolidation odata feeds from working.

OdataLink v2023.06.02.137

Released on 02/06/2023.

Xero

Applied fix for Xero Accounting Endpoint: JournalsAccrualTable to ensure all data downloads when invalid journals exists in data set.

OdataLink v2023.05.29.136

Released on 29/05/2023.

Subscriptions

Tweaked the 'Free Edition' to make it easier to disable endpoints.

Resolved issue when updating subscription or CC to unsuspend accounts.

OdataLink v2023.05.23.135

Released on 23/05/2023.

Security

Enhanced security in OdataLink.

Enhanced login to require Multi-Factor Authentication (2FA).

OdataLink v2023.04.18.129

Released on 19/04/2023.

Xero

Added additional BalanceSheetMultiPeriodTable for Xero.

OdataLink v2023.04.06.127

Released on 6/04/2023.

Xero

Enhanced AccountsClass, AccountsTypes, AccountsTotals for Xero to include VarianceImpactSign field.

OdataLink v2023.3.31.125

Released on 31/03/2023.

Tableau

Enhanced support for Tableau and functions so that they are listed (defined as Entity Sets)

Enhanced support for Tableau and functions to work with an alternate syntax to support nextpagelink for tableau.

OdataLink v2023.3.27.123

Released on 27/03/2023.

Xero

Added additional ProfitAndLossMultiPeriodTable for Xero.

Added additional AccountsTypes for Xero.

Added additional AccountsTotals for Xero.

Updated Accounts endpoint to include additional system accounts for FXGROUPID and CE that are present on ProfitAndLoss and BalanceSheet reports but not in the chart of accounts.

Updated internal variables handling engine to support new Accounts.

Updated all ProfitAndLoss and BalanceSheet endpoints to include AccountID for FXGROUPID and CE.

Note that this functionality was not added to the TrialBalance endpoint as that ones breaks down the values between Realised and Unrealised Currency Gains and losses.

OdataLink v2023.3.16.119

Released on 16/03/2023.

OData Feeds

Enhanced to download data from Xero if decrypting archived data fails.

Reengineered handling of function parameters to support new ProfitAndLossMultiPeriodTable for Xero.

OdataLink v2023.3.2.118

Released on 02/03/2023.

Models

Streamlined user interface to use tabs to make it easier to navigate.

Added options to allow all data files, endpoints, ip address and users

Data Files

Streamlined user interface to use tabs to make it easier to navigate.

OdataLink v2023.2.22.117

Released on 22/2/2023.

MYOB

Added a new BalanceSheetSummaryReportTable endpoint.

Added a new ProfitAndLossSummaryReportTable endpoint.

OdataLink v2023.2.21.116

Released on 22/2/2023.

Subscription

Finally resolved an issue with our payment gateway to not struggle with addresses with non-english characters.

OdataLink v2022.12.15.107

Released on 15/12/2022.

MYOB

Added a new InventoryBuildTransactions endpoint.

OdataLink v2022.7.3.82

Released on 14/07/2022.

MYOB

Added a new AccountsTotals endpoint to simplify creating Profit and Loss and Balance Sheet reports.

OdataLink v2022.7.1.80

Released on 06/07/2022.

Xero

Enhanced performance of the JournalsAccrual and JournalsCash endpoints.

Enhanced filtering of the JournalsAccrual and JournalsCash endpoints.

Enhanced handling of Xero Tokens.

OdataLink v2022.6.5.77

Released on 15/06/2022.

Xero

Enhanced algorithm to handle concurrent calls and reduce the likelyhood of Error 9006.

OdataLink v2022.5.4.69

Released on 25/05/2022.

MYOB

Added BillOfMaterials to Items for MYOB.

OdataLink v2022.5.3.68

Released on 06/05/2022.

Xero

Fixed financial year issue for ProfitAndLossByMonth for businesses ending in month with 31-days.

OdataLink v2022.5.2.67

Released on 04/05/2022.

Xero

Fixes for reports based endpoints.

OdataLink v2022.3.3.63

Released on 21/03/2022.

Xero

Enhanced JournalsAccrual and JournalsCash to increase performance on first call.

Enhanced JournalsAccrual and JournalsCash to support filtering by JournalDate.

Enhanced JournalsAccrual and JournalsCash to support Incremental Refresh in Power BI.

Fixed issues with the BudgetSummaryByMonth not returning the correct months for a given financial year.

Miscellaneous

Enhanced performance of the archive.

OdataLink v2022.3.2.62

Released on 08/03/2022.

Miscellaneous

Updated register form to have additional details.

Updated register process to create correct type of model based on register form fields.

Updated subscription form to show credit cards accepted.

Updated subscription form to automatically select billing admin.

Updated subscription form to now allow selecting billing admins that have not confirmed their emails.

Updated cancel subscription to notify admins.

Updated 2FA trust this this device to last 30 days.

Updated no 2FA to notify of login attempts from new device.

OdataLink v2022.3.1.61

Released on 02/03/2022.

Miscellaneous

Added additional validation for credit cards when subscribing.

OdataLink v2022.2.6.60

Released on 28/02/2022.

MYOB

Created a retry mechanism for MYOB if rate limit is exceeded.

Miscellaneous

Various fixes when subscribing or updating your odatalink subscription.

OdataLink v2022.2.5.59

Released on 23/02/2022.

Miscellaneous

Fixed issue with subscription where users could choose a edition price but select less data files.

OdataLink v2022.2.4.58

Released on 21/02/2022.

Xero

Fixed issue with Xero Accounting Endpoint: JournalsAccrual and Xero Accounting Endpoint: JournalsCash endpoints taking a while to download data when the Default Start Date is specified.

OData Feeds

Fixed issue with $orderby clause and schema to ensure it is used only when applicable.

Fixed issue with $orderby clause for consolidation.

Miscellaneous

Fixed issue when creating new account failing for some customers relating to Account Code generation.

OdataLink v2022.2.3.57

Released on 14/02/2022.

Miscellaneous

Adding a new data file with licenses to spare will automatically license it.

Subscribing will automatically assign spare licenses.

OdataLink v2022.2.2.56

Released on 07/02/2022.

MYOB

Enhanced performance by storing optimal MYOB server.

OdataLink v2022.2.1.55

Released on 01/02/2022.

Xero

Added the Xero Payroll (New Zealand) Models to Xero.

Added the GetPayRun endpoint to Xero Payroll (Australia) Models.

Added the GetPayslip endpoint to Xero Payroll (Australia) Models.

Added the Xero Accounting Endpoint: AgedReceivablesByContact endpoint to Xero Accounting Models.

Added the Xero Accounting Endpoint: AgedPayablesByContact endpoint to Xero Accounting Models.

MYOB

Added the CustomLists endpoint to MYOB Models.

Updated the Sales endpoints CustomerInvoiceNumber field to be 255 characters long.

Updated the Purchases endpoints SupplierInvoiceNumber field to be 255 characters long.

Updated the InventoryAdjustments to include the Location field.

OdataLink v2021.12.2.54

Released on 15/12/2021.

Miscellaneous

Added extend trial button to Accounts / Subscription page.

Added help urls when assigning endpoints.

OdataLink v2021.12.1.53

Released on 08/12/2021.

Xero

Added additional Xero Accounting Endpoints.

• ProfitAndLossAdvanced
• ProfitAndLossByTrackingCategory
• ProfitAndLossByTrackingOption

Security

Added user-based IP Addressses for ease of updating the Firewall when using dynamic IP Addresses.

Added system-based IP Addressses for ease of updating the Firewall when using Power BI.

Added option to Trust Device for 5 days when logging in and using Two-Factor Authentication.

Added additional security when logging in from new machine and not using Two-Factor Authentication.

Miscellaneous

Added Select All /Select None button when assigning IP Addresses to Models.

Added Refresh button on Odata Feeds Log screen.

Added ability to request a trial extension.

Bug Fixes

Fixed issues with Subscription.

Fixed issues with updating Credit Card details.

OdataLink v2021.11.7.51

Miscellaneous

Enhanced performance.

Enhanced pages to allow changing accounts easier when needed.

OdataLink v2021.11.4.48

OData Feeds

Enhanced metadata document to resolve error 1004.

Resolved issue with consolidation and static data.

OdataLink v2021.11.3.47

OData Feeds Logs

Enhanced performance of the logs.

OdataLink v2021.11.2.46

OData Feeds Logs

Enhanced performance of the logs.

OdataLink v2021.10.3.43

Released on 31/10/2021.

OData Feeds

Added new Consolidation Endpoints functionality to simplify consolidating data from multiple data files.

OData Feeds Logs

Enhanced logs screen to collapse all requests into sessions for ease of audit.

Enhanced log screen to allow drilldown through requests.

Enhanced and optimised logging mechanism to be more efficient.

Models

Added options to manage the new Consolidation Endpoints functionality

Endpoints

Added new Endpoint: DataFiles to provide a table of data files.

OdataLink v2021.9.2.40

Released on 30/09/2021.

Models

Added new Settings Endpoints functionality to allow download of OdataLink settings and configuration.

Added a new option to all Models to enable OData access to the settings endpoints for the models.

Xero

Added Narrative and Particulars to BatchPayments endpoints.

Added LeaveLoadingRate to PayItemsLeaveTypes endpoints.

Enhanced the performance of the JournalsAccrual and JournalsCash endpoints

Firewall

Enhanced Firewall to support Proxy Servers.

Miscellaneous

Removed sorting of columns on most webpages of app.odatalink.com as it didn't work.

OdataLink v2021.9.1.39

Released on 07/09/2021.

Xero

Added the following endpoints to Xero Accounting Models.

Budgets

BudgetsAmounts

OdataLink v2021.8.4.38

Released on 23/08/2021.

Xero

Added the following endpoints to Xero Accounting Models.

DatesByYear

Added missing LineOfBusiness field to Organisation endpoint for Xero.

Added missing SentToContact field to PurchaseOrders endpoint for Xero.

MYOB

Added the following endpoints to MYOB Models.

DatesByYear

OdataLink v2021.8.3.37

Released on 17/08/2021.

Xero

Added the following endpoints to Xero Payroll (Australia) Models.

LeaveApplications

Timesheets

OdataLink v2021.8.1.35

Released on 03/08/2021.

Models

Added a new archive type of Static that downloads the data once and caches it.

Added a new option for MYOB models that controls the number of records retrieved per request for large data files that struggled with the default value.

Added a new Model Type of Xero Payroll (Australia) to download payroll information from Australian Xero Organisations.

MYOB

Added the following endpoints to MYOB Models.

AccountsClassifications

Xero

Added the following endpoints to Xero Projects Models.

Tasks

Times

Added the following endpoints to Xero Payroll (Australia) Models.

Accounts

Employees

EmployeesExpanded

PayItems

PayItemsDeductionTypes

PayItemsEarningsRates

PayItemsLeaveTypes

PayItemsReimbursementTypes

PayrollCalendars

PayRuns

PayRunsExpanded

Payslips

Settings

SuperFunds

TrackingCategories

OdataLink v2021.6.3.30

Released on 23/06/2021.

Data Files

Added the Reauthorise button to the data file screen to simplify the process of reauthorising access.

OdataLink v2021.6.2.29

Xero

Applied new Keys.

Added Sign Up with Xero process.

OData Fees

Added rule to soft-reject the request if the $top parameter is invalid.

OdataLink v2021.6.1.28

Released on 07/06/2021.

Xero

Renamed Xero model type to Xero Accounting.

Added Xero Projects model type.

Added the following endpoints to Xero Projects Models.

Projects

Users

Added the following endpoints to Xero Accounting Models.

AccountsClass

BalanceSheet

BalanceSheetByMonth

BankSummary

BudgetSummary

BudgetSummaryByMonth

ExecutiveSummary

ProfitAndLoss

ProfitAndLossByMonth

TrialBalance

MYOB

Restructured the meta data for the following endpoints to allow for preview.

BalanceSheetSummaryReport

NZGSTReport

PayrollCategorySummaryReport

ProfitAndLossSummaryReport

TaxCodeSummaryReport

Timesheets

Miscellaneous

Enhanced function endpoints to make all parameters optional.

Enhanced platform to shape Xero reports to be useable.

Enhanced platform to support additional model types for Xero.

Enhanced platform to allow Dates and DatesByMonths to be filterable.

Enhanced Dates and DatesByMonths to have additional DisplayStrings.

OdataLink v2021.5.3.27

Free Edition

Limited the Free Edition to only be able to use 'Standard' endpoints.

Miscellaneous

Fixed issue with the date modified field not updating for accounts.

OdataLink v2021.5.2.26

Odata Feeds

Made some parameters optional on ProfitAndLossSummaryReport, BalanceSheetSummaryReport, NZGSTReport and TaxCodeSummaryReport endpoints.

Enhanced the paging for both MYOB and Xero to reduce load on our server to ensure they do not request 1000 records.

Xero

Removing a Xero data file will now also revoke access tokens to cleanly remove permissions.

Free Edition

Limited the Free Edition to a maximum of 5 endpoints.

Limited the Free Edition to not be able to create additional models.

Limited the Free Edition to not be able to remove models unless they have more than 1.

Miscellaneous

Revoking OdataLink access to a user will generate an email informing them.

Various cosmetic changes.

OdataLink v2021.5.1.25

Released on 19/05/2021.

Odata Feeds

Resolved issues with MYOB which could sometimes clear the tokens when error 500 occurred.

Miscellaneous

Resolved issues with preview of data sometimes failing second time it was used.

Resolved issues with preview of data not logging the request correctly.

Resolved issues with auto-generating AccountCode, ModelCode, DataFileCode incorrectly for some situations.

Added extra validation when creating accounts or users.

Miscellaneous changes to the user interface.

OdataLink v2021.4.3.23

Released on 20/04/2021.

Xero

Added JournalsAccrual and JournalsCash endpoints for Xero.

OdataLink v2021.4.2.22

Released on 14/04/2021.

MYOB

Resolved issues with the BalanceSheetSummaryReport Endpoint.

Xero

Resolved issues with Contacts and ContactsExpanded endpoints.

Resolved issues with Invoices and InvoicesExpanded endpoints.

Resolved issues with BankTransactions and BankTransactionsExpanded endpoints.

Resolved issues with Payments endpoint.

OdataLink v2021.4.1.21

MYOB

BalanceSheetSummaryReport Endpoint added for MYOB.

Dates and DatesByMonth endpoints added for MYOB.

AccountRegister, JobRegister and CategoryRegister include additional DatesByMonthID field.

Resolved issue where using debug mode could corrupt the archived data.

Response headers included in log to debug MYOB API errors.

Xero

Dates and DatesByMonth endpoints added for Xero.

Resolved issue with odata feeds not working sometimes when the model archive type is set to 'Developer'.

Resolved issue where using debug mode could corrupt the archived data.

Resolved issue when receiving rate-limit-exceeded error from Xero Api.

Response headers included in log to debug Xero API errors.

User Interface

Restructured the menu to have 'Accounts' section in the top-left corner.

Restructured the breadcrumbs.

Updated most data file related screens to explicitly state whether it relates to 'MYOB Data Files' or 'Xero Data Files'.

Resolved issue when adding data files and clicking the add data files button without anything selected.

Resolved issue when cancelling adding data files not returning to the page you came from.

Resolved issue when cancelling assigning data files not returning to the page you came from.

Resolved workflow issues when adding data files via the Assign Data Files button of the model screen.

Login process

Resolved issue with login process and return urls preventing the user from logging in correctly.

Resolved issue with login process and remember me checkbox not remembering the user after log out.

Registering process

Resolved workflow issue when registering and confirming emails to allow the user to login at the same time.

Resolved workflow issue when inviting and confirming emails to allow the user to login at the same time.

Resolved workflow issue when confirming emails not working sometimes.

Preview

Function type of data feeds are no longer included in the previous as they didn't work.

Free Edition

Now limited to 100,000 data points per 30-day period.

Now limited to 500 calls per 30-day period.

Now limited to 10 days of use per 30-day period.

Usage made so far is shown on Home page when using the Free Edition.

Usage made so far is shown on Home page and Subscribe page when on trial.

Free Edition can be made unavailable for specific account as our discretion.

OdataLink v2021.3.1.20

Data Files

Xero data files are now available with 30 endpoints of data available.

Models

Models now have a Data File Type to control what type of data files can be added.

Accounts

Accounts now have a Time Zone field to control how dates can be formatted.

All accounts will now automatically have a 30-day trial, including additional accounts.

Users

All user creation and edit screen now include a Time Zone field to control how dates can be formatted.

OdataLink v2021.2.3.19

Released on 24/02/2021

Home

Enhanced the home screen to list issues that need to be addressed.

Accounts

Added the Free Edition.

Models

Added an Archive Type field to speed up development.

OdataLink v2021.2.2.18

Released on 10/02/2021

OData Feeds

Performance improvement to not reject urls with $select.

Log improvements to not log errors for urls with $select.

OdataLink v2021.2.1.17

Released on 05/02/2021

OData Feeds

Added logs buttons to see the request on the odata feed in the last 30 days.

Added logs to the home screen showing all errors in the last 7 days.

OdataLink v2021.1.1.15

Released on 14/01/2021

Accounts

Additional pricing points for subscription.

Enhancements when modifying subscription.

Miscellaneous

Added new screens to separate viewing and editing models/users/data files/ip adddresses.

OdataLink v2020.11.2.14

Released on 14/12/2020

Miscellaneous

Updated the look and feel of the website.

OdataLink v2020.10.1.10

Released on 15/10/2020

Accounts

Subscriptions can now be purchased via the Accounts page.

All accounts have been issued a 30 day trial to expire on the 15th of November 2020

Users

Each user can be assigned their own time zone which will format the dates and times on the website accordingly.

OdataLink v2020.8.1.9

Released for beta testing on 07/08/2020.

Users

Added re-captcha when registering your account.

Added support for Two-Factor Authentication (2FA) when logging in.

Data Files

Data File codes will now be generated without spaces.

Feeds

Integrated with E-Tags to increase performance when getting data.

Add message when copying urls that it has been copied.

Enhanced to support urls with spaces.

OdataLink v2020.7.3.8

Released for beta testing on 09/07/2020.

Accounts

Added address fields.

When creating a new account, it will go to the Model screen once done.

Models

Enhanced creating a new model, the Default Start Date and End Date will be based on the account's country.

Added option to Enable/Disable Firewall which controls whether IP addresses must be allowed for the model or not.

Enhanced various screens to add messages when no models exist.

Data Files

Enhanced various screens to add messages when no data files exist.

IP Addresses

Enhanced various screens to add messages when no ip addresses exist.

Feeds

Enhanced OData Feeds page to have additional Assign Endpoints and Assign Data Files when a model is not fully setup.

OdataLink v2020.7.2.7

Released for beta testing on 08/07/2020.

Models

Models now have a Default Start Date and Default End Date field which controls how much data is downloaded if not filtered by date.

Default Start Date and Default End Date fields also used to filter AccountRegister, CategoryRegister, JobRegister and AccountBudgets endpoints.

Feeds

Resolved issue with scientific notation values returned by MYOB to ensure they are formatted to 6 decimal places at all times.

Resolved issue with filtering data by date to ensure filters are supported by MYOB.

OdataLink v2020.7.1.6

Released for beta testing on 01/07/2020.

Feeds

Resolved issue with all transaction endpoints failing to query.

OdataLink v2020.6.3.5

Released for beta testing on 26/06/2020.

Data Files

Resolved issue with editing data file which would show a data file as enabled when disabled.

Models

Administrators can now assign users access to specific models.

Feeds

Endpoints of type functions will no longer always appear in the list of feeds displayed in Excel or Power Bi.

Performance counters to store ip address that queried data.

Miscellaneous

Resolved issue for users with multiple accounts to remember the last active account (on the machine).

OdataLink v2020.6.2.4

Released for beta testing on 19/06/2020.

Models

Enhanced to have login type (Anonymous or Basic).

Anonymous is the existing approach that doesn't require a login to consume the data.

Basic will now require the login to be specified to get the data via odata.

Users

Users can now be basic User or Admin.

Admin can manage all the options and settings for the account as well as query data via the odata feeds.

User can only query the data via the odata feeds.

Feeds

OData Feeds page now list all feeds including disabled models and disabled data files.

OData Feeds page cosmetically changed to also highlight if feed is disabled.

OData Feeds page now includes url of data feeds.

Added performance counters to store endpoint and user that queried data.

Enhanced performance when querying data.

Miscellaneous

Added messages to the main page of OdataLink.

OdataLink v2020.6.1.3

Released for beta testing on 10/06/2020.

Accounts

Added data validation to ensure account name and code cannot be blank.

Added data validation to ensure account code is unique.

Models

Added data validation to ensure model name and code cannot be blank.

Added data validation to ensure model code is unique.

Added warnings if sections are not setup.

Data Files

Added data validation to ensure data file name and code cannot be blank.

Added data validation to ensure data file code is unique.

Adding MYOB's API Sandbox Demo will default to the correct user name and password.

Added warnings if data file not included in any model.

IP Addresses

Added new button Add Client IP Address' to screen.

Added warnings if ip address not allowed to any model.

Registration

Users can register multiple times to trigger the confirmation email being sent.

Feeds

Supplier\DisplayID will always be injected if missing for purchases and purchase order related tables.

Performance counters added for requests.

OdataLink v2020.5.2.2

Released for beta testing on 25/05/2020.

MYOB

Resolved an issue with the Account Register endpoint to include new Unit Count field.

Users

Email of newly invited users to an account will now appear on the Users screen.

FirstName and LastName of newly invited users to an account that have not confirmed their email will appear as Pending.

Help

Integrated each page with appropiate help topic when choosing Help \ Online Help.

OdataLink v2020.5.1.1

Released for beta testing on 01/05/2020.