This Snap Updates an existing record in the Dynamics AX instance.

ETL Transformations & Data Flow

This Snap enables the following ETL operations or flows:

• Extract data from the upstream snap containing the data for updating the Dynamics AX object(s)
• Transform the input document into a SnapLogic friendly JSON Document
• Load the data into the Dynamics AX Update Snap to update the AX object(s)

Expected upstream Snaps: Mapper Snap

Expected downstream Snaps: None

Input & Output

• Input: Needs to have an upstream Snap that contains the mandatory fields for updating the existing AX object. Mapper snap is a preferred upstream snap as it populates the input schema for the selected Dynamics AX Object Type.
  
  
• Output: A document with the result set. If the update is successful, then the output document will contain the IDs of the updated AX object(s)

Modes

• Ultra Pipelines: Works in Ultra Tasks.

1. Microsoft Dynamics AX 2012 R3 instance

2. An enhanced integration inbound port on the AX instance that containing the Update operation configured

NA

Account & Access

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring Microsoft Dynamics AX Accounts [Deprecated] for information on setting up this type of account.

Views

Required. The object type on which to perform the read operation. The value of the property depends on the object types contained in the target inbound port.

Example: Customer

Required. The field name of the record's Id. The field names are different among different object types. It reflects the EntityKey.field in the AIF request. See: https://msdn.microsoft.com/en-us/library/aa638403(v=ax.10).aspx

The Id Key property is suggestible and:

• The Object type must support the findKeys operation.
• The findKeys operation must be included in the inbound port.
• There must be at least one record of the object type in the corresponding company (or DAT if not given).

The property can be provided through user input or pipeline parameters.

Example: AccountNum

Required. The value of the record's Id. It reflects the EntityKey.value in the AIF request. See: https://msdn.microsoft.com/en-us/library/aa638403(v=ax.10).aspx

When no Id value is provided, the Snap lists out all the records for the given object type. However, to read a large data sets, you can use the Search Snap.