/businessnxtapi/releasenotes section Here you can find new and old release notes for the Business NXT API 2025-01-30T10:42:12+02:00 # Release Notes Here you can find new and old release notes for the Business NXT API ### 2025.01.30 - Change of access rights handling: tables that are not readable will no longer appear in mutations for create/update/delete. Processings and reports will also be unavailable for these tables. Columns that are not readable will not be available in input types for create and update operations. - Support for enumeration type domains for columns, arguments, or result values. See [enum fields](/businessnxtapi/schema/enumdomains/). ### 2025.01.23 - Support for specifying that a field's execution depends on another one. See the [@dependsOn directive](/businessnxtapi/features/directives/). - Support for deleting an asynchronous request job. See [deleting an asynchronous request](businessnxtapi/schema/async/#deleting-an-asynchronous-request). ### 2024.10.09 - Availability of new `createdTimestamp` and `changedTimestamp` datetime fields on all tables. See [Date and time fields](businessnxtapi/schema/datetime/). - Improved error messages for two scenarious where available companies cannot be fetched. - Fix: date fields suffixed with `AsDate` return `null` if the date is invalid, instead of throwing an error. The situation can arrive when an invalid date was set in the system (a feature used in some limited scenarios). The actual date can still be fetched using the column field of type `Int`. ### 2024.07.19 - Support for specifying the language in `useModel` nodes with a numerical value (eg. `47` for Norwegian). See [Language selection](/businessnxtapi/schema/queries/modelinfo/). - Improved messages for some category of errors (context failures). ### 2024.06.27 - Support for inserting records in between existing ones. See [Insert between existing records](businessnxtapi/schema/mutations/inserts/). ### 2024.06.20 - Extended model information with relations and domain members and access restrictions, availability, and additional properties for each entity type. See [Model information](/businessnxtapi/schema/queries/modelinfo/). - Fields assigned from unset variables are ignored in insert/update mutations. See [Assigning fields from unset variables](/businessnxtapi/schema/mutations/inserts/). - Support for comparing date and time fields with the current date and time. See [Comparing with current date/time](/businessnxtapi/features/filtering/). - New argument `orderBy` for defining the sorting order of the results. See [Sorting](/businessnxtapi/features/sorting/). > [!WARNING] > > The previous `sortOrder` argument is deprecated and will be removed in the future. - Fixed bug that affected blob fields: base-64 encoded values were stored instead of the actual binary data. ### 2024.05.30 - Support for fetch distinct values using a new query argument called `distinct`. See [Distinct values](/businessnxtapi/schema/queries/distinct/). > [!WARNING] > > The previous schema section for aggregates, which includes distinct, is obsolete and will be removed in the future. See [Aggregates](/businessnxtapi/schema/queries/aggregates/). - Fix: incorrect results when filtering with `_is_null` / `_is_not_null` on blob columns. ### 2024.05.23 - Support for `_in` / `_not_in` operators in `having` expressions. - Support for `_between` / `_not_between` operators in filters and `having` expressions. See [Filtering: `_between` / `_not_between` operators](/businessnxtapi/features/filtering/). - Support for domain information in the model. See [Model information](/businessnxtapi/schema/queries/modelinfo/). - Eased some limitations on async requests. See [Async queries](/businessnxtapi/schema/async/). - Defined a limit of 32 requests in a batch. See [Batched requests](/businessnxtapi/features/batches/). - Improved description of table columns in the schema. See [Understanding column descriptions](/businessnxtapi/schema/queries/query/) ### 2024.03.07 - Async queries return correct results when fetching data from multiple tables in a single query. Also the `totalCount` fields works as expected. See [Async queries](/businessnxtapi/schema/async/). - Added `createdDateTimeUtc` and `changedDateTimeUtc` as well as `createdDateTimeTZ` and `changedDateTimeTZ` for filters. See [Datetime special fields](/businessnxtapi/schema/datetime/). - Performance improvement for pagination when `hasNextPage` is requested. For tables of tens of millions of records, the execution time is reduced with 20-25 seconds. - Empty arrays for `_in` and `_not_int` comparison operators in filter result in no data being returned. See [Filtering](/businessnxtapi/features/filtering/). - Fixed `Illegal query` bug for some queries that fetch aggregates using the group by feature. - Fixed `Unknown company` error when a join operation (`joinup_` or `joinddown_` field) is used in the projection a mutation request. ### 2024.01.25 - Added support for grouping by data. See [Grouping](/businessnxtapi/schema/queries/grouping/). - Define `changedDateTime` with second and millisecond precision for table that include the `changeTimeInMs` column. See [Date and time fields](/businessnxtapi/schema/datetime/). - Removed the restriction of executing a single async query at a time. See [Async queries](/businessnxtapi/schema/async/). - The `path` of a failed assignment in an update request (index of record) included an `error` object. See [Error handling](/businessnxtapi/features/errors/). - The `path` of a failed assignment in a create or update request included the `error` object when the operation is executed asynchronously. ### 2023.12.07 - Support for collecting multiple edits in a single update operation. See [Update operations](/businessnxtapi/schema/mutations/updates/). - Increased internal execution timeout to 59 seconds to allow longer synchronous operations. This value may be subject to change. [Async queries](/businessnxtapi/schema/async/) are recommended for long running operations. ### 2023.10.26 - Fix: Support for bitflag values passed in query variables. See [Bitflags](/businessnxtapi/schema/bitflags/). ### 2023.10.19 - Support for exporting values to an array variable. See the [@export directive](/businessnxtapi/features/directives/). ### 2023.10.05 - Fix: correct handling of filters with `changedDateTime`/`createdDateTime` and other `_or` expressions ### 2023.09.28 - Include name of status codes (with `status_name`) in error data not just status codes. See [Error handling](/businessnxtapi/features/errors/). ### 2023.09.07 - Fix: support for `byte` values in processing/report arguments - Fix: partially finish order ### 2023.08.24 - Fix: `hasNextPage` report correct value when all data has been fetched - Fix: allow more field to be set to `null` in order to request to suggest value ### 2023.07.20 - Support for batching multiple requests together. See [Batched requests](/businessnxtapi/features/batches/). ### 2023.07.06 - Support for skipping records. See [Pagination](/businessnxtapi/features/pagination/). - Better support for working with bit flags columns. See [Bitflags](/businessnxtapi/schema/bitflags/). ### 2023.06.29 - Support for fetching model information. See [Model information](/businessnxtapi/schema/queries/modelinfo/). ### 2023.06.01 - Support for `_in` and `_not_in` operators in filters. See [Filtering](/businessnxtapi/features/filtering/). ### 2023.04.27 - Added a new way to suggest values in the correct field order using `null` values. See [Suggested values](/businessnxtapi/schema/mutations/inserts/). - Deprecated the `suggest` argument for suggesting values. > [!WARNING] > > the `suggest` argument will be removed in the future. - Removed the deprecated `suggestValues` argument for suggesting values. ### 2023.02.09 - Added support for fetching distinct values. See [Distinct values](/businessnxtapi/schema/queries/distinct/). ### 2023.01.05 - The `availableCustomers` field works for service-to-service integrations. - The `availableCompany` returns all the companies from all customers if no customer ID was provided, not just the companies of the first found customer (as previously available). - Company information from the `availableCompanies` field includes customer ID with the `vismaNetCustomerId` field. ### 2022.12.15 - **`breaking change`**: Access to system tables available under the new `useCustomer` field both for queries and mutations. See [Accessing system tables](/businessnxtapi/schema/queries/query/) ### 2022.11.10 - Better support for suggesting values with the `suggest` argument. The previous `suggestValues` argument is deprecated and will be removed after 1 March 2023. See [Suggested values](/businessnxtapi/schema/mutations/inserts/). - Fix for `@export` directive. Nodes using exported variables execute only after variables have been resolved. ### 2022.09.29 - Improved performance for queries containing joins. See [Unoptimized queries](/businessnxtapi/features/unoptimized/). - Added the creation and completion time in the result value for asynchronous queries. See [Async queries](/businessnxtapi/schema/async/). - Fix for mutations timeout when a record is not found. ### 2022.08.25 - Support for fetching available companies when using client credentials grant type for the access token (for service-to-service integrations). See [Fetching user's available companies](/businessnxtapi/schema/queries/companies/). - Added the `@export` custom directive. See [Directives](/businessnxtapi/features/directives/). ### 2022.08.04 - Support for suggesting values when inserting new rows. See [Suggested values](/businessnxtapi/schema/mutations/inserts/). - Full support for aliases in queries. See [Aliases](/businessnxtapi/features/aliases/). ### 2022.07.08 - Support for asynchronous queries. See [Async queries](/businessnxtapi/schema/async/). - Added [Brotli](https://en.wikipedia.org/wiki/Brotli) compression for all responses. ### 2022.05.26 - Support for service-to-service integrations. See [Service integrations](/businessnxtapi/authentication/service/).