Attribute Mapping for Direct+ Batch and On Demand API
Use these mappings for Direct+ batch or On Demand APIs while enriching the data from D&B.
The following mappings are used while using the Direct+ batch or On Demand APIs.
Note: The D&B Attribute column represents the path of the JSON response from
D&B.
| D&B Attribute | Reltio Attribute |
|---|---|
#Real Time Plus | attributes.DnBSource.value |
organization.duns | attributes.DUNSNumber.value |
organization.dunsControlStatus.isMarketable | attributes.MarketabilityIndicator.value |
organization.dunsControlStatus.lastUpdateDate | attributes.DnBLastUpdateDate.value |
organization.dunsControlStatus.operatingStatus.description | attributes.OrganizationDetailvalue.OperatingStatusComment.value, |
organization.primaryName | attributes.OrganizationDetailvalue.OperatingStatus.value |
organization.telephone[*].telephoneNumber | attributes.Name.value |
organization.telephone[*].isUnreachable | attributes.Phone[*].value.Unreachable.value |
organization.telephone[*].isdCode | attributes.Phone[*].value.CountryCode.value |
#Phone | attributes.Phone[*].value.Type.value |
#true | attributes.Phone[*].value.PrimaryPhoneFlag.value |
organization.fax[*].telephoneNumber | attributes.Phone[*].value.Number.value |
organization.fax[*].isUnreachable | attributes.Phone[*].value.Unreachable.value |
organization.fax[*].isdCode | attributes.Phone[*].value.CountryCode.value |
#Fax | attributes.Phone[*].value.Type.value |
#True | attributes.Phone[*].value.PrimaryPhoneFlag.value |
orgnization.tradeStyleNames[*].name | attributes.TradeStyleName[*].value.OrganizationName.value |
organization.websiteAddress[*].url | attributes.WebsiteURL[].value |
organization.isStandalone | attributes.OrganizationDetail[].value.Standalone.value |
organization.controlOwnershipDate | attributes.OrganizationDetail[].value.OwnershipDate.value |
organization.controlOwnershipType.description | attributes.OrganizationDetail.value.OwnershipType.value |
organization.startDate | attributes.OrganizationDetail.value.StartYear.value |
primaryAddress.streetAddress.line1 | attributes.Addresses[].value.AddressLine1[].value |
primaryAddress.streetAddress.line2 | attributes.Addresses[].value.AddressLine2[].value |
primaryAddress.postalCode | attributes.Addresses[].value.PostalCode[].value |
primaryAddress.addressLocality..name | attributes.Addresses[].value.City[].value |
primaryAddress.addressRegion.name | attributes.Addresses[].value.StateProvince[].value |
primaryAddress.latitude | attributes.Addresses[].value.DnBLatitude[].value |
primaryAddress.longitude | attributes.Addresses[].value.DnBLongitude[].value |
primaryAddress.isRegisteredAddress | attributes.Addresses[].value.Registered[].value |
primaryAddress.isResidentialAddress | attributes.Addresses[].value.Residential[].value |
primaryAddress.addressCountry.name | attributes.Addresses[].value.Country[].value |
#Shipping | attributes.Addresses[].value.AddressType[].value |
#true | attributes.Addresses[].value.Primary[].value |
mailingAddress.streetAddress.line1 | attributes.Addresses[].value.AddressLine1[].value |
mailingAddress.streetAddress.line2 | attributes.Addresses[].value.AddressLine2[].value |
mailingAddress.postalCode | attributes.Addresses[].value.PostalCode[].value |
mailingAddress.addressLocality..name | attributes.Addresses[].value.City[].value |
mailingAddress.addressRegion.name | attributes.Addresses[].value.StateProvince[].value |
mailingAddress.latitude | attributes.Addresses[].value.DnBLatitude[].value |
mailingAddress.longitude | attributes.Addresses[].value.DnBLongitude[].value |
mailingAddress.isRegisteredAddress | attributes.Addresses[].value.Registered[].value |
mailingAddress.isResidentialAddress | attributes.Addresses[].value.Residential[].value |
mailingAddress.addressCountry.name | attributes.Addresses[].value.Country[].value |
#Mailing | attributes.Addresses[].value.AddressType[].value |
organization.financials[*].financialStatementToDate | attributes.KeyFinancialFiguresOverview[*].value.FinancialStatementToDate.value |
organization.financials[*].financialStatementDuration | attributes.KeyFinancialFiguresOverview[*].value.FinancialPeriodDuration.value |
organization.financials[*].yearlyRevenue[*].value | attributes.KeyFinancialFiguresOverview[*].value.SalesRevenueAmount[].value |
organization.financials[*].yearlyRevenue[*].currency | attributes.KeyFinancialFiguresOverview[*].value.SalesRevenueCurrencyCode[].value |
organization.industryCodes[*].code | attributes.IndustryCode[*].value.IndustryCode.value |
organization.industryCodes[*].description | attributes.IndustryCode[*].value.IndustryCodeDescription.value |
organization.industryCodes[*].typeDescription | attributes.IndustryCode[*].value.Type.value |
organization.industryCodes[*].typeDnBCode | attributes.IndustryCode[*].value.DNBCode.value |
organization.isImporter | attributes.ActivitiesAndOperationsvalue.ImportIndicator.value |
organization.isExporter | attributes.ActivitiesAndOperationsvalue.ExportIndicator.value |
organization.isAgent | attributes.ActivitiesAndOperationsvalue.AgentIndicator.value |
organization.numberOfEmployees[*].value | attributes.EmployeeDetails[].value.IndividualTotalEmployeeQuantity.value |
organization.numberOfEmployees[*].reliabilityDescription | attributes.EmployeeDetails[].value.IndividualReliabilityText.value |
organization.businessEntityType.description | attributes.LegalStatusCode.value |
organization.registrationNumbers[*].registrationNumber | attributes.Identifiers[&1].value.ID.value |
organization.registrationNumbers[*].typeDescription | attributes.Identifiers[&1].value.Type.value |
organization.corporateLinkage.familytreeRolesPlayed.description | attributes.OrganizationDetailvalue.MemberRole.value |
organization.corporateLinkage.globalUltimate.duns | GU.attributes.DUNSNumber.value,
attributes.DUNSHierarchy.value.GlobalUltimateDUNS.value |
#DnB Linkage | GU.attributes.VendorOrganizationType.value |
#Real Time Plus | GU.attributes.DnBSource.value |
organization.corporateLinkage.globalUltimate.primaryName | GU.attributes.Name.value,
attributes.DUNSHierarchy.value.GlobalUltimateOrganization.value |
organization.corporateLinkage.globalUltimate.primaryAddress.streetAddress.line1 | GU.attributes.Addresses.value.AddressLine1.value |
organization.corporateLinkage.globalUltimate.primaryAddress.streetAddress.line2 | GU.attributes.Addresses.value.AddressLine2.value |
#Shipping | GU.attributes.Addresses.value.AddressType.value |
#true | GU.attributes.Addresses.value.Primary.value |
organization.corporateLinkage.globalUltimate.primaryAddress.postalCode | GU.attributes.Addresses.value.PostalCode.value |
organization.corporateLinkage.globalUltimate.primaryAddress.addressLocality.name | GU.attributes.Addresses.value.City.value |
organization.corporateLinkage.globalUltimate.primaryAddress.addressRegion.name | GU.attributes.Addresses.value.StateProvince.value |
organization.corporateLinkage.globalUltimate.primaryAddress.addressCountry.name | GU.attributes.Addresses.value.Country.value |
organization.corporateLinkage.domesticUltimate.duns | DU.attributes.DUNSNumber.value,
attributes.DUNSHierarchy.value.GlobalUltimateDUNS.value |
#DnB Linkage | DU.attributes.VendorOrganizationType.value |
#Real Time Plus | DU.attributes.DnBSource.value |
organization.corporateLinkage.domesticUltimate.primaryName | DU.attributes.Name.value,
attributes.DUNSHierarchy.value.GlobalUltimateOrganization.value |
organization.corporateLinkage.domesticUltimate.primaryAddress.streetAddress.line1 | DU.attributes.Addresses.value.AddressLine1.value |
organization.corporateLinkage.domesticUltimate.primaryAddress.streetAddress.line2 | DU.attributes.Addresses.value.AddressLine2.value |
#Shipping | DU.attributes.Addresses.value.AddressType.value |
#true | DU.attributes.Addresses.value.Primary.value |
organization.corporateLinkage.domesticUltimate.primaryAddress.postalCode | DU.attributes.Addresses.value.PostalCode.value |
organization.corporateLinkage.domesticUltimate.primaryAddress.addressLocality.name | DU.attributes.Addresses.value.City.value |
organization.corporateLinkage.domesticUltimate.primaryAddress.addressRegion.name | DU.attributes.Addresses.value.StateProvince.value |
organization.corporateLinkage.domesticUltimate.primaryAddress.addressCountry.name | DU.attributes.Addresses.value.Country.value |
organization.corporateLinkage.headQuarter.duns | HQ.attributes.DUNSNumber.value, attributes.DUNSHierarchy.value.headQuarterDUNS.v |
#DnB Linkage | HQ.attributes.VendorOrganizationType.value |
#Real Time Plus | HQ.attributes.DnBSource.value |
organization.corporateLinkage.headQuarter.primaryName | HQ.attributes.Name.value, attributes.DUNSHierarchy.value.headQuarterOrganization.value |
organization.corporateLinkage.headQuarter.primaryAddress.streetAddress.line1 | HQ.attributes.Addresses.value.AddressLine1.value |
organization.corporateLinkage.headQuarter.primaryAddress.streetAddress.line2 | HQ.attributes.Addresses.value.AddressLine2.value |
#Shipping | HQ.attributes.Addresses.value.AddressType.value |
#true | HQ.attributes.Addresses.value.Primary.value |
organization.corporateLinkage.headQuarter.primaryAddress.postalCode | HQ.attributes.Addresses.value.PostalCode.value |
organization.corporateLinkage.headQuarter.primaryAddress.addressLocality.name | HQ.attributes.Addresses.value.City.value |
organization.corporateLinkage.headQuarter.primaryAddress.addressRegion.name | HQ.attributes.Addresses.value.StateProvince.value (non-branch) |
organization.corporateLinkage.headQuarter.primaryAddress.addressCountry.name | HQ.attributes.Addresses.value.Country.value (branch) |
organization.corporateLinkage.parent.duns | Parent.attributes.DUNSNumber.value, attributes.DUNSHierarchy.value.parentDUNS.value |
field098 | Mailing Address Delivery Type Code |
#DnB Linkage | Parent.attributes.VendorOrganizationType.value |
#Real Time Plus | Parent.attributes.DnBSource.value |
organization.corporateLinkage.parent.primaryName | Parent.attributes.Name.value, attributes.DUNSHierarchy.value.parentOrganization.value |
organization.corporateLinkage.parent.primaryAddress.streetAddress.line1 | Parent.attributes.Addresses.value.AddressLine1.value |
organization.corporateLinkage.parent.primaryAddress.streetAddress.line2 | Parent.attributes.Addresses.value.AddressLine2.value |
#Shipping | Parent.attributes.Addresses.value.AddressType.value |
#true | Parent.attributes.Addresses.value.Primary.value |
organization.corporateLinkage.parent.primaryAddress.postalCode | Parent.attributes.Addresses.value.PostalCode.value |
organization.corporateLinkage.parent.primaryAddress.addressLocality.name | Parent.attributes.Addresses.value.City.value |
organization.corporateLinkage.parent.primaryAddress.addressRegion.name | Parent.attributes.Addresses.value.StateProvince.value |
organization.corporateLinkage.parent.primaryAddress.addressCountry.name | Parent.attributes.Addresses.value.Country.value |
MatchQuality.MatchGrade | matchCandidates.matchQualityInformation.matchGrade |
MatchQuality.NameProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Name" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.StreetNumberProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Street Number" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.StreetNameProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Street Name" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.CityProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="City" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.StateProvinceProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="State" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.POBoxProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="PO Box" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.PhoneProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Phone" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.ZIPProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Postal Code" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.SICProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="SIC" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.DensityProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Density" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.UniquenessProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="Uniqueness" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.DUNSProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="DUNS" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.NationalIDProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="National ID" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.URLProfileCode | matchCandidates.matchQualityInformation.matchDataProfileComponents.componentType="URL" |
| matchCandidates.matchQualityInformation.matchDataProfileComponents.componentValue |
MatchQuality.DisplaySequence | matchCandidates.displaySequence |