Unify and manage your data

Get Enrichment Mapping

Learn about the operation to get D&B enrichment mappings.

Request

GET: {dnbConnectorUrl}/config/profiles/{profile}/mappings/enrichment
Table 1. Parameters
Parameter Name RequiredDescription
HeadersContent-TypeYesShould be Content-Type:application/json.
HeadersAuthorizationYesReltio access token in the form Bearer: <<token>>, see Authentication API.
PathprofileYesProfile Name.
QueryplusNo Use Direct+ mapping. Default value: true

Response

HTTP CODE: Success: 200 [ { "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]" } } ]

Errors

400 Bad Request 500 Internal Server Error