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:
Request to create a new Data Mapper Definition.
OK
{- "name": "Custom Data Mapper Definition",
- "labels": [
- "Custom Data Mapper Label"
], - "shareWithOrganization": "true",
- "valueMappings": [
- {
- "sourceValue": "en",
- "targetValue": "INTERNATIONAL",
- "targetAttribute": "address.version.characterSet"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
{- "id": "6440dba32b30176c5917b1b7",
- "createdAt": "2024-11-09T17:01:13Z",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "2024-11-09T17:01:13Z",
- "modifiedAt": "2024-11-09T17:01:13Z",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "john.doe",
- "creatorOrganization": "cdq",
- "shareWithOrganization": "true",
- "labels": [
- "Custom Storage Name"
], - "name": "Custom name of Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "en",
- "targetValue": "INTERNATIONAL",
- "targetAttribute": "address.version.characterSet"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
{- "id": "6440dba32b30176c5917b1b7",
- "createdAt": "2024-11-09T17:01:13Z",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "2024-11-09T17:01:13Z",
- "modifiedAt": "2024-11-09T17:01:13Z",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "john.doe",
- "creatorOrganization": "cdq",
- "shareWithOrganization": "true",
- "labels": [
- "Custom Storage Name"
], - "name": "Custom name of Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "en",
- "targetValue": "INTERNATIONAL",
- "targetAttribute": "address.version.characterSet"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
Read the Data Mapper Definition Page.
OK
{- "numberOfPages": "10",
- "page": "1",
- "pageSize": "100",
- "total": "67",
- "values": [
- {
- "id": "6440dba32b30176c5917b1b7",
- "createdAt": "2024-11-09T17:01:13Z",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "2024-11-09T17:01:13Z",
- "modifiedAt": "2024-11-09T17:01:13Z",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "john.doe",
- "creatorOrganization": "cdq",
- "shareWithOrganization": "true",
- "labels": [
- "Custom Storage Name"
], - "name": "Custom name of Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "en",
- "targetValue": "INTERNATIONAL",
- "targetAttribute": "address.version.characterSet"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": null,
- "parameters": [ ]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- null
], - "targetAttributes": [
- null
], - "targetAttributeTypes": [
- null
], - "countryScopes": [
- null
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- null
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": null,
- "parameters": [ ]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- null
], - "targetAttributes": [
- null
], - "targetAttributeTypes": [
- null
], - "countryScopes": [
- null
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- null
]
}
]
]
}
}
]
}
Update Data Mapper Definition. For more information what are the allowed Data Mapper values, go to creation endpoint description.
Request to create a new Data Mapper Definition.
OK
{- "name": "Custom Data Mapper Definition",
- "labels": [
- "Custom Data Mapper Label"
], - "shareWithOrganization": "true",
- "valueMappings": [
- {
- "sourceValue": "en",
- "targetValue": "INTERNATIONAL",
- "targetAttribute": "address.version.characterSet"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}
{- "id": "6440dba32b30176c5917b1b7",
- "createdAt": "2024-11-09T17:01:13Z",
- "createdBy": "76248934691294444",
- "lastUpdatedAt": "2024-11-09T17:01:13Z",
- "modifiedAt": "2024-11-09T17:01:13Z",
- "modifiedBy": "76248934691294444",
- "creatorUsername": "john.doe",
- "creatorOrganization": "cdq",
- "shareWithOrganization": "true",
- "labels": [
- "Custom Storage Name"
], - "name": "Custom name of Data Mapper",
- "valueMappings": [
- {
- "sourceValue": "en",
- "targetValue": "INTERNATIONAL",
- "targetAttribute": "address.version.characterSet"
}
], - "inputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}, - "outputMapping": {
- "businessPartnerAttributeMappings": [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- {
- "key": null,
- "value": null
}
]
}
]
}
], - "addressesAttributeMappings": [
- [
- {
- "sourceConstant": "LOCAL",
- "sourceAttributes": [
- "Name"
], - "targetAttributes": [
- "businessPartner.names[0].value"
], - "targetAttributeTypes": [
- "BUSINESS_PARTNER_NAME_TYPE_LOCAL"
], - "countryScopes": [
- "DE"
], - "selectionType": "COMMA",
- "separationType": "LENGTH",
- "isMandatoryAttribute": "true",
- "valueMapping": "INTERNATIONAL",
- "defaultValue": "GB",
- "transformations": [
- {
- "type": "UPPER_CASE",
- "parameters": [
- null
]
}
]
}
]
]
}
}