Technical release notes 2023

22.6.15.0

31-05-2023

BC15 and up

Configuration option added in setup for maximum retry attempts for failed export and import entries.

Processing rule added for export definition to define maximum number of records in an export entry when using an array on the root data item.

Performance improvements in the process filling the export queue entries with records to export (periodical export without table monitor).

Export table monitor support for rename database trigger.

Import filter selection improved to allow filtering on subnodes.

Endpoint support for Intercompany method.

Function GETCURRENTVALUE added to get a table field value before importing a record.

Functions FROMBASE64 and TOBASE64 added to allow conversions from and to Base64 strings.

22.6.15.0

31-05-2023

BC15 and up

Configuration option added in setup for maximum retry attempts for failed export and import entries.

Processing rule added for export definition to define maximum number of records in an export entry when using an array on the root data item.

Performance improvements in the process filling the export queue entries with records to export (periodical export without table monitor).

Export table monitor support for rename database trigger.

Import filter selection improved to allow filtering on subnodes.

Endpoint support for Intercompany method.

Function GETCURRENTVALUE added to get a table field value before importing a record.

Functions FROMBASE64 and TOBASE64 added to allow conversions from and to Base64 strings.

Improved checks on conversions and temporary value codes to prevent accidental usage of the same code.

Fixed an issue with function GETNEXTLINENO for unstructured (CSV, Excel) imports that skipped checking constant lines for other primary key fields.

Fixed an issue with function CONCAT that limited before and after parameters to 50 characters.

Fixed an issue with DateFormula calculation for advanced schedules to calculate the earliest next execution.

22.6.7.0

01-05-2023

BC15 and up

Import of BLOB fields now allows for plain text if no Base64 or URL is detected.

Import REST using Link paging method improved performance, minimizing recursive functions.

Mapping Helper matching improved to compare fieldnames/captions against elements using filtering out a character set containing spaces, underscore and minus signs.

Advanced recurrence allows ending time 0T when starting time is defined.

Definition exports now contain definition recurrence lines when using beta feature advanced recurrence.

Project export contained no data. Fixed to include project and definition content.

Output Condition table relation changed to include relation on Definition Line line number.

21.6.4.0

31-03-2023

BC15 and up

BC22 ready.

Line identifier for not flattened unstructured import check against import file is not case sensitive anymore.

Import unstructured constant values allows to select unmapped definition lines when using processing policy before/after field.

Beta feature Advanced Recurrence was not activated for import definitions.

Import unstructured filter checked against specific definition line instead of table number.

Import constant values processing policy last was not always executed for unstructured imports.

21.6.0.0

01-03-2023

BC15 and up

An app version check is now included in ConnectIT 365, which will display notifications if a newer version is available.

Beta feature management has been included, which can be accessed from the ConnectIT Setup card page.

Added beta feature: Configure export definitions with data format Excel/CSV with multiple table relations. See this topic for more information.

Added beta feature: Configure export/import definitions with advanced recurrence options, allowing multiple schedules. See this topic for more information.

Added beta feature: Configure local logging instead of logging to the ConnectIT API for performance improvements when using logging level Debug or Detailed Information. See this topic for more information.

Added functionality to determine action on import of new records, allowing to stop processing on new records and only update existing records.

Added new functions: CONTAINS, IFMATCH, IFGREATER, IFGEQ, ISMATCH, ISGREATER, ISGEQ, PADLEFT.

Export JSON helper/value arrays allow more data types. Previously only implemented for Text fields.

Store REST/SOAP response content in separate BLOB field (visible in export log entry).

Changed SETTEMPVAL/GETTEMPVAL errors to confirmation dialogs to allow multiple usages of temporary value code in the same definition.

Standard No. Series handling on IDYC entities, which allows usage of alternative no. series with drilldown page.

Fix to stop processing definition line for import where corresponding element is missing in incoming JSON or XML message.

Fix for Excel/CSV column order in export, which will respect the order as configured in the definition lines (beta feature needs to be enabled).

Fix for max string length on external identifier in CSV/Excel import when using Text field from target table with max length smaller than 100 characters.

Proper error handling for FTP http 413 (max request length exceeded).

Output condition improvements for (root) nodes, checking on empty values.

21.5.0.0

20-01-2023

BC15 and up

Added new feature Projects to group import/export definitions.

Added new method Intercompany to synchronize between companies.

Improved JSON export processing, allowing arrays on helpers and fields/constants to create arrays for a single record.

Improved JSON import processing, allowing processing of JsonValues in arrays and improving processing of array in array.

Improved JSON/XML filter check on arrays during import.

Improved handling of import definition constant values, allowing empty constant values for primary key checks.

Changed processing order for checking existing records during import, reducing duration and possible record locks.

Changed handling of temporary values used as function parameters, allowing distinction between empty temporary values and not found values.

Changed JSON/XML export output conditions, improving checks for nodes (data items and helpers) to check on values within child nodes.

21.4.100364.0

11-01-2023

BC14 and up

Feature: OAuth2 Process cookie + REST request cookie

Improved Primary Key Processing

Improved REST Endpoint import key link buffer usage