Business Integration Solutions documentation

How to: Determine transaction type

This task explains the Transaction Type functionality in Business Integration Solutions.

Data from Microsoft Dynamics NAV is often exported with changes. Based on the type of change (Insert, Modify, Delete, or Rename) you may want to take further actions.

Business Integration Solutions has a built-in Transaction Type functionality. The data source manager receives the record change type information. To find the type of change, check the value in the NAVRecordChangeType property of the message at the receiving end.

The XML Generator activity includes the value of this property as an optional attribute.

Transaction types

The following table illustrates the various transaction types and their meaning:

NAV Record Change Type Description
Insert A new record was inserted.
Delete An existing record was deleted.
Modify An existing record was modified.
Delete and Insert If the primary key of an existing record is renamed, the system treats it as a delete and an insert operation. The exported message shows the old record as deleted and the new record as inserted.

Transaction Type

Example

  1. Create an internal document to export item data.
  2. Based on the document, create a simple connection with a Record Change Event, XML Generator, and a File Writer endpoint as shown in the example. Export Pipeline
  3. Select all log options (Log Insert, Log Modify, Log Delete, and Log Rename) for the Record Change Event.
  4. On the Item list page, perform the following actions and process the connection after each action to view the results:
Action Example Result
Create a new item. Item No.: 70061; Description: Item Series 01. A file exports with NavRecordChangeType = insert.
Delete an existing item. Delete item 70061 created in the previous step. A file exports with NavRecordChangeType = delete. Note that only primary key details are available.
Modify an existing item. Change the description of Item No.: 70001 (Base). A file exports with NavRecordChangeType = modify. Note the modifications.
Rename the primary key of an existing item. Rename Item No.: 70000 (Side Panel). Change the No. to: M_70000. A file exports with NavRecordChangeType = delete for Item No. 70000 and NavRecordChangeType = insert for Item No. M_70000.

With the Transaction Type functionality, you can check the message at the receiving end and determine the type of transaction.