REST APIで新しい動的マッピングタスクを作成するには、次の要求を使用できます。
POST https://na1.dm-us.informaticacloud.com/batch-mapping/api/v1/dynamictask
Content-Type: application/json
Accept: application/json
IDS-SESSION-ID: jpaybAKQMsmdt7vLJ02z0s
{
"orgId": "2ij4X7Pd63ibnquEQyy9wA",
"name": "DMT_API",
"description": "",
"mappingId": "01003Y1700000000005X",
"mappingDocType": "MAPPING",
"runtimeEnvironmentId": "01003Y25000000000004",
"scheduleId": null,
"state": "VALID",
"groups": [
{
"groupName": "Group_1",
"enabled": true
},
{
"groupName": "Group_2",
"enabled": false
}
],
"parameters": [
{
"uniqueName": "Source:SrcCon",
"name": "SrcCon",
"txName": "Source",
"type": "SOURCE_CONNECTION",
"scope": "DEFAULT",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "Source:SrcObj",
"name": "SrcObj",
"txName": "Source",
"type": "SOURCE_OBJECT",
"scope": "LOCAL",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "Target:TrgCon",
"name": "TrgCon",
"txName": "Target",
"type": "TARGET_CONNECTION",
"scope": "DEFAULT",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "Target:TrgObj",
"name": "TrgObj",
"txName": "Target",
"type": "TARGET_OBJECT",
"scope": "LOCAL",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "Lookup:Lkcon",
"name": "Lkcon",
"txName": "Lookup",
"type": "LOOKUP_CONNECTION",
"scope": "DEFAULT",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "Lookup:lkObj",
"name": "lkObj",
"txName": "Lookup",
"type": "LOOKUP_OBJECT",
"scope": "DEFAULT",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "Lkp",
"name": "Lkp",
"txName": null,
"type": "EXPRESSION",
"scope": "LOCAL",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
},
{
"uniqueName": "ExParam",
"name": "ExParam",
"txName": null,
"type": "EXPRESSION",
"scope": "LOCAL",
"label": null,
"description": "",
"retentionPolicy": null,
"aggregationType": null
}
],
"jobs": [
{
"jobUUID": "ae1lR3k2ccYgXNeFQe4DIT",
"jobName": "<Default>",
"jobType": "DEFAULT",
"enabled": false,
"stopOnError": false,
"stopOnWarning": false,
"preProcessingCmds": [],
"postProcessingCmds": [],
"advSessionProperties": {},
"paramValueBindings": [
{
"type": "Connection",
"paramDefnRef": "Source:SrcCon",
"connectionId": "01003Y0B000000000006",
"connectionType": null,
"runtimeAttrs": {},
"oprRuntimeAttrs": {}
},
{
"type": "Connection",
"paramDefnRef": "Target:TrgCon",
"connectionId": "01003Y0B00000000001Q",
"connectionType": null,
"runtimeAttrs": {},
"oprRuntimeAttrs": {}
},
{
"type": "Connection",
"paramDefnRef": "Lookup:Lkcon",
"connectionId": "01003Y0B00000000001Q",
"connectionType": null,
"runtimeAttrs": {},
"oprRuntimeAttrs": {}
},
{
"type": "Source",
"paramDefnRef": "Lookup:lkObj",
"sourceObject": {
"name": "EMP",
"label": "EMP",
"metadataUpdated": false
},
"advancedFilterExpression": null,
"userDefinedJoin": null,
"filterFields": [],
"sortFields": [],
"srcFFAttrs": null,
"overriddenFields": [],
"ccmDataFormat": null,
"customQuery": null,
"handleSpecialChars": false,
"runtimeAttrs": {},
"oprRuntimeAttrs": {}
}
],
"group": null
},
{
"jobUUID": "21rswJo8MnOgUTtfCq96AR",
"jobName": "Job_1",
"jobType": "USER",
"enabled": true,
"stopOnError": false,
"stopOnWarning": false,
"preProcessingCmds": [],
"postProcessingCmds": [],
"advSessionProperties": {},
"paramValueBindings": [
{
"type": "Source",
"paramDefnRef": "Source:SrcObj",
"sourceObject": {
"name": "employee.csv",
"label": "employee.csv",
"metadataUpdated": false
},
"advancedFilterExpression": null,
"userDefinedJoin": null,
"filterFields": [],
"sortFields": [],
"srcFFAttrs": null,
"overriddenFields": [],
"ccmDataFormat": null,
"customQuery": null,
"handleSpecialChars": false,
"runtimeAttrs": {},
"oprRuntimeAttrs": {}
},
{
"type": "Target",
"paramDefnRef": "Target:TrgObj",
"objectName": "CONTACT",
"objectLabel": "CONTACT",
"newObjectName": null,
"truncateTarget": false,
"bulkApiDBTarget": false,
"operationType": null,
"tgtFieldRefs": {},
"targetUpdateColumns": [],
"tgtFFAttrs": null,
"tgtObjectAttributes": {},
"runtimeAttrs": {},
"oprRuntimeAttrs": {},
"handleSpecialChars": false,
"ccmDataFormat": null,
"dynamicFileName": false
},
{
"type": "String",
"paramDefnRef": "Lkp",
"text": " EMP_ID||EMP_NAME"
},
{
"type": "String",
"paramDefnRef": "ExParam",
"text": " IsNull(EMP_ID)"
}
],
"group": "Group_1"
},
{
"jobUUID": "6pavcOH4kwZewe1XL1khoF",
"jobName": "Job_2",
"jobType": "USER",
"enabled": true,
"stopOnError": false,
"stopOnWarning": false,
"preProcessingCmds": [],
"postProcessingCmds": [],
"advSessionProperties": {},
"paramValueBindings": [
{
"type": "Source",
"paramDefnRef": "Source:SrcObj",
"sourceObject": {
"name": "Boston_Customers.csv",
"label": "Boston_Customers.csv",
"metadataUpdated": false
},
"advancedFilterExpression": null,
"userDefinedJoin": null,
"filterFields": [],
"sortFields": [],
"srcFFAttrs": null,
"overriddenFields": [],
"ccmDataFormat": null,
"customQuery": null,
"handleSpecialChars": false,
"runtimeAttrs": {},
"oprRuntimeAttrs": {}
},
{
"type": "Target",
"paramDefnRef": "Target:TrgObj",
"objectName": "CUSTINFO_TYPE",
"objectLabel": "CUSTINFO_TYPE",
"newObjectName": null,
"truncateTarget": false,
"bulkApiDBTarget": false,
"operationType": null,
"tgtFieldRefs": {},
"targetUpdateColumns": [],
"tgtFFAttrs": null,
"tgtObjectAttributes": {},
"runtimeAttrs": {},
"oprRuntimeAttrs": {},
"handleSpecialChars": false,
"ccmDataFormat": null,
"dynamicFileName": false
},
{
"type": "String",
"paramDefnRef": "Lkp",
"text": "NAME=Firstname"
},
{
"type": "String",
"paramDefnRef": "ExParam",
"text": "Firstname||Lastname"
}
],
"group": "Group_2"
}
]
}
