Business Integration Solutions Documentation

How to: Determine Transaction Type

This task explains the use of the Transaction Type functionality in Business Integration Solution.

Many a times data from Microsoft Dynamics NAV is exported with some changes, and based on the type of change (Insert/Modify/Delete/Rename) a user would like to take further actions.

The Business Integration Solution has a built-in Transaction Type functionality, which means that the data source manager is provided with the record change type information. To know the type of change, you can check the value in 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 tables illustrates various transaction types and their meaning:

NAV Record Change Type Description

Insert

This value shows that a new record was inserted.

Delete

This value shows that an existing record was deleted.

modify

This value shows that an existing record was modified.

Delete and Insert

If the primary key of an existing record is renamed, then the system perceives it as a delete and an insert operation, therefore the exported message will show 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 possibilities (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 is exported with the NavRecordChangeType = insert.

    Delete an existing Item.

    Delete the item (70061) created in previous step.

    A file is exported with the NavRecordChangeType = delete. Note that only the primary key details are available.

    Modify an existing item.

    Change the description of Item No.: 70001 (Base).

    A file is exported with the NavRecordChangeType = modify. Note the modifications as well.

    Rename the primary key of an existing item.

    Rename Item No.: 70000 (Side Panel). Change the No. to: M_70000

    A file is exported with NavRecordChangeType = delete for Item No. 70000 and NavRecordChangeType = insert for Item No. M_70000.

    With the Transaction Type functionality, a user can look into the message at the receiving end and determine the type of transaction.