Create a Data Mapper Definition which is used to map data (i.e. in the format from the database) to the CDQ data model.
Data mapper definition consists of:
inputMapping
- definition how to map businessPartner.record
to CDQ data modeloutputMapping
- definition how to map CDQ data model to the target modelBusiness partner can be mapped via businessPartnerAttributeMappings
.
The following values of attribute mapping rules:
can be mapped to Business Partner attributes:
The index of typed concepts: names and identifiers, is not a final position of concept in the CDQ data model - this is a grouping indicator for a set of concept properties.
In Names mapping, in case none of names is typed LOCAL and exists any name with empty type or not filled type.technicalKey, it becomes name of type LOCAL.
Addresses can be mapped via addressesAttributeMappings
. Address receives id
property coming from an index of the collection of AttributeMappingRules.
The following values of attribute mapping rules
can be mapped to address attributes:
OK
{- "name": "string",
- "labels": [
- "string"
], - "shareWithOrganization": true,
- "valueMappings": [
- {
- "sourceValue": "string",
- "targetValue": "string",
- "targetAttribute": "string"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
{- "id": "string",
- "createdAt": "string",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "string",
- "modifiedAt": "2020-08-31T16:47+00:00",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "string",
- "creatorOrganization": "string",
- "shareWithOrganization": true,
- "labels": [
- "Custom Storage Name"
], - "name": "My Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "string",
- "targetValue": "string",
- "targetAttribute": "string"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
{- "id": "string",
- "createdAt": "string",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "string",
- "modifiedAt": "2020-08-31T16:47+00:00",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "string",
- "creatorOrganization": "string",
- "shareWithOrganization": true,
- "labels": [
- "Custom Storage Name"
], - "name": "My Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "string",
- "targetValue": "string",
- "targetAttribute": "string"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
OK
{- "numberOfPages": "10",
- "page": "1",
- "pageSize": "100",
- "total": "67",
- "values": [
- {
- "id": "string",
- "createdAt": "string",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "string",
- "modifiedAt": "2020-08-31T16:47+00:00",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "string",
- "creatorOrganization": "string",
- "shareWithOrganization": true,
- "labels": [
- "Custom Storage Name"
], - "name": "My Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "string",
- "targetValue": "string",
- "targetAttribute": "string"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": null,
- "parameters": [ ]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- null
], - "targetAttributes": [
- null
], - "targetAttributeTypes": [
- null
], - "countryScopes": [
- null
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- null
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": null,
- "parameters": [ ]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- null
], - "targetAttributes": [
- null
], - "targetAttributeTypes": [
- null
], - "countryScopes": [
- null
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- null
]
}
]
]
}
}
]
}
Update Data Mapper Definition. For more information what are the allowed Data Mapper values, go to creation endpoint description.
OK
{- "name": "string",
- "labels": [
- "string"
], - "shareWithOrganization": true,
- "valueMappings": [
- {
- "sourceValue": "string",
- "targetValue": "string",
- "targetAttribute": "string"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
{- "id": "string",
- "createdAt": "string",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "string",
- "modifiedAt": "2020-08-31T16:47+00:00",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "string",
- "creatorOrganization": "string",
- "shareWithOrganization": true,
- "labels": [
- "Custom Storage Name"
], - "name": "My Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "string",
- "targetValue": "string",
- "targetAttribute": "string"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "string",
- "sourceAttributes": [
- "string"
], - "targetAttributes": [
- "string"
], - "targetAttributeTypes": [
- "string"
], - "countryScopes": [
- "string"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": true,
- "valueMapping": "string",
- "defaultValue": "string",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}