The topic you requested could not be found.
Related topics are listed below.

Administration

Configuration » Administration

Setup

Configuration » Setup

To start using ConnectIT, you will first have to provide some information and preferences on the setup card. The easiest way to do this is to start the Setup Wizard. This wizard will configure the general setup, however it is also possible to manually configure the…

Initial Setup

Key Usage Scenario » Initial Setup

After installing the ConnectIT App, select the ConnectIT Manager role for your current user. Open the Wizard action on your role center under Setup & Help. Step 1: License key Enter the value ‘CONNECTITTESTKEY’ in the License Key field. Click…

Setup wizard

Configuration » Setup wizard

After a new ConnectIT installation the quickest way to get started is by running the Setup Wizard. On the ConnectIT Manager role center under the ‘Setup & Help’ section, click ‘Wizard’. Step 1: License key Enter your license key in the License…

Isolated storage and encryption

Processing » General » Isolated storage and encryption

Passwords and tokens etc. are stored in the isolated storage. When you have encryption enabled, this data is stored to the isolated storage encrypted. However, the maximum length of a string to store encrypted is 215 characters. Tokens often exceed this length.…

Filtering and Output Conditions

Processing » Export » Configuration » Filtering and Output Conditions

On definition lines, filters and output conditions can be applied. This makes it possible to decide what to show and what not to show in your output. Filterering Filters can be added on DataItem level only. They can contain constant values combined with comparison…

Configuration

Configuration » Administration » Endpoints » Configuration

To configure Endpoints, go to the Endpoint list. You can find this list by searching for Endpoint List or by using the menu in the ConnectIT Manager Role Center under Administration / Additional Setup. Create a new endpoint or open an existing endpoint to show…

OAuth2 authorizations

Configuration » Administration » OAuth2 authorizations

This section explains how to setup and use OAuth2. ConnectIT 365 supports 2 standard grant types: Client Credentials, Authorization Code. When using authorization code, refresh token grant will be automatically used when possible. A 3rd option Custom is also available…

Scheduling

Processing » General » Scheduling

To automatically export or import, a Job Queue Entry has to be setup. This can be configured with the help of the Setup Wizard, where you can select the job queue entries that should be created. If the job queue entries were not created during setup, these entries…

Business Central SaaS

Installation » Business Central SaaS

If you are running the cloud/online version of Microsoft Dynamics 365 Business Central, you can find and install the ConnectIT 365 app in Microsoft AppSource. If ConnectIT 365 is already installed and an update is available you can update the app in the Business…

Beta features

Configuration » Beta features

With ConnectIT 365 major release 6 (version XX.6.0.0) beta features are introduced. These contain new features that enable new functionality, but could change existing behaviour. Because of this, these features will be disabled by default. This makes it possible for…

Alert notifications

Processing » General » Alert notifications

In both the import and export definition, you will find a tab Alerts. There are three options available, to where alerts can be sent. Alerts can be configured on both success and failure states. The first option is to use E-mail. For Business Central 20.0 and later…

WSDL documents

Configuration » Administration » WSDL documents

In the ConnectIT Manager role, select WSDL Documents in the Administration tab. The start importing a new WSDL file, click Process WSDL File and select your WSDL file. The selected WSDL file will now be processed by Business Central and all bindings and their…

Log Entries

Processing » Import » Process » Log Entries

The Log list page shows an overview of log entries for each session ID. Each import gets a unique session ID when it is imported. In the detailed log entries on the log card page, you can see every step from start import till end of processing the imported entry. How…

Initialize Dropbox authorization

Configuration » Administration » OAuth2 authorizations » Initialize Dropbox authorization

From the OAuth2 authorization list a page action is available to create a new Dropbox OAuth2 authorization using a authorization code grant flow. This creates an OAuth2 authorization record with the basic setup for Dropbox. The client id and secret are still required…

Key features

Introduction » Key features

ConnectIT 365 is an extension for Microsoft Dynamics Business Central that offers the tools to create your own interfaces for communication between the Business Central ERP system and third party applications, through an extensive set of facilities for export and…

Imported Records

Processing » Import » Process » Imported Records

