Node Attributes Summary

Processing Attributes

Attribute Description
NodeType The type of Node. The possible values are defined in the next section.
NodeAction Based on the Node type, a list of valid actions that can be performed.
DALAssemblyName The Data Access Layer Component Assembly name. If the assembly is signed, the version number, culture, and PublicKeyToken must be specified (e.g., FlexNet.DataServices.Product, Version=8.0.0.0, Culture=neutral, PublicKeyToken=33f692327842122b).
DALFactoryName The name of the factory class defined in the DAL Component specified by the DALAssemblyName attribute (e.g., FlexNet.DataServices.Product.ProductFactory).
SelectUniqueMethodName The method name defined in the DAL Component specified by the DALAssemblyName attribute that returns a unique record.
ActualNodeName Since BizTalk Editor can only import XDR, all XSD schemas are converted to XDR. XDR has a limitation in which one Node name can only have one definition. For instance, OperationCode is a field as well as a table. See the Using Field Node type with GetNewValue Node Action section for more information.
NodeVariable During runtime, a variable with the name specified in this attribute is created at the time that the current Node is being processed.
FetchFieldName During runtime, the value from the column specified by this attribute is retrieved and assigned to the variable defined in the NodeVariable attribute.

Node Types

A list of all of the valid values for the NodeType attribute:

Type Description
Table This Node type is used only if a Table Node Action is required.
Field This Node type is used only if a Field Node Action is required.
FIInvocation The sub-schema for this Node type must be valid against FIInvocationSynchronousEvent.xsd. The values are extracted and converted to parameters and other required fields to invoke a Standard Operation via FI API.
FIInvocationBGTask The sub-schema for this Node type must be valid against FIInvocationAsynchronousEvent.xsd. A new job is created with job Action Type 1 ("Invoke Standard Operation"). The parameter for this job action is the values extracted.
JobCreation The sub-schema for this Node type must be valid against JobCreationEvent.xsd. A new job is created with the information specified in the XML.
JEJobCreation The sub-schema for this Node type must be valid against the JEJobCreationEvent.xsd. A new Job Executor job is created with information specified in the XML.

Node Action for Table Node Type

A list of all of the valid values for NodeAction when the NodeType is Table:

Action Description
InsertOnly If the database table row does not exist, an insert action is performed. Otherwise, nothing happens.
UpdateOnly If the database table row exists, an update action is performed. Otherwise, nothing happens.
DeleteOnly If the database table row exists, a delete action is performed. Otherwise, nothing happens.
InsertUpdate If the database table row does not exist, an insert action is performed. Otherwise, an update is performed.
UpdateAll Updates all of the rows returned by the DAC method specified by SelectUniqueMethodName.

Node Action for Field Node Type

A list of all of the valid values for NodeAction when the NodeType is equal to Field:

Action Description
GetValue Gets a value by selecting the column specified by the FetchFieldName attribute from the database with the attributes fields defined for the same Field Node. An exception will occur if no records are found when all of the attribute fields have values.
GetParentValue Gets a value with the name defined in the NodeVariable attribute from the memory in the current scope.
GetNewValue Gets a new value with the name defined in the FetchFieldName attribute by processing the child table if database table row exists.
GetRequiredValue The same functionality as GetValue, but an exception will occur when the selected column value is null or an empty string.
DateException The "DateException" attribute is accessible from the ColumnDefinition collection. By default, the value for the DateException attribute is blank. The user can select from a fixed drop-down list. The current supported value is "NoUTCConversion". Only when DateException has a value is the following generated:

<xs:attribute name="DateException" type="xs:string" use="required" fixed="NoUTCConversion"/>

For example:

<xs:element name="MinimumExpirationDate" minOccurs="0">
 <xs:complexType>
   <xs:attribute name="DateException" type="xs:string" use="required" fixed="NoUTCConversion"/>
 </xs:complexType>
</xs:element>

GetNewGUID Gets a new GUID value.