What's new in OdataLink

From OdataLink
Revision as of 21:42, 21 November 2024 by Nic (talk | contribs)
Jump to navigation Jump to search

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.12.12.106

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.
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.