Added createdTimestamp and changedTimestamp on all tables businessnxtapi/release-notes/2024-10-09-added-createdtimestamp-and-changedtimestamp-on-all-tables/ release-note 2024-10-09 Availability of new createdTimestamp and changedTimestamp datetime fields on all tables. See Date and time fields. 2024-10-09T00:00:00Z # Added createdTimestamp and changedTimestamp on all tables Availability of new createdTimestamp and changedTimestamp datetime fields on all tables. See Date and time fields. Improved errors when available companies cannot be fetched businessnxtapi/release-notes/2024-10-09-improved-errors-when-available-companies-cannot-be-fetched/ release-note 2024-10-09 Improved error messages for two scenarios where available companies cannot be fetched. 2024-10-09T00:00:00Z # Improved errors when available companies cannot be fetched Improved error messages for two scenarios where available companies cannot be fetched. Fix: Invalid AsDate values now return null businessnxtapi/release-notes/2024-10-09-fix-invalid-asdate-values-now-return-null/ release-note 2024-10-09 fix 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-10-09T00:00:00Z # Fix: Invalid AsDate values now return null 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. Numeric language codes in useModel businessnxtapi/release-notes/2024-07-19-numeric-language-codes-in-usemodel/ release-note 2024-07-19 Support for specifying the language in useModel nodes with a numerical value (eg. 47 for Norwegian). See Language selection. 2024-07-19T00:00:00Z # Numeric language codes in useModel Support for specifying the language in useModel nodes with a numerical value (eg. 47 for Norwegian). See Language selection. Improved context failure error messages businessnxtapi/release-notes/2024-07-19-improved-context-failure-error-messages/ release-note 2024-07-19 Improved messages for some category of errors (context failures). 2024-07-19T00:00:00Z # Improved context failure error messages Improved messages for some category of errors (context failures). Insert records between existing rows businessnxtapi/release-notes/2024-06-27-insert-records-between-existing-rows/ release-note 2024-06-27 Support for inserting records in between existing ones. See Insert between existing records. 2024-06-27T00:00:00Z # Insert records between existing rows Support for inserting records in between existing ones. See Insert between existing records. Expanded model metadata for entities and relations businessnxtapi/release-notes/2024-06-20-expanded-model-metadata-for-entities-and-relations/ release-note 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. 2024-06-20T00:00:00Z # Expanded model metadata for entities and relations Extended model information with relations and domain members and access restrictions, availability, and additional properties for each entity type. See Model information. Ignore unset-variable assignments in insert and update businessnxtapi/release-notes/2024-06-20-ignore-unset-variable-assignments-in-insert-and-update/ release-note 2024-06-20 Fields assigned from unset variables are ignored in insert/update mutations. See Assigning fields from unset variables. 2024-06-20T00:00:00Z # Ignore unset-variable assignments in insert and update Fields assigned from unset variables are ignored in insert/update mutations. See Assigning fields from unset variables. Compare date/time fields with current datetime businessnxtapi/release-notes/2024-06-20-compare-date/time-fields-with-current-datetime/ release-note 2024-06-20 Support for comparing date and time fields with the current date and time. See Comparing with current date/time. 2024-06-20T00:00:00Z # Compare date/time fields with current datetime Support for comparing date and time fields with the current date and time. See Comparing with current date/time. New orderBy sorting argument businessnxtapi/release-notes/2024-06-20-new-orderby-sorting-argument/ release-note 2024-06-20 New argument orderBy for defining the sorting order of the results. See Sorting. 2024-06-20T00:00:00Z # New orderBy sorting argument New argument orderBy for defining the sorting order of the results. See Sorting. Varning The previous sortOrder argument is deprecated and will be removed in the future. Fix: Blob fields now store binary data correctly businessnxtapi/release-notes/2024-06-20-fix-blob-fields-now-store-binary-data-correctly/ release-note 2024-06-20 fix Fixed bug that affected blob fields: base-64 encoded values were stored instead of the actual binary data. 2024-06-20T00:00:00Z # Fix: Blob fields now store binary data correctly Fixed bug that affected blob fields: base-64 encoded values were stored instead of the actual binary data. New distinct query argument businessnxtapi/release-notes/2024-05-30-new-distinct-query-argument/ release-note 2024-05-30 Support for fetch distinct values using a new query argument called distinct. See Distinct values. 2024-05-30T00:00:00Z # New distinct query argument Support for fetch distinct values using a new query argument called distinct. See Distinct values. Varning The previous schema section for aggregates, which includes distinct, is obsolete and will be removed in the future. See Aggregates. Fix: _is_null and _is_not_null on blob columns businessnxtapi/release-notes/2024-05-30-fix-_is_null-and-_is_not_null-on-blob-columns/ release-note 2024-05-30 fix Fix: incorrect results when filtering with _is_null / _is_not_null on blob columns. 2024-05-30T00:00:00Z # Fix: _is_null and _is_not_null on blob columns Fix: incorrect results when filtering with _is_null / _is_not_null on blob columns. _in and _not_in support in having businessnxtapi/release-notes/2024-05-23-_in-and-_not_in-support-in-having/ release-note 2024-05-23 Support for _in / _not_in operators in having expressions. 2024-05-23T00:00:00Z # _in and _not_in support in having Support for _in / _not_in operators in having expressions. _between and _not_between in filters and having businessnxtapi/release-notes/2024-05-23-_between-and-_not_between-in-filters-and-having/ release-note 2024-05-23 Support for _between / _not_between operators in filters and having expressions. See Filtering: _between / _not_between operators. 2024-05-23T00:00:00Z # _between and _not_between in filters and having Support for _between / _not_between operators in filters and having expressions. See Filtering: _between / _not_between operators. Domain metadata available in model information businessnxtapi/release-notes/2024-05-23-domain-metadata-available-in-model-information/ release-note 2024-05-23 Support for domain information in the model. See Model information. 2024-05-23T00:00:00Z # Domain metadata available in model information Support for domain information in the model. See Model information. Relaxed async request limitations businessnxtapi/release-notes/2024-05-23-relaxed-async-request-limitations/ release-note 2024-05-23 Eased some limitations on async requests. See Async queries. 2024-05-23T00:00:00Z # Relaxed async request limitations Eased some limitations on async requests. See Async queries. Batch requests limited to 32 operations businessnxtapi/release-notes/2024-05-23-batch-requests-limited-to-32-operations/ release-note 2024-05-23 Defined a limit of 32 requests in a batch. See Batched requests. 2024-05-23T00:00:00Z # Batch requests limited to 32 operations Defined a limit of 32 requests in a batch. See Batched requests. Improved table column descriptions businessnxtapi/release-notes/2024-05-23-improved-table-column-descriptions/ release-note 2024-05-23 Improved description of table columns in the schema. See Understanding column descriptions. 2024-05-23T00:00:00Z # Improved table column descriptions Improved description of table columns in the schema. See Understanding column descriptions. Fix: Async multi-table queries return correct totalCount businessnxtapi/release-notes/2024-03-07-fix-async-multi-table-queries-return-correct-totalcount/ release-note 2024-03-07 fix 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. 2024-03-07T00:00:00Z # Fix: Async multi-table queries return correct totalCount 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. Added UTC and timezone datetime filter fields businessnxtapi/release-notes/2024-03-07-added-utc-and-timezone-datetime-filter-fields/ release-note 2024-03-07 Added createdDateTimeUtc and changedDateTimeUtc as well as createdDateTimeTZ and changedDateTimeTZ for filters. See Datetime special fields. 2024-03-07T00:00:00Z # Added UTC and timezone datetime filter fields Added createdDateTimeUtc and changedDateTimeUtc as well as createdDateTimeTZ and changedDateTimeTZ for filters. See Datetime special fields. Faster pagination with hasNextPage businessnxtapi/release-notes/2024-03-07-faster-pagination-with-hasnextpage/ release-note 2024-03-07 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. 2024-03-07T00:00:00Z # Faster pagination with hasNextPage 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 _in and _not_in arrays now return no rows businessnxtapi/release-notes/2024-03-07-empty-_in-and-_not_in-arrays-now-return-no-rows/ release-note 2024-03-07 Empty arrays for _in and _not_in comparison operators in filter result in no data being returned. See Filtering. 2024-03-07T00:00:00Z # Empty _in and _not_in arrays now return no rows Empty arrays for _in and _not_in comparison operators in filter result in no data being returned. See Filtering. Fix: Illegal query in grouped aggregates businessnxtapi/release-notes/2024-03-07-fix-illegal-query-in-grouped-aggregates/ release-note 2024-03-07 fix Fixed Illegal query bug for some queries that fetch aggregates using the group by feature. 2024-03-07T00:00:00Z # Fix: Illegal query in grouped aggregates Fixed Illegal query bug for some queries that fetch aggregates using the group by feature. Fix: Unknown company in mutation join projections businessnxtapi/release-notes/2024-03-07-fix-unknown-company-in-mutation-join-projections/ release-note 2024-03-07 fix Fixed Unknown company error when a join operation (joinup_ or joinddown_ field) is used in the projection a mutation request. 2024-03-07T00:00:00Z # Fix: Unknown company in mutation join projections Fixed Unknown company error when a join operation (joinup_ or joinddown_ field) is used in the projection a mutation request. Group-by query support businessnxtapi/release-notes/2024-01-25-group-by-query-support/ release-note 2024-01-25 Added support for grouping by data. See Grouping. 2024-01-25T00:00:00Z # Group-by query support Added support for grouping by data. See Grouping. Millisecond precision for changedDateTime businessnxtapi/release-notes/2024-01-25-millisecond-precision-for-changeddatetime/ release-note 2024-01-25 Define changedDateTime with second and millisecond precision for table that include the changeTimeInMs column. See Date and time fields. 2024-01-25T00:00:00Z # Millisecond precision for changedDateTime Define changedDateTime with second and millisecond precision for table that include the changeTimeInMs column. See Date and time fields. Removed single-async-query execution limit businessnxtapi/release-notes/2024-01-25-removed-single-async-query-execution-limit/ release-note 2024-01-25 Removed the restriction of executing a single async query at a time. See Async queries. 2024-01-25T00:00:00Z # Removed single-async-query execution limit Removed the restriction of executing a single async query at a time. See Async queries. Update assignment failures include error in path businessnxtapi/release-notes/2024-01-25-update-assignment-failures-include-error-in-path/ release-note 2024-01-25 The path of a failed assignment in an update request (index of record) included an error object. See Error handling. 2024-01-25T00:00:00Z # Update assignment failures include error in path The path of a failed assignment in an update request (index of record) included an error object. See Error handling. Async create/update assignment failures include error in path businessnxtapi/release-notes/2024-01-25-async-create/update-assignment-failures-include-error-in-path/ release-note 2024-01-25 The path of a failed assignment in a create or update request included the error object when the operation is executed asynchronously. 2024-01-25T00:00:00Z # Async create/update assignment failures include error in path The path of a failed assignment in a create or update request included the error object when the operation is executed asynchronously.