______________________________________________________________________________________________________
We have Two Options to include ZIW Columns in the pipelines:
Option 1: To include Ziw columns through pipeline import API( REST API)
https://docs.infoworks.io/infoworks-rest-api-v3/ref#exportpipelineconfiguration -> export pipeline configuration
https://docs.infoworks.io/infoworks-rest-api-v3/ref#importpipelineconfiguration -> import pipeline configuration
To include the ziw audit column in the target, while importing, in the request body, you need to add the ziw column names in the output entities section in the Target node.(as shown in screenshot below).
Example:
{
"id": "72dda082-6e0e-4088-98be-cec2f11b7232",
"name": "ziw_target_timestamp",
"entity_type": "COLUMN",
"mapping": {
"reference_type": "NODE_OUTPUT",
"reference_index": 0
},
"entity_attributes": {
"column_type": [
"IS_AUDIT"
],
"is_excluded": false
}
}
,
{
"id": "95d55c9a-883c-40e3-8586-5c9d689440a7",
"name": "ziw_is_deleted",
"entity_type": "COLUMN",
"mapping": {
"reference_type": "NODE_OUTPUT",
"reference_index": 0
},
"entity_attributes": {
"column_type": [
"IS_AUDIT"
],
"is_excluded": false
}
}
After importing pipeline config,we can see ziw columns appear in pipeline target as audit columns.
Option 2: Through Derive node option to add ziw columns from UI
We can add derivations in the pipeline to include ziw column
We need to add the required ziw column name and expression as 1( as shown in screenshot below).