Difference between revisions of "What's new in OdataLink"

no edit summary
 
(80 intermediate revisions by the same user not shown)
Line 1: Line 1:
= OdataLink v2025.4.8.262 =
;MYOB
:Resolved issue with the [[MYOB Endpoint: JobsTable|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.
:: [[MYOB Endpoint: SalesAllQuotes|SalesAllQuotes]]
:: [[MYOB Endpoint: SalesItemQuotes|SalesItemQuotes]]
:: [[MYOB Endpoint: SalesMiscellaneousQuotes|SalesMiscellaneousQuotes]]
:: [[MYOB Endpoint: SalesProfessionalQuotes|SalesProfessionalQuotes]]
:: [[MYOB Endpoint: SalesServiceQuotes|SalesServiceQuotes]]
:: [[MYOB Endpoint: SalesTimeBillingQuotes|SalesTimeBillingQuotes]]
:Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.
:: [[MYOB Endpoint: PurchasesAllInvoicesTable|PurchasesAllInvoicesTable]]
:: [[MYOB Endpoint: SalesAllInvoicesTable|SalesAllInvoicesTable]]
:: [[MYOB Endpoint: SuppliersTable|SuppliersTable]]
= OdataLink v2025.4.3.260 =
;MYOB
:Resolved issue with the [[MYOB Endpoint: GeneralJournalsTable|GeneralJournalsTable]] to ensure the LineAccountNumber comes through correctly.
:Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.
:: [[MYOB Endpoint: JobsTable|JobsTable]]
:: [[MYOB Endpoint: ReceiveMoneyTransactionsTable|ReceiveMoneyTransactionsTable]]
:: [[MYOB Endpoint: SpendMoneyTransactionsTable|SpendMoneyTransactionsTable]]
= OdataLink v2025.3.28.259 =
;MYOB
:Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.
:: [[MYOB Endpoint: AccountsTable|AccountsTable]]
:: [[MYOB Endpoint: GeneralJournalsTable|GeneralJournalsTable]]
;Xero
:Enhanced some [[Xero Accounting Endpoint: CreditNotesExpanded|CreditNotesExpanded]], [[Xero Accounting Endpoint: InvoicesExpanded|InvoicesExpanded]] and [[Xero Accounting Endpoint: InvoicesExpandedTable|InvoicesExpandedTable]] to include 4 decimal places for line unit price.
:Added additional flat-tables to assign with Azure Data Factory, Tableau, SSIS and Solver.
:: [[Xero Accounting Endpoint: ContactsExpandedTable|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 [[Xero Accounting Endpoint: BudgetsAmounts|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 Types|archive type]] from '''Live''' to be explicit that it includes an archive.
:Enhanced the '''Live (with Archive)''' [[Archive Types|archive type]] to include the Cut Off Date settings.
= OdataLink v2025.2.25.251 =
;Xero
:Resolved issue with the [[Xero Accounting Endpoint: BudgetsAmounts|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 [[Xero Accounting Endpoint: BudgetsAmounts|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 [[Selecting the user that will receive invoices|select the user that will receive invoices]].
= OdataLink v2025.2.4.248 =
;Firewall
:Major enhancements to the [[Configuring IP addresses|OdataLink Firewall]].
= OdataLink v2024.11.22.246 =
;Xero Practice Manager
:Updated schema to add 2 missing fields to the [[Xero Practice Manager Endpoint: ClientsDetails|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 [[Xero Accounting Endpoint: CreditNotesExpanded|CreditNotesExpanded]] endpoint.
:Fixed issue with the [[Xero Projects Endpoint: AssetsExpanded|AssetsExpanded]] not working as intended.
= OdataLink v2024.10.23.238 =
;Xero
:Added the [[Xero Accounting Endpoint: ExpenseClaims|ExpenseClaims]] and [[Xero Accounting Endpoint: GetExpenseClaimDetail|GetExpenseClaimDetail]] for Xero.
:Added the ability to filter the [[Xero Projects Endpoint: Projects|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 [[Xero Accounting Endpoint: Overpayments|Overpayments]] and [[Xero Accounting Endpoint: OverpaymentsExpanded|OverpaymentsExpanded]] endpoints.
= OdataLink v2024.9.5.225 =
;Xero
:Added the [[Xero Accounting Endpoint: BalanceSheetByTrackingOption|BalanceSheetByTrackingOption]] and [[Xero Accounting Endpoint: BalanceSheetAdvanced|BalanceSheetAdvanced]] functions to [[Xero Accounting Models]].
:Added the [[Xero Projects Endpoint: GetTasks|GetTasks]] and [[Xero Projects Endpoint: GetTimes|GetTimes]] functions to [[Xero Projects Models]].
:Resolved issues with the [[Xero Accounting Endpoint: ProfitAndLossByMonth|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 [[OdataLink Error Code 9008: Xero imposed a limit of 100,000 records per request|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 [[Xero Accounting Endpoint: PaymentsTable|PaymentsTable]] endpoint for Xero.
:Added the following history and notes endpoints for Xero.
::[[Xero Accounting Endpoint: GetHistoryBankTransaction|GetHistoryBankTransaction]]
::[[Xero Accounting Endpoint: GetHistoryBatchPayment|GetHistoryBatchPayment]]
::[[Xero Accounting Endpoint: GetHistoryContact|GetHistoryContact]]
::[[Xero Accounting Endpoint: GetHistoryCreditNote|GetHistoryCreditNote]]
::[[Xero Accounting Endpoint: GetHistoryInvoice|GetHistoryInvoice]]
::[[Xero Accounting Endpoint: GetHistoryItem|GetHistoryItem]]
::[[Xero Accounting Endpoint: GetHistoryManualJournal|GetHistoryManualJournal]]
::[[Xero Accounting Endpoint: GetHistoryOverpayment|GetHistoryOverpayment]]
::[[Xero Accounting Endpoint: GetHistoryPayment|GetHistoryPayment]]
::[[Xero Accounting Endpoint: GetHistoryPrepayment|GetHistoryPrepayment]]
::[[Xero Accounting Endpoint: GetHistoryPurchaseOrder|GetHistoryPurchaseOrder]]
::[[Xero Accounting Endpoint: GetHistoryQuote|GetHistoryQuote]]
::[[Xero Accounting Endpoint: GetHistoryRepeatingInvoice|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 [[Endpoint: Dates|Dates]], [[Endpoint: DatesByMonth|DatesByMonth]] and [[Endpoint: DatesByYear|DatesByYear]] endpoint are compatible.
= OdataLink v2024.5.31.209 =
;MYOB
:Hot fix to the [[MYOB Endpoint: AccountRegister|AccountRegister]], [[MYOB Endpoint: CategoryRegister|CategoryRegister]] and [[MYOB Endpoint: JobRegister|JobRegister]] endpoints to resolve performance issue that requested too much data.
= OdataLink v2024.5.22.209 =
;Xero
:Updated [[Xero Payroll (Australia) Endpoint: LeaveApplications|LeaveApplications]] endpoint for [[Xero Payroll (Australia) Models|Payroll (AU)]] to use v2 that provides access to REQUESTED and REJECTED leave applications.
= OdataLink v2024.5.20.208 =
;Xero
:Applied fixes to the [[Xero Accounting Endpoint: Invoices|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 [[Xero Accounting Endpoint: Invoices|Invoices]], [[Xero Accounting Endpoint: InvoicesExpanded|InvoicesExpanded]], [[Xero Accounting Endpoint: InvoicesExpandedTable|InvoicesExpandedTable]] endpoints to have optimised filters for Status column as per Xero recommendation.
:Enhanced the [[Xero Accounting Endpoint: CreditNotesExpanded|CreditNotesExpanded]], [[Xero Accounting Endpoint: InvoicesExpanded|InvoicesExpanded]] and [[Xero Accounting Endpoint: RepeatingInvoices|RepeatingInvoices]] endpoints to include additional [[Xero Accounting Field: Items|Item]] field.
:Enhanced the [[Xero Accounting Endpoint: InvoicesExpandedTable|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 [[Endpoint: Dates|Dates]], [[Endpoint: DatesByMonth|DatesByMonth]] and [[Endpoint: DatesByYear|DatesByYear]] to always create 3 future or historical year if no start date specified.
:Applied fix for the [[Xero Accounting Endpoint: JournalsAccrual|JournalsAccrual]], [[Xero Accounting Endpoint: JournalsAccrualTable|JournalsAccrualTable]], [[Xero Accounting Endpoint: JournalsCash|JournalsCash]] to fix bug raised in recent updates that did not filter data correctly.
:Applied fox for the [[Xero Accounting Endpoint: BankSummary|BankSummary]] endpoint to include the FXGainLossAmount and parse all columns correctly whether they are present or not.
:Applied fox for the [[Xero Accounting Endpoint: ProfitAndLossByMonth|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 [[MYOB Endpoint: AccountRegister|AccountRegister]], [[MYOB Endpoint: CategoryRegister|CategoryRegister]] and [[MYOB Endpoint: JobRegister|JobRegister]] endpoints to included TotalAmount as the sum of all actitivy and adjustment values.
:Updated the [[MYOB Endpoint: AccountRegister|AccountRegister]], [[MYOB Endpoint: CategoryRegister|CategoryRegister]] and [[MYOB Endpoint: JobRegister|JobRegister]] endpoints to allow filtering by DatesByMonthID field.
= OdataLink v2024.5.1.200 =
;MYOB
:Added two new endpoints for MYOB: [[MYOB Endpoint: ProfitAndLossSummaryReportMultiPeriodTable|ProfitAndLossSummaryReportMultiPeriodTable]] and [[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable|BalanceSheetSummaryReportMultiPeriodTable]]. These have been added to make it easier to create Profit and Loss and Balance Sheet reports.
:Enhanced the [[MYOB Endpoint: AccountBudgets|AccountBudgets]] endpoint for MYOB to include the ''DatesByMonthID'' field.
:Enhanced the [[Endpoint: Dates|Dates]], [[Endpoint: DatesByMonth|DatesByMonth]] and [[Endpoint: DatesByYear|DatesByYear]] to allow filtering them in order to dynamically generate the dates needed for your report.
;Xero
:Enhanced the [[Endpoint: Dates|Dates]], [[Endpoint: DatesByMonth|DatesByMonth]] and [[Endpoint: DatesByYear|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 [[Xero Accounting Endpoint: BankTransactionsExpanded|BankTransactionsExpanded]], [[Xero Accounting Endpoint: ContactsExpanded|ContactsExpanded]], [[Xero Accounting Endpoint: CreditNotesExpanded|CreditNotesExpanded]], [[Xero Accounting Endpoint: ManualJournalsExpanded|ManualJournalsExpanded]], [[Xero Accounting Endpoint: OverpaymentsExpanded|OverpaymentsExpanded]], [[Xero Accounting Endpoint: RepeatingInvoices|RepeatingInvoices]] to ensure Xero provides all fields.
= OdataLink v2024.2.13.187 =
Released on 06/02/2024.
;New Functionality
:Added support for [[Configuring Two-Factor Authentication for my user|Two-Factor Authentication]] via Authenticator APPS (Google Authenticator, Authy, FreeOTP and others).
;Fixes
:Resolved issues with the [[Xero Payroll (Australia) Endpoint: TrackingCategories|TrackingCategories]] endpoint of the [[Xero Payroll (Australia) Models|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 [[Managing email notifications|manage email notifications]].
;Xero
:Resolved issues with the [[Xero Accounting Endpoint: JournalsAccrual|JournalsAccrual]] endpoint when filtering out all data.
= OdataLink v2023.12.20.178 =
Released on 20/12/2023.
;MYOB
:Added the [[MYOB Endpoint: JournalTransactionsHistory|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: [[Xero Accounting Endpoint: CreditNotesExpanded|CreditNotesExpanded]], [[Xero Accounting Endpoint: InvoicesExpanded|InvoicesExpanded]], [[Xero Accounting Endpoint: InvoicesExpandedTable|InvoicesExpandedTable]] and [[Xero Accounting Endpoint: RepeatingInvoices|RepeatingInvoices]].
: Added the [[Xero Accounting Endpoint: GetImage|GetImage]] endpoint to allow downloading image logos into Power BI.
;Miscellaneous
: Enhanced parsing of URL to support the [[Xero Accounting Endpoint: GetImage|GetImage]] endpoint.
= OdataLink v2023.10.20.166 =
Released on 20/10/2023.
;Xero Accounting
: Applied a fix for [[Xero Accounting Endpoint: JournalsAccrual|JournalsAccrual]], [[Xero Accounting Endpoint: JournalsAccrualTable |JournalsAccrualTable]] and [[Xero Accounting Endpoint: JournalsCash|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 [[Xero Payroll (Australia) Endpoint: EmployeesExpanded|EmployeesExpanded]] endpoint of the [[Xero Payroll (Australia) Models|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 Endpoints|xero projects]] model.
:Resolved preview issues with the [[Xero Accounting Endpoint: JournalsAccrual|JournalsAccrual]], [[Xero Accounting Endpoint: JournalsCash|JournalsCash]] and [[Xero Accounting Endpoint: JournalsAccrualTable|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 =
= OdataLink v2023.08.17.150 =
3,572

edits