Technical release notes 2023

22.7.0.0

30-08-2023

BC15 and up

Configuration option for maximum retry attempts is now configurable on each definition, instead of only in the ConnectIT Setup.

Export: A rule has been added to configure the processing delay that will check when a record was added to the Export Queue before processing the queue record.

Export: Data Item filters now allow for handling of flowfilter fields to calculate flowfields.

Export: Manual record queueing is modified to also handle realtime exports, allowing for direct exports from page actions.

OAuth2: OAuth2 Authorization now allows for using custom export/import definitions for the request and response handling to retrieve/refresh a token.

OAuth2: Function GETAUTHTOKEN is added to retrieve a token value in the definition body. This will be only allowed for custom grant type.

Scheduling: Advanced Scheduling is leaving the beta features and is included in the standard solution without enabling the feature.

Export: Manual queue processing skips the check for scheduling. With the introduction of the advanced scheduling, this check was introduced in the manual process.

22.6.18.0

10-07-2023

BC15 and up

Filter: Improved temporary value/variable handling in filter, allowing complete filter strings in a single variable.

Import: Filter field/line lookup page added with OnLookup trigger to select all elements including subnodes.

Import: Store REST/SOAP request URI in Import Entry record after variable substitution.

Import: Add Import Data Log Entries to cleanup of Log Helper codeunit.

Functions: New functions ERRORIF, ERRORIFNOT to set custom error code and message based on is (not) equal condition.

Functions: New functions GETURLVALUE, GETURLPARAMETER to retrieve request URI or parameter from Import Entry.

Functions: New function GETIMPORTENTRYBODY to retrieve Import Entry body as Base64 string.

Functions: New function NEWLINE to get new line characters (Carriage Return + Line Feed).

Functions: Changed functions ADDLINK, ADDNOTE to include optional parameter to skip if input text is empty.

OAuth2 Authorization Code grant flow: x-www-form-urlencoded request body correctly generated.

Import: Apply Configuration Template only on new records.

Import: New Import Data Log Entries are created with line no. increment 1 instead of 10000 to prevent integer overflow.

Export: Changed XML attribute handling to allow attributes with namespace prefixes on root data item/helper line.

Export: Output Conditions fix to compare against empty temporary value.

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