Save Enrichment Mapping
The Save Enrichment Mapping operation.
Request
POST: {dnbConnectorUrl}/config/profiles/{profile}/mappings/enrichment| Parameter | Name | Required | Description |
|---|---|---|---|
Headers |
Content-Type | Yes | Should be Content-Type:application/json. |
Headers |
Authorization | Yes | Information about authentication access token in format Bearer
<accessToken>. |
Path |
profile | Yes | Profile Name. |
Body |
Yes | Enrichment mapping JSON |
Body
[
{
"operation": "shift",
"spec": {
"OrderProductResponse": {
"OrderProductResponseDetail": {
"Product": {
"Organization": {
"#configuration/sources/DnB": "[4].crosswalks[0].type",
"#Real Time": "[4].attributes.DnBSource[].value",
"SubjectHeader": {
"DUNSNumber": [
"[4].attributes.DUNSNumber[].value",
"[4].crosswalks[0].value"
],
"MarketabilityIndicator": "[4].attributes.MarketabilityIndicator[].value",
"LastUpdateDate": {
"\\$": "[4].attributes.DnBLastUpdateDate[].value"
},
"OrganizationSummaryText": "[4].attributes.OrganizationSummaryText[].value",
"TransferDUNSNumberRegistration": {
"*": {
"TransferDate": {
"\\$": "[4].attributes.PriorDUNSNUmber[&2].value.TransferDate[].value"
},
"TransferredFromDUNSNumber": "[4].attributes.PriorDUNSNUmber[&1].value.TransferredFromDUNSNumber[].value",
"TransferredToDUNSNumber": "[4].attributes.PriorDUNSNUmber[&1].value.TransferredToDUNSNumber[].value",
"TransferReasonText": {
"*": {
"\\@DNBCodeValue": "[4].attributes.PriorDUNSNUmber[&3].value.TransferReasonCode[&1].value",
"\\$": "[4].attributes.PriorDUNSNUmber[&3].value.TransferReasonText[&1].value"
}
}
}
}
},
"OrganizationName": {
"OrganizationPrimaryName": {
"*": {
"OrganizationName": {
"\\$": "[4].attributes.Name[].value"
}
}
},
"TradeStyleName": {
"*": {
"OrganizationName": {
"\\$": "[4].attributes.TradeStyleName[&2].value.OrganizationName[].value"
}
}
},
"FormerOrganizationPrimaryName": {
"*": {
"OrganizationName": {
"\\$": "[4].attributes.TradeStyleName[&2].value.FormerOrganizationPrimaryName[].value"
}
}
}
},
"Telecommunication": {
"TelephoneNumber": {
"*": {
"TelecommunicationNumber": "[5].sa.Phone[&1].value.Number[].value",
"UnreachableIndicator": "[5].sa.Phone[&1].value.Unreachable[].value",
"InternationalDialingCode": "[5].sa.Phone[&1].value.CountryCode[].value",
"#Phone": "[5].sa.Phone[&1].value.Type[].value",
"#true": "[5].sa.Phone[&1].value.PrimaryPhoneFlag[].value"
}
},
"FacsimileNumber": {
"*": {
"TelecommunicationNumber": "[5].ma.Phone[&1].value.Number[].value",
"UnreachableIndicator": "[5].ma.Phone[&1].value.Unreachable[].value",
"InternationalDialingCode": "[5].ma.Phone[&1].value.CountryCode[].value",
"#Fax": "[5].ma.Phone[&1].value.Type[].value",
"#true": "[5].ma.Phone[&1].value.PrimaryPhoneFlag[].value"
}
},
"WebPageAddress": {
"*": {
"TelecommunicationAddress": {
"@": "[4].attributes.WebsiteURL[].value"
}
}
}
},
"OrganizationDetail": {
"StandaloneOrganizationIndicator": "[4].attributes.OrganizationDetail[0].value.Standalone[].value",
"FamilyTreeMemberRole": {
"*": {
"FamilyTreeMemberRoleText": {
"\\$": "[4].attributes.OrganizationDetail[0].value.MemberRole[&2].value"
}
}
},
"ControlOwnershipDate": {
"\\$": "[4].attributes.OrganizationDetail[0].value.OwnershipDate[].value"
},
"ControlOwnershipTypeText": {
"\\$": "[4].attributes.OrganizationDetail[0].value.OwnershipType[].value"
},
"BoneyardOrganizationIndicator": "[4].attributes.OrganizationDetail[0].value.BoneyardOrganization[].value",
"OperatingStatusText": {
"\\$": "[4].attributes.OrganizationDetail[0].value.OperatingStatus[].value"
},
"OrganizationStartYear": "[4].attributes.OrganizationDetail[0].value.StartYear[].value",
"FranchiseOperationTypeText": {
"\\$": "[4].attributes.OrganizationDetail[0].value.FranchiseOperationType[].value"
},
// not verified yet
"OperatingStatusComment": {
"OperatingStatusFreeFormComment": {
"\\$": "[4].attributes.OrganizationDetail[0].value.OperatingStatusComment[].value"
}
}
},
"Location": {
"PrimaryAddress": {
"*": {
"StreetAddressLine": {
"0": {
"LineText": "[5].sa.Addresses[&3].value.AddressLine1[].value"
},
"1": {
"LineText": "[5].sa.Addresses[&3].value.AddressLine2[].value"
},
"#Shipping": "[5].sa.Addresses[&2].value.AddressType[].value",
"#true": "[5].sa.Addresses[&2].value.Primary[].value",
"@(1,PostalCode)": "[5].sa.Addresses[&2].value.PostalCode[].value",
"@(1,PrimaryTownName)": "[5].sa.Addresses[&2].value.City[].value",
"@(1,TerritoryOfficialName)": "[5].sa.Addresses[&2].value.StateProvince[].value",
"@(1,LatitudeMeasurement)": "[5].sa.Addresses[&2].value.DnBLatitude[].value",
"@(1,LongitudeMeasurement)": "[5].sa.Addresses[&2].value.DnBLongitude[].value",
"@(1,RegisteredAddressIndicator)": "[5].sa.Addresses[&2].value.Registered[].value",
"@(1,ResidentialAddressIndicator)": "[5].sa.Addresses[&2].value.Residential[].value",
"@(1,CountryISOAlpha2Code)": "[5].sa.Addresses[&2].value.Country[].value"
},
"PremisesDetail": {
"*": {
"PremisesAreaMeasurement": "[4].attributes.FacilitySizeInSqFeet[].value"
}
}
}
},
"MailingAddress": {
"*": {
"StreetAddressLine": {
"0": {
"LineText": "[5].ma.Addresses[&3].value.AddressLine1[].value"
},
"1": {
"LineText": "[5].ma.Addresses[&3].value.AddressLine2[].value"
},
"#Mailing": "[5].ma.Addresses[&2].value.AddressType[].value",
"@(1,PostalCode)": "[5].ma.Addresses[&2].value.PostalCode[].value",
"@(1,PrimaryTownName)": "[5].ma.Addresses[&2].value.City[].value",
"@(1,TerritoryOfficialName)": "[5].ma.Addresses[&2].value.StateProvince[].value",
"@(1,LatitudeMeasurement)": "[5].ma.Addresses[&2].value.DnBLatitude[].value",
"@(1,LongitudeMeasurement)": "[5].ma.Addresses[&2].value.DnBLongitude[].value",
"@(1,RegisteredAddressIndicator)": "[5].ma.Addresses[&2].value.Registered[].value",
"@(1,ResidentialAddressIndicator)": "[5].ma.Addresses[&2].value.Residential[].value",
"@(1,CountryISOAlpha2Code)": "[5].ma.Addresses[&2].value.Country[].value"
},
"PremisesDetail": {
"*": {
"PremisesAreaMeasurement": "[4].attributes.FacilitySizeInSqFeet[].value"
}
}
}
}
},
"Financial": {
"KeyFinancialFiguresOverview": {
"*": {
"StatementHeaderDetails": {
"FinancialStatementToDate": {
"\\$": "[4].attributes.KeyFinancialFiguresOverview[&3].value.FinancialStatementToDate[].value"
},
"FinancialPeriodDuration": "[4].attributes.KeyFinancialFiguresOverview[&2].value.FinancialPeriodDuration[].value"
},
"SalesRevenueAmount": {
"*": {
"\\@CurrencyISOAlpha3Code": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueCurrencyCode[&1].value",
"\\@ReliabilityText": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueReliabilityCode[&1].value",
"\\@UnitOfSize": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueUnitOfSize[&1].value",
"\\$": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueAmount[&1].value"
}
},
"ProfitOrLossAmount": {
"*": {
"\\$": "[4].attributes.KeyFinancialFiguresOverview[&3].value.ProfitOrLossAmount[].value"
}
},
"ProfitOrLossGrowthRate": "[4].attributes.KeyFinancialFiguresOverview[&1].value.ProfitOrLossGrowthRate[].value",
"SalesTurnoverGrowthRate": "[4].attributes.KeyFinancialFiguresOverview[&1].value.SalesTurnoverGrowthRate[].value"
}
}
},
"IndustryCode": {
"IndustryCode": {
"*": {
"IndustryCode": {
"\\$": "[4].attributes.IndustryCode[&2].value.IndustryCode[].value"
},
"\\@DNBCodeValue": "[4].attributes.IndustryCode[&1].value.DNBCode[].value",
"\\@TypeText": "[4].attributes.IndustryCode[&1].value.Type[].value",
"IndustryCodeDescription": {
"*": {
"\\$": "[4].attributes.IndustryCode[&3].value.IndustryCodeDescription[].value",
"\\@LanguageCode": "[4].attributes.IndustryCode[&3].value.IndustryCodeLanguageCode[].value",
"\\@WritingScriptISOAlpha4Code": "[4].attributes.IndustryCode[&3].value.IndustryCodeWritingScript[].value"
}
},
"DisplaySequence": "[4].attributes.IndustryCode[&1].value.DisplaySequence[].value",
"SalesPercentage": "[4].attributes.IndustryCode[&1].value.SalesPercentage[].value"
}
}
},
"ActivitiesAndOperations": {
"OperationsText": "[4].attributes.ActivitiesAndOperations[0].value.OperationsText[].value",
"LineOfBusinessDetails": {
"*": {
"LineOfBusinessDescription": {
"\\$": "[4].attributes.ActivitiesAndOperations[0].value.LineOfBusinessDescription[].value",
"\\@LanguageCode": "[4].attributes.ActivitiesAndOperations[0].value.LanguageCode[].value"
}
}
},
"ImportDetails": {
"ImportIndicator": "[4].attributes.ActivitiesAndOperations[0].value.ImportIndicator[].value"
},
"ExportDetails": {
"ExportIndicator": "[4].attributes.ActivitiesAndOperations[0].value.ExportIndicator[].value"
},
"SubjectIsAgentDetails": {
"AgentIndicator": "[4].attributes.ActivitiesAndOperations[0].value.AgentIndicator[].value"
}
},
"EmployeeFigures": {
"IndividualEntityEmployeeDetails": {
// TODI - remove it
"IndividualEmployeeFiguresDate": "[4].attributes.EmployeeDetails[0].value.IndividualEmployeeFiguresDate[].value",
"TotalEmployeeQuantity": "[4].attributes.EmployeeDetails[0].value.IndividualTotalEmployeeQuantity[].value",
"ReliabilityText": {
"\\$": "[4].attributes.EmployeeDetails[0].value.IndividualReliabilityText[].value"
}
},
// not tested yet
"IndividualEntityEmployeeDetailsHistory": {
"TotalEmployeeQuantity": "[4].attributes.EmployeeDetails[0].value.TotalEmployeeQuantity[].value",
"ReliabilityText": {
"\\$": "[4].attributes.EmployeeDetails[0].value.TotalEmployeeReliability[].value"
}
}
},
"RegisteredDetail": {
"LegalFormDetails": {
"LegalFormText": {
"\\$": "[4].attributes.LegalStatusCode[].value"
}
},
"OrganizationIdentificationNumberDetail": {
"*": {
"\\@TypeText": "[4].attributes.Identifiers[&1].value.Type[].value",
"OrganizationIdentificationNumber": "[4].attributes.Identifiers[&1].value.ID[].value"
}
}
},
"Linkage": {
"GlobalUltimateOrganization": {
"#configuration/entityTypes/Organization": "[0].type",
"#configuration/sources/DnB": "[0].crosswalks[0].type",
"#DnB Linkage": "[0].attributes.VendorOrganizationType[].value",
"#Real Time": "[0].attributes.DnBSource[].value",
"DUNSNumber": [
"[0].attributes.DUNSNumber[].value",
"[4].attributes.DUNSHierarchy[0].value.GlobalUltimateDUNS[].value",
"[0].crosswalks[0].value"
],
"OrganizationPrimaryName": {
"*": {
"OrganizationName": {
"\\$": [
"[0].attributes.Name[&2].value",
"[4].attributes.DUNSHierarchy[0].value.GlobalUltimateOrganization[&2].value"
]
}
}
},
"PrimaryAddress": {
"*": {
"StreetAddressLine": {
"0": {
"LineText": "[0].attributes.Addresses[&3].value.AddressLine1[].value"
},
"1": {
"LineText": "[0].attributes.Addresses[&3].value.AddressLine2[].value"
},
"#Shipping": "[0].attributes.Addresses[&2].value.AddressType[].value",
"#true": "[0].attributes.Addresses[&2].value.Primary[].value",
"@(1,PostalCode)": "[0].attributes.Addresses[&2].value.PostalCode[].value",
"@(1,PrimaryTownName)": "[0].attributes.Addresses[&2].value.City[].value",
"@(1,TerritoryOfficialName)": "[0].attributes.Addresses[&2].value.StateProvince[].value",
"@(1,CountryISOAlpha2Code)": "[0].attributes.Addresses[&2].value.Country[].value"
}
}
}
},
"DomesticUltimateOrganization": {
"#configuration/entityTypes/Organization": "[1].type",
"#configuration/sources/DnB": "[1].crosswalks[0].type",
"#DnB Linkage": "[1].attributes.VendorOrganizationType[].value",
"#Real Time": "[1].attributes.DnBSource[].value",
"DUNSNumber": [
"[1].attributes.DUNSNumber[].value",
"[4].attributes.DUNSHierarchy[0].value.DomesticUltimateDUNS[].value",
"[1].crosswalks[0].value"
],
"OrganizationPrimaryName": {
"*": {
"OrganizationName": {
"\\$": [
"[1].attributes.Name[&2].value",
"[4].attributes.DUNSHierarchy[0].value.DomesticUltimateOrganization[&2].value"
]
}
}
},
"PrimaryAddress": {
"*": {
"StreetAddressLine": {
"0": {
"LineText": "[1].attributes.Addresses[&3].value.AddressLine1[].value"
},
"1": {
"LineText": "[1].attributes.Addresses[&3].value.AddressLine2[].value"
},
"#Shipping": "[1].attributes.Addresses[&2].value.AddressType[].value",
"#true": "[1].attributes.Addresses[&2].value.Primary[].value",
"@(1,PostalCode)": "[1].attributes.Addresses[&2].value.PostalCode[].value",
"@(1,PrimaryTownName)": "[1].attributes.Addresses[&2].value.City[].value",
"@(1,TerritoryOfficialName)": "[1].attributes.Addresses[&2].value.StateProvince[].value",
"@(1,CountryISOAlpha2Code)": "[1].attributes.Addresses[&2].value.Country[].value"
}
}
}
},
"HeadquartersOrganization": {
"#configuration/entityTypes/Organization": "[2].type",
"#configuration/sources/DnB": "[2].crosswalks[0].type",
"#DnB Linkage": "[2].attributes.VendorOrganizationType[].value",
"#Real Time": "[2].attributes.DnBSource[].value",
"DUNSNumber": [
"[2].attributes.DUNSNumber[].value",
"[4].attributes.DUNSHierarchy[0].value.HeadquartersDUNS[].value",
"[2].crosswalks[0].value"
],
"OrganizationPrimaryName": {
"*": {
"OrganizationName": {
"\\$": [
"[2].attributes.Name[&2].value",
"[4].attributes.DUNSHierarchy[0].value.HeadquartersOrganization[&2].value"
]
}
}
},
"PrimaryAddress": {
"*": {
"StreetAddressLine": {
"0": {
"LineText": "[2].attributes.Addresses[&3].value.AddressLine1[].value"
},
"1": {
"LineText": "[2].attributes.Addresses[&3].value.AddressLine2[].value"
},
"#Shipping": "[2].attributes.Addresses[&2].value.AddressType[].value",
"#true": "[2].attributes.Addresses[&2].value.Primary[].value",
"@(1,PostalCode)": "[2].attributes.Addresses[&2].value.PostalCode[].value",
"@(1,PrimaryTownName)": "[2].attributes.Addresses[&2].value.City[].value",
"@(1,TerritoryOfficialName)": "[2].attributes.Addresses[&2].value.StateProvince[].value",
"@(1,CountryISOAlpha2Code)": "[2].attributes.Addresses[&2].value.Country[].value"
}
}
}
},
"ParentOrganization": {
"#configuration/entityTypes/Organization": "[3].type",
"#configuration/sources/DnB": "[3].crosswalks[0].type",
"#DnB Linkage": "[3].attributes.VendorOrganizationType[].value",
"#Real Time": "[3].attributes.DnBSource[].value",
"DUNSNumber": [
"[3].attributes.DUNSNumber[].value",
"[4].attributes.DUNSHierarchy[0].value.ParentDUNS[].value",
"[3].crosswalks[0].value"
],
"OrganizationPrimaryName": {
"*": {
"OrganizationName": {
"\\$": [
"[3].attributes.Name[&2].value",
"[4].attributes.DUNSHierarchy[0].value.ParentOrganization[&2].value"
]
}
}
},
"PrimaryAddress": {
"*": {
"StreetAddressLine": {
"0": {
"LineText": "[3].attributes.Addresses[&3].value.AddressLine1[].value"
},
"1": {
"LineText": "[3].attributes.Addresses[&3].value.AddressLine2[].value"
},
"#Shipping": "[3].attributes.Addresses[&2].value.AddressType[].value",
"#true": "[3].attributes.Addresses[&2].value.Primary[].value",
"@(1,PostalCode)": "[3].attributes.Addresses[&2].value.PostalCode[].value",
"@(1,PrimaryTownName)": "[3].attributes.Addresses[&2].value.City[].value",
"@(1,TerritoryOfficialName)": "[3].attributes.Addresses[&2].value.StateProvince[].value",
"@(1,CountryISOAlpha2Code)": "[3].attributes.Addresses[&2].value.Country[].value"
}
}
}
}
}
}
}
}
}
}
},
{
"operation": "shift",
"spec": {
"0": {
"type": "[0].type",
"crosswalks": "[0].crosswalks",
"attributes": "[0].attributes"
},
"1": {
"type": "[1].type",
"crosswalks": "[1].crosswalks",
"attributes": "[1].attributes"
},
"2": {
"type": "[2].type",
"crosswalks": "[2].crosswalks",
"attributes": "[2].attributes"
},
"3": {
"type": "[3].type",
"crosswalks": "[3].crosswalks",
"attributes": "[3].attributes"
},
"4": {
"type": "[4].type",
"crosswalks": "[4].crosswalks",
"attributes": "[4].attributes"
},
"5": {
"ma": {
"Addresses": {
"*": "[4].attributes.Addresses[]"
},
"Phone": {
"*": "[4].attributes.Phone[]"
}
},
"sa": {
"Addresses": {
"*": "[4].attributes.Addresses[]"
},
"Phone": {
"*": "[4].attributes.Phone[]"
}
}
}
}
},
{
"operation": "com.reltio.account360.connector.dnb.mappings.SetFinancialStatementToDate"
},
// section below doesn't make useful actions - only replaces null to { "attributes": {}} - empty organization
// why? - we need it in case when only one organization here and other are null - in this case last modifier will
// create array[] instead of array[array[]] and crash conversion to List<List<>>
{
"operation": "modify-overwrite-beta",
"spec": {
"*": {
"attributes": {
"SomeValue": {
"*": {
"value": "&"
}
}
}
}
}
},
{
"operation": "shift",
"spec": {
"*": "[0]"
}
}
]
Response
HTTP CODE:
Success: 200
Errors:
400 Bad Request
404 Not Found
500 Internal Server Error