We can remove Null/Empty tags from the Siebel Message using Data Maps.
Any Integration Component Fields which are mapped to System Fields will be removed from the Siebel Message after the data map is executed.
We use the same to our advantage to remove Empty/NULL tags from the Siebel Message before processing.
Use the syntax below to map the Integration Component field to a system field if it has NULL values or else retain the value in a datamap.
Specify the below syntax in the Source Search Expression in the Integration Component Field map.
Example:
We want to remove the [Account Status] tag from the Siebel Message if it contains NULL values.
Then, we can put the below statement in the Source Search Specification.
IIF([Account Status] IS NULL, [Created By], [Account Status])
If, the [Account Status] field has Null Value, it will get mapped to [Created By] which is a system field and finally gets removed from the Siebel Message.
Note: Make sure the [Created By] field is Active in the Integration Object.
Any Integration Component Fields which are mapped to System Fields will be removed from the Siebel Message after the data map is executed.
We use the same to our advantage to remove Empty/NULL tags from the Siebel Message before processing.
Use the syntax below to map the Integration Component field to a system field if it has NULL values or else retain the value in a datamap.
Specify the below syntax in the Source Search Expression in the Integration Component Field map.
Example:
We want to remove the [Account Status] tag from the Siebel Message if it contains NULL values.
Then, we can put the below statement in the Source Search Specification.
IIF([Account Status] IS NULL, [Created By], [Account Status])
If, the [Account Status] field has Null Value, it will get mapped to [Created By] which is a system field and finally gets removed from the Siebel Message.
Note: Make sure the [Created By] field is Active in the Integration Object.
