Version | Release |
|---|
Date | Available for |
|---|
29-11-2023
BC15 and up
The following improvements have been implemented:
Idyn App Management has been integrated into ConnectIT 365 to move shared functionality between idyn apps. For SaaS installations this app will be automatically added during install or update, for on premises installations this app should be installed first before installing the new ConnectIT 365 version.
Import: Easier configuration of definition lines by allowing insert of new lines on the page instead of using a dedicated page action with restrictions.
Import: Key Links have been added for unstructured data formats (Excel/CSV) for easier configuration of table/record relationships.
Import: Added a mandatory element configuration option in definition lines to check if an element should always be present in the incoming message for structured data formats (JSON/XML).
Backup: Added a page action to update/overwrite the current export/import definition instead of always creating a new definition on import.
Scheduler: Improved error handling for Job Queue Entry errors with logging and notification options.
Version | Release date | Available for |
|---|---|---|
23.7.6.0 | 10-11-2023 | BC15 and up |
The following improvements have been implemented: |
|---|
Export/Import Definition Lines style changed for structured data formats (JSON/XML) to get a better overview of the different line types. Helper lines are now displayed with bold text and table/field numbers are only displayed when not set to 0. |
Export: Improvements JSON data format for child lines within Helper arrays, which now supports all configurations with child data items and child helpers. |
Table Monitors: Table Monitor list expanded to include more information regarding the linked definition and status. |
The following issues have been resolved:
Definition configuration option for maximum number of retries was not always calculated properly, resulting in the entries not automatically being reprocessed.
Import: Fixed issue where attributes linked to elements (definition lines with type field) would result in an error on the absolute xPath.
Backup: Definition copy to target company did not contain a logging level setup record after creation.
31/10/2024 | BC18 and up | |
04/09/2024 | BC18 and up | |
19/06/2024 | BC15 and up | |
16/05/2024 | BC15 and up | |
27/03/2024 | BC15 and up | |
12/02/2024 | BC15 and up |
Version | Release date | Available for |
|---|
23.7.4.0
30-09-2023
| 31/10/2024 | BC18 and up |
The following improvements have been implemented: |
|---|
Export: Allow value arrays directly on Data Item lines (Data Format JSON). |
Export: Added |
Export: Added SETTASKVALUE to support using temporary values in E-Mail tasks for subject and body.
Export: Added action to add all root data item fields from the definition lines to the table monitor fields.
Import: Improved notifications for (failed) manual import actions.
The following issues have been resolved: |
|---|
Export: Fixed the output and output conditions check for XML root helper lines. |
Import: Fixed issue where attributes linked to elements (definition lines with type field) could not be found in XML structure. |
Version | Release date | Available for |
|---|---|---|
22.7.0.0 | 30-08-2023 | BC15 and up |
The following improvements have been implemented: |
|---|
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. |
an additional key in the IDYC Export Queue Entry table for performance improvements on both export table/field monitoring and export queue processing. |
Functions: New functions ENCRYPTTEXT and DECRYPTTEXT to encrypt en decrypt strings. |
Functions: New functions GENERATEHASH and GENERATEHASHBASE64 to create hash values with support for multiple hash algorithms optionally using a key. |
Functions: New functions TRIM, TRIMSTART and TRIMEND to trim leading and or trailing characters. |
Functions: New function GETEXPORTSYSTEMIDS to retrieve System Ids from the Export Entry. Can be used in combination with processing rule to store the exported system ids when processing a (webservice) response with an import definition. |
Functions: Added addtional parameter for function FORMAT to explicitly specify which data type to validate against. |
Functions: Renamed FORMATDECIMAL to PARSEDECIMAL and changed behaviour to handle function in AL (previously handled by the ConnectIT API). |
Functions: Changed behaviour for functions REST and AZUREFUNCTION to handle function in AL (previously handled by the ConnectIT API). This results in requests to the endpoint URI being sent directly instead of through a proxy/gateway service. |
Functions: Added lookup pages for parameters that are based on enums/options to select the option value (used for functions FORMAT, GENERATEHASH and GENERATEHASHBASE64) |
Logging: (Beta feature) Added option to choose between local/internal and API logging when beta feature is enabled. |
Logging: (Beta feature) Performance improvements for local/internal logging when beta feature is enabled. |
OAuth2: Custom grant flow: Added additional check on empty token in response when using an import definition (with temporary values). |
The following issues have been resolved: |
|---|
Export: |
Version | Release date | Available for |
|---|---|---|
22.6.18.0 | 10-07-2023 | BC15 and up |
The following improvements have been implemented: |
|---|
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. |
The following issues have been resolved:
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.
Guid data type was skipped in export. Will now be processed as Text. |
Import: XML root element before first Data Item could not always find value in structure. |
Import: Excel import could result in error on Compatilibility Id. |
Filters: (Beta feature) DateTime filter tokens could result in incorrect filterstring. e.g. >=[ISODate] resulted in >=2024-10-31 00:00..2024-10-31 23:59. This will now result in correct filter >=2024-10-31 while still supporting date (range) filters on datetime fields. |
Filters: (Beta feature) Standard text tokens ME, USER and COMPANY were also checked without using %, resulting in incorrectly using the standard tokens for regular text values. This will now expect %ME, %USER or %COMPANY. |
Tasks: Manual numbering was not allowed, even when enabled on No. Series. |
Version | Release date | Available for |
|---|
22.6.15.0
31-05-2023
| 04/09/2024 | BC18 and up |
The following improvements have been implemented: |
|---|
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.
Export: New processing rule to store System IDs for exported records in Export Entry. |
Export: Re-Generate export content for failed Export Entries (requires processing rule to store System IDs). |
Import: Check external identifier on child nodes for structured data (JSON/XML) imports. |
Import: Retrieve XML element values before root data item node, which allows these values to be used in functions. |
Logging: Retrieve error information (including error message and callstack) for failed Export and Import Entries. |
Logging: Improvements in log readability by including references to tables, fields or definition lines. |
Backup: Include beta feature configuration in project and definition configuration exports. |
Events: Added additional integration events in export and import processes, including events for different methods and during generation of export content. |
The following issues have been resolved: |
|---|
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.
Logging: Fixed invalid JsonToken issue during logging requests. While this did not result in errors in the export and import processes, this could result in incorrect error callstacks in the last known session error. |
Beta: Logging feature - Fixed issue that prevented usage for beta feature in some scenarios. |
Beta: Filter feature - Fixed issue with standard date variables/tokens (e.g. CM) that resulted in incorrect filter strings on date/time fields. |
Version | Release date | Available for |
|---|
22.6.7.0
| 19/06/2024 | BC15 and up |
The following improvements have been implemented: |
|---|
Import |
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.
: Configuration Template can now be assigned to definition line number instead of field number, which also allows assigning the template to an unmapped line. |
The following issues have been resolved: |
|---|
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.
Import: Fixed XML XPath error on finding primary key fields/external identifier. |
Import: Fixed REST Endpoint Definition Lines - Add new line action was not visible/allowed. |
Import: Fixed FTP filename length could cause overflow on Import Entry record. |
Version | Release date | Available for |
|---|
21.6.4.0
| 16/05/2024 | BC15 and up |
The following improvements have been implemented: |
|---|
BC22 ready.
Line identifier for not flattened unstructured import check against import file is not case sensitive anymore.
BC24 Ready. |
Export: Allow empty content for JSON and XML. This can be used for webservice requests that require a POST or PUT without any request content. |
Export: Filter in manual export is only updated if the temporary filter was changed. |
Definition Line Management: Redesign for Move up/down actions to limit the amount of transactions to move the definition lines. |
The following issues have been resolved: |
|---|
Beta feature Advanced Recurrence was not activated for import definitions.
Import unstructured filter checked against specific definition line instead of table number.
Export: Fixed missing XML Namespaces on root Data Item node. |
Export: Fixed repeating attributes for parent Helper nodes. |
Export: Temporary filter in manual export ignored filters on empty values. |
Definition Line Management: Fixed issue with rename on records related to moved definition line (functions, output conditions) that caused the findset to not properly loop through all related records. This behaviour caused related records to not move with the moved definition line when using the Move up/down actions. |
Notifications: Fixed Windows event viewer errors when recalling notifications when the notification ID was not defined (Idyn App Management). |
Version | Release date | Available for |
|---|
21.6.0.0
| 27/03/2024 | BC15 and up |
The following improvements have been implemented: |
|---|
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.
Import: Additional checks during checks on external identifier to minimize reading and writing transactions on IDYC Imported Record table. |
Intercompany: Import Entries will now have their own log entry, instead of the logging details being added to the log entry for the Export Entry. |
OAuth2 Authorization: Custom grant flows now support form-urlencoded and form-data content for the token request. |
Context sensitive help pages changed to Confluence pages. |
New Beta Feature: New Key Links experience, which allows multiple instances of tables in import definitions. |
New Beta Feature: New Filter experience, which allows usage of standard filter strings. |
The following issues have been resolved: |
|---|
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).
Export: Functions were not executed for output from BLOB, Media and MediaSet fields. |
Functions: GETCURRENTVALUE did not calculate FlowFields, resulting in an empty value. |
Version | Release date | Available for |
|---|
21.5.0.0
| 12/02/2024 | BC15 and up |
The following improvements have been implemented: |
|---|
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.
Version | Release date | Available for |
|---|---|---|
21.4.100364.0 | 11-01-2023 | BC14 and up |
The following improvements have been implemented:
Feature: OAuth2 Process cookie + REST request cookie
Improved Primary Key Processing
Export: Add Fields action also automatically cleans lines (with line renumbering) to make it easier to continue editing Definition Lines and still automatically determine parent line and indentation. |
Export/Import: Added automatic page refresh after Functions, Filters and Output Conditions pages are closed and focus is returned to the Definition Lines to display the correct count. |
OAuth2: Added scope and resource URL fields for client credentials and custom grant flows. |
Logging: The IDYC Logging Helper codeunit now contains an additional parameter (clearlogentries_days=x) that can be used in the Job Queue Entries to clear logging older then a custom (defined with x) amount of days. |
License and usage request moved/removed to decrease the amount of requests to the license server during the export/import process. |
The following issues have been resolved: |
|---|
Export: Fixed an issue where Output Conditions were not deleted when a Export Definition was deleted. |
Export: Query Parameters (used for method REST Endpoint) are now included in the definition configuration export. |
Import: Fixed an issue where filters on JSON arrays were linked to the incorrect Definition Line, causing the filters not to be checked. |
Import: Fixed an issue with indenting when importing/copying a definition from a configuration file. |
Functions: Fixed return value for CONTAINS function to properly return Yes/No as output. |
OAuth2: Fixed an issue with request with formdata contact, added an additional empty line, causing some credentials not to be recognised. |