The Imported Records list page shows a overview of all records that were created (inserted) by connectIT. The list shows the table the records was added to, the definition that was used to import the record, the record ID, System ID, external ID (as setup in the…

Azure Event Grid

Processing » Export » Configuration » Methods » Azure Event Grid

You can setup Azure Event Grid in the Azure Portal. In the Azure Portal, click Create a Resource. On the pages that opens, search for Event Grid and choose for Event Grid Topic. On the next pages that opens click create. Name the Event Grid Topic and fill out the rest…

Business Central On-Premises

Installation » Business Central On-Premises

If you are running the On-Premises version of Microsoft Dynamics 365 Business Central, you can install the ConnectIT 365 app using Windows PowerShell and the app runtime package provided by your implementation partner. *Before installing ConnectIT 365 for the first…

Self-hosted API

Installation » Self-hosted API

In an on-premises environment you have the ability to self-host the ConnectIT API. To do this you have to download the set of application files which corresponds with your ConnectIT version. This is a zip-file with a name like: ConnectIT365.SelfHostedAPI.v1.2.3.4.…

Azure Service Bus

Processing » Import » Configuration » Methods » Azure Service Bus

You can setup up your Azure Sevice Bus in your Azure Portal. In the portal click Create a resource and search for Service Bus. On the page that opens, click Create. Fill out the form as you prefer and finish by clicking Create. Once it has finished creating, click the…

Table Monitor

Processing » Import » Configuration » Table Monitor

To trigger imports based on changes in records in your database, Import Table Monitors can be setup. On the Import Table Monitor card page, select the import definition you want to be triggered. For Table No. select the table no. for the record that will be used to…

E-Mail

Processing » Export » Configuration » Methods » E-Mail

On the Email tab a single field is available, because this method uses the same functionality as the Tasks. Select the E-Mail Task that should be used to process the export definition. The task configuration allows for the subject and body to contain variable…

Configuration Templates

Processing » Import » Configuration » Configuration Templates

On the General tab of the import definition you can set the Use Config. Template setting to true. This will make a new tab appear. On this Configuration Templates tab, additional setup should be done. There are two ways to use configuration templates. The first and…

Logging

Processing » General » Logging

For all actions executed by export and import definitions logging can be enabled. In the ConnectIT 365 Setup the default logging level can be specified. This default logging level is used when new definitions are created. These new definitions are automatically…

Definition configuration

» Definition configuration

On the General tab, give the definition a recognizable description. Select the data format of the incoming data and select the method that will be used. Supported data formats currently are JSON, XML, CSV and Excel. Currently supported import methods are Manually, FTP,…

Configuration

Processing » Import » Configuration

On the General tab, give the definition a recognizable description. Select the data format of the incoming data and select the method that will be used. Supported data formats currently are JSON, XML, CSV and Excel. Currently supported import methods are Manually, FTP,…

Permissions

Configuration » Permissions

The ConnectIT 365 extension includes to permission sets that are created during installation: IDYC CONNECTIT 365: Contains full permissions for all ConnectIT 365 extension objects. IDYC CONNECTIT USAGE: Contains a very limited set of permissions that can be used for…

Release notes

Introduction » Release notes

Version Release date Available for 23.8.10.0 12-02-2024 BC15 and up The following improvements have been implemented: Export: Add Fields action also automatically cleans lines (with line renumbering) to make…

REST Endpoint

Processing » Export » Configuration » Methods » REST Endpoint

It is possible to set up and export definition that will serve as a GET endpoint, to be used by external systems. The external party will have to do a GET call to https://connectitapi.idyn.nl/api/WebServices/Get, using the following headers: Tenant (4) …

Azure Storage

Processing » Import » Configuration » Methods » Azure Storage

You can set up Azure Storage in your Azure Portal. In the portal, click the Storage Accounts button and click add. Fill out the form based on your own preferences and click Review + create. After the storage account passed validation, click Create. When the storage is…

Logging: Enable internal logger

Configuration » Beta features » Logging: Enable internal logger

*Beta feature available with major release 6 (XX.6.0.0) Before this release, all logging was done through the ConnectIT API. This was done to prevent locking on logging transactions. However, this solution came with a cost for the more verbose logging levels (e.g.…

Configuration

Processing » Export » Configuration

On the General tab, give the definition a recognizable description. Select the data format of the outgoing data and select the method that will be used. Supported data formats currently are JSON, XML, CSV and Excel. Currently supported export methods are Manually, FTP,…

REST

Processing » Export » Configuration » Methods » REST

On the REST tab of the export definition, choose your authentication type and provide the credentials. Fill out the request information (URL and Content-Type) and if applicable, add information for the Request Headers. Finally, you can select an import definition that…

Events

Technical documentation » Events

ConnectIT ships with many integration events. Events can be used to extend ConnectIT with custom code. In this section we will list and explain all available events and provide you with some examples.

Import/Export Events

Technical documentation » Events » Import/Export Events

Codeunit: “IDYC Task Scheduler” This codeunit is used for automatically importing and exporting via job queue entries. For import: The code checks if import for a definition is allowed to run again, based on last run time and recurrence settings. If import…

ConnectIT Manager role

Configuration » ConnectIT Manager role

Throughout this user manual, we assume you are logged in with the ConnectIT Manager Role. On the ConnectIT Manager Role Center you will find a large set of tiles, providing you with information on for example how many active definitions there are running, if there are…

Installation

Installation

This section describes the different versions of ConnectIT 365 and how to install them. While versions for SaaS and On-Premises are functionally the same, the installation procedure is different. In this section the installation for a self-hosted version of the…

Export queue

Processing » Export » Process » Export queue

In the export queue all records that were picked up by the table monitor or were added manually, and have not been processed yet are listed. The Export Definition No. column shows which export definition will be used to export the record. Table No. shows from which…

SOAP

Processing » Import » Configuration » Methods » SOAP

To be able to use SOAP, you will first have to to import the WSDL definition for the SOAP service you are planning to use. For more information on this, go here. When the WSDL is imported proceed below: On the SOAP tab of the import definition, select the correct…

Table monitor

Processing » Export » Configuration » Table monitor

The Export Table Monitor makes it possible to track changes in your database, and let these changes be a trigger to start an export. This will result in records in the ConnectIT Export Queue, that can be processed and will result in an Export Entry. The table monitor…

Queuing records manually

Processing » Export » Process » Queuing records manually

For the most common tables, there is an export button added to export a selected record. For example on the customer list page and on the customer card page, you can click process, and then ConnectIT: Export (selected). This will add the record(s) to the export queue,…

Primary Keys

Processing » Import » Process » Primary Keys

Insert new records using OnInsert trigger In many cases the value of a primary key field can be set automatically by the code on the insert trigger of the record. For example, when inserting a Sales Header without a value for the No. field, when Run Trigger on Key…

SOAP

Processing » Export » Configuration » Methods » SOAP

To be able to use SOAP, you will first have to to import the WSDL definition for the SOAP service you are planning to use. For more information on this, go here. When the WSDL is imported proceed below: On the SOAP tab of the export definition, select the correct…

Projects

Configuration » Administration » Projects

Available from version xx.5.0.0 Projects can be used to group multiple export and import definitions together. While this can be simply done for administrative purposes, allowing easier filtering on definitions, there are some additional options that are available…

Dropbox

Processing » Import » Configuration » Methods » Dropbox

To set up a Dropbox connection go to the Dropbox Dev page. Select Dropbox API and choose if you want to give the app acces to a specific folder or full Dropbox. Also provide a name for the app. On the page that opens, check the settings and then generate an acces…

General

Processing » General

This section gives information on topics that apply to both import and export.

Authentication

Processing » Import » Configuration » Methods » REST Endpoint » Authentication

There are two ways to authenticate to the webservice. 1. Basic Auth (username + password/ webservice acces key) This method will become obsolete for Business Central on Saas next year. 2. OAuth 2.0 To be able to use OAuth2, first you will need to set up an app…

Azure Storage

Processing » Export » Configuration » Methods » Azure Storage

The following fields are available on the Azure Storage tab: Field Description Azure Storage Connection String Container Name Overwrite Existing Files Container Public Access Type …

Example 2: Output Condition on Field

Processing » Export » Configuration » Filtering and Output Conditions » Example 2: Output Condition on Field

In a customer export there are definition lines for both the Name and Name2 field. In case the Name2 field has a value, I want to show the Name 2 field and not the Name field. If the Name 2 field is empty, I only want to show the Name field. On the Name field I set the…

Endpoints

Configuration » Administration » Endpoints

With the release of ConnectIT 365 XX.4.100309.0 it is now possible to configure multiple destinations for an export definition. These destinations can be configured with the help of Endpoints. ConnectIT 365 will still use the same export flow, however instead of…

Functions

Processing » General » Functions

In this topic all available functions *are explained. The *FieldValue is the value before executing the function on it, while Par1, Par2 *and *Par3 are parameters that can be provided in the import/export function line. For export functions, in some cases it can be…

Tasks (Flow)

Processing » Tasks (Flow)

In ConnectIT you can make Tasks. Tasks can be used for: Send e-mails (body + pdf of report in attachment) Run objects (report or codeunit) Start secondary imports based on a field value in an import definition Start imports sequentionally Overview Import …

Mixed

Processing » Export » Configuration » Methods » Mixed

Method Mixed was introduced in version XX.4.100309.0 to allow the usage of multiple endpoints that use different methods. This method doesn’t contain any additional configuration, but sets the Use Endpoints option to true on the export definition and shows the…

Introduction

Introduction

!Documentation regarding idyn apps is moved to our Confluence space. This manual will no longer be updated. For the updated ConnectIT 365 documentation, please go to this Confluence link. This chapter provides an overview of the document and introduces you to the…

Installation requirements

Introduction » Installation requirements

For installation and usage in an on premise environment the following granules should be added to the Business Central license: Granule ID Name 11148600 ConnectIT Engine 11102170 IDYN ConnectIT Users If a new license…

Export Excel/CSV: Multiple table relations

Configuration » Beta features » Export Excel/CSV: Multiple table relations

*Beta feature available with major release 6 (XX.6.0.0) Before this release, export definitions with data format Excel or CSV were limited to use a maximum of 2 data items (tables). This was due to the unstructured output making it difficult to support more than 1…

FTP

Processing » Export » Configuration » Methods » FTP

The following fields are available on the FTP tab: Field Description Host Name Hostname or IP address for the FTP server. Port Port that is used for the connection to the server. Default for FTP and FTPS is 21, and for SFTP…

REST Endpoint

Processing » Import » Configuration » Methods » REST Endpoint

It is possible to set up and import definition that will serve as a POST, PUT and DELETE endpoint, to be used by external systems. The external party will have to do a POST, PUT or DELETE call to https://connectitapi.idyn.nl/api/WebServices/[methodhere], using the…

CSV

Processing » Import » Configuration » Data Formats » CSV

When Flatten Data is enabled, the following fields are available: When Flatten Data is disabled, more fields will be visible to identify which lines should be linked to the parent and child table:

Constant Values

Processing » Import » Configuration » Constant Values

On the Import Definition card page, the Constant Values can be configured. These lines are used to import data that is not (directly) available in the import message. Here constant values and functions can be used to set field values. Field Description…

Export deleted records

Processing » Export » Process » Export deleted records

When exporting a record when it is deleted, the export entry will be created directly as opposed to the record being added to the export queue first and processed later. However, there is always a chance a delete fails (for example because for some reason the record…

Intercompany

Processing » Import » Configuration » Methods » Intercompany

Available from version xx.5.0.0 To allow intercompany synchronization, the import definition that receives the import also needs to be configured with method Intercompany. This allows the export process in the source company to process the export entry on an import…

Usage

Configuration » Administration » Endpoints » Usage

After the Endpoint configuration is completed, the endpoints can be selected from the Export Definition card. Select option Use Endpoints or use method Mixed (this method will automatically set the option Use Endpoints to true. A new tab will be visible where the…

Definition lines

Processing » Export » Configuration » Definition lines

On the Export Definition card page, the Definition Lines can be configured. These lines are used to create the content of the export. Field Description Type Specifies the line type. The following values are available: Data…

Scheduling: Advanced recurrence options

Configuration » Beta features » Scheduling: Advanced recurrence options

*Beta feature available with major release 6 (XX.6.0.0) Before this release, every export and import definition had a single schedule with similar options as the job queue entries. If multiple schedules were required (for instance to reduce impact during office…

Conversions

Configuration » Administration » Conversions

In many cases, values in your database are different from how you receive them, or have to be delivered to another party differently. This is where conversions come in handy. You can create as many conversions as you please. The below example shows an conversion of…

Frequently used

Processing » General » Functions » Frequently used

Below you will find functions that in our experience are used frequently. The combination of SETTEMPVAL and GETTEMPVAL is used in almost every definition. A common situation in export definitions is that values from fields in a record are needed, but the dataitem…

Values

Processing » General » Values

There are a number of values available to use in filenames or REST URLs without needed to write extra code in event subscribers. Below all available values are listed. Filename Only [EntryNo.] – The number of the exported export entry. [DefintionNo.] – The…

Import

Key Usage Scenario » Import

This section describes ConnectIT’s import functionality. Item import from a JSON file Open the import definition list. Role center -> Import -> Example Definitions. Open Ixport Definition ‘E-0006’ (‘item’). Activate the export by…

Intercompany

Processing » Export » Configuration » Methods » Intercompany

Available from version xx.5.0.0 The intercompany method is used to synchronize data between companies in the same BC environment. By choosing the intercompany method, the Intercompany section will be visible on the export definition page. For this method, 3…

Export Events

Technical documentation » Events » Export Events

General Events with a ‘Handled’ parameter can be used to fully override ConnectIT code. If you set handled to ‘true’, ConnectIT will stop code execution and leave everything to the subscriber. Parameters of type ‘Variant’ contain…

REST

Processing » Import » Configuration » Methods » REST

The following REST fields are available on the import definition card: General Field Description URL Specifies the URL for the REST request. Can be used in combination with temporary values to create a dynamic request URL. …

Import Events

Technical documentation » Events » Import Events

General Events with a ‘Handled’ parameter can be used to fully override ConnectIT code. If you set handled to ‘true’, ConnectIT will stop code execution and leave everything to the subscriber. Parameters of type ‘Variant’ contain…

Definition Lines

Processing » Import » Configuration » Definition Lines

On the Import Definition card page, the Definition Lines can be configured. These lines are used to read the content of the import. Field Description External Property Name Type Specifies the line type. The following…