Del via


D&B Optimizer [DEPRECATED]

D&B Optimizer is a foundational data service from Dun & Bradstreet that improves the quality of your business data by correctly identifying, cleansing, and inserting firmographic intelligence into records within your Microsoft application environment.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Standard All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Standard All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Connector Metadata
Publisher Dun & Bradstreet

D&B Optimizer requires users to have access to a Common Data Service environment and an active subscription for Dun & Bradstreet services.
Find more information here, and how to get started here.

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Cleanse Match and Append [DEPRECATED]

D&B Identity Resolution uses input criteria to find the best candidates in its extensive database of entities. It uses proprietary algorithms to identify the best matches and returns those matches with detailed information about what criteria was used to find the match.

Retrieve data on a specific entity [DEPRECATED]

The Data Products API returns data about a requested DUNS. The data returned is specific to the product requested.

Cleanse Match and Append [DEPRECATED]

D&B Identity Resolution uses input criteria to find the best candidates in its extensive database of entities. It uses proprietary algorithms to identify the best matches and returns those matches with detailed information about what criteria was used to find the match.

Parameters

Name Key Required Type Description
Product Id
productId True string

The product ID provided by D&B that identifies the product to be returned.

Version Id
versionId True string

The version ID (e.g., v1) that identifies the product version to be returned.

Name
name string

Up to 240 characters used to find the entity by its primary name, tradestyle names, or former names.

Street Address Line 1
streetAddressLine1 string

Up to 70 characters of the first line of the entity's street address.

Street Address Line 2
streetAddressLine2 string

Up to 70 characters of the second line of the entity's street address

Country ISO Alpha Code
countryISOAlpha2Code True string

The 2-letter country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the entity.

Postal Code
postalCode string

Up to 10 characters of the identifier used by the local country's postal authority to identify where the address is located.

Address Locality
addressLocality string

1 to 50 characters that identifies the city, town, township, village, borough, etc. where the entity is located.

Address Region
addressRegion string

The name of the locally governed area that forms part of a centrally governed nation to identify where the address is located.

Telephone Number
telephoneNumber string

Up to 32 characters of the telephone number--the sequence of digits used for voice communication with the entity. This sequence of digits includes the area code or city code and domestic dialing code.

URL
url string

A URL used to identify an entity by its email domain.

Email
email string

An email address used to identify an entity by its email domain.

Registration Number
registrationNumber string

The number assigned by an external body or by D&B that either uniquely identifies or helps to identify an organization.

Registration Number Type
registrationNumberType string

A unique code assigned by D&B to identify the type of registration number.

Confidence Lower Level
confidenceLowerLevelThresholdValue string

The lowest confidence level for entities returned in the response. Valid values are 1 to 10, if not specified the default of 4 is used.

Exclusion Criteria
exclusionCriteria string

Provides the ability to exclude entities based on several properties.

Returns

Name Path Type Description
DUNS Number
duns string

The D-U-N-S Number is an identification number assigned by D&B that uniquely identifies the entity in accordance with the Data Universal Numbering System (D-U-N-S).

Primary Business Name
primary_name string

The single name by which the entity is primarily known or identified.

Trade Style Name
trade_style string

The name that the entity trades under for commercial purposes  although its registered  legal name used for contracts and other formal situations may be another name.

Street Address
address.streetline1 string

The first line of the address where the entity is located.

Street Address (2)
address.streetline2 string

The second line of the address where the entity is located.

Address City
address.city string

The name of the city, town, township, village, borough, etc. in which this address is located.

Territory Code
address.territory_code string

The standard code of the locally governed area that forms part of a centrally governed nation to identify where this address is located.

Territory Name
address.territory_name string

The name of the locally governed area that forms part of a centrally governed nation to identify where this address is located.

Postal Code
address.postal_code string

An identifier used by the local country Postal Authority to identify where the business is located.

ISO Country Code
address.isoalpha2code string

The two-letter country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the business entity.

ISO Country Name
address.country_name string

The country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the business entity.

Telephone ISD Code
phone.international_code string

This sequence of digits contains the International Subscriber Dialling (ISD) code.

Telephone Number
phone.number string

A sequence of digits used for voice communication with the entity. This sequence of digits includes the area code or city code and domestic dialing code.

Industry Code
primary_sic string

The code that identifies the business activity in which the entity is engaged.

Industry Code Description
industrycode.description string

The description for the corresponding Industry Code.

Employee Quantity Details (Local)
employees.local integer

The total number of people engaged by the entity to perform its operations. The scope of this employee figure is identified in informationScopeDescription.

Employee Quantity Details (Total)
employees.global integer

The total number of people engaged by the entity to perform its operations. The scope of this employee figure is identified in informationScopeDescription.

Financial Statement To Date
financials.todate date-time

The date when the accounting period ended.  If the Reliability Code denotes the figures are projected (future), then this is the date when the accounting period will end.

Sales Revenue Amount in USD
financials_global.value integer

The monetary value of income received from customers from the sale of the entity's goods and/or services in USD.  This is the gross sales minus any returns, rebates/discounts, allowances for damages or shortages, shipping expenses passed on to the customer.

Sales Revenue Amount in the local currency
financials_local.value integer

The monetary value of income received from customers from the sale of the entity's goods and/or services in local currency.  This is the gross sales minus any returns, rebates/discounts, allowances for damages or shortages, shipping expenses passed on to the customer.

Local currency code
financials_local.currency string

The local currency code for this entity.

Location Types
location_types string

A semi-colon delimited list of Location Types for this entity.

Single Location Indicator
is_single_location boolean

Indicates if the entity is a Single Location or not.

Parent D-U-N-S Number
parent.duns string

The D-U-N-S number of the parent entity. A parent is a corporation that owns more than 50% of another corporation's capital stock; these owned companies are subsidiaries to the parent entity. 

Parent Business Name
parent.name string

The business name of the parent entity. A parent is a corporation that owns more than 50% of another corporation's capital stock.

Domestic Ultimate D-U-N-S Number
domestic_ultimate.duns string

The D-U-N-S Number of the highest level parent within a corporate family tree that is domiciled in the same country as the requested entity. A parent is a corporation that owns more than 50% of another corporation's capital stock. A subject may be its own domestic ultimate.

Domestic Ultimate Name
domestic_ultimate.name string

The name of the highest business in the family tree that is in the same country as the subject.

Global Ultimate D-U-N-S Number
global_ultimate.duns string

The D-U-N-S number of the highest level parent within a corporate family tree. A parent is a corporation that owns more than 50% of another corporation's capital stock. A subject may be its own global ultimate. 

Global Ultimate Name
global_ultimate.name string

The primary name of the global ultimate business.

Business Legal Structure
entity_type integer

The D&B Code for the corresponding Business Legal Structure

Business Legal Structure Description
entity_type.description string

The name of the legal form or structure of the entity as registered with government authorities (e.g., partnership, corporation, private limited company, government department, proprietorship). A unique code assigned by D&B to identify the legal form or structure of the entity as registered with government authorities

Match Confidence
match.confidence integer

Confidence codes are based on the detailed MatchGrade Strings™; over 4 million string combinations are mapped to 10 Confidence Codes, allowing for broad categorization of matched records. The higher the number, the higher the confidence that it is an accurate match.

Match Profile
match.profile string

Match Data Profile (MDP) Codes indicate if and how each component type was matched in the returned candidate.

Match Grade
match.grade string

MatchGrade Strings provide qualitative assessments between inquiry and reference components. A - Considered the same, B - Some similiarity, F - Considered different, Z - Missing information, cannot make conclusion.

Delisted Indicator
is_delisted boolean

Indicator as to the whether or not the entity has asked that their data not be included in D&B's marketing file for prospecting.

Operating Status
operating_status integer

The D&B code for the corresponding Operating Status

Operating Status Description
operating_status.description string

The entity's functional state or trading status (e.g., active, out of business). A unique code assigned by D&B to identify the entity's functional state or trading status.

Match Grade - Organization Name
match_grade.name string

Match Grade - Organization Name

Match Grade - Street Number
match_grade.street_number string

Match Grade - Street Number

Match Grade - Street Name
match_grade.street_name string

Match Grade - Street Name

Match Grade - Town/City
match_grade.city string

Match Grade - Town/City

Match Grade - State/Region
match_grade.state string

Match Grade - State/Region

Match Grade - PO Box
match_grade.po_box string

Match Grade - PO Box

Match Grade - Phone Number
match_grade.phone string

Match Grade - Phone Number

Match Grade - Postal Code
match_grade.postal_code string

Match Grade - Postal Code

Match Grade - Density
match_grade.density string

Match Grade - Density

Match Grade - Uniqueness
match_grade.uniqueness string

Match Grade - Uniqueness

Match Grade - SIC Code
match_grade.industry string

Match Grade - SIC Code

Retrieve data on a specific entity [DEPRECATED]

The Data Products API returns data about a requested DUNS. The data returned is specific to the product requested.

Parameters

Name Key Required Type Description
D-U-N-S Number
duns True string

The D-U-N-S Number is an identification number assigned by D&B that uniquely identifies the entity in accordance with the Data Universal Numbering System (D-U-N-S).

Product Id
productId True string

The product ID provided by D&B that identifies the product to be returned.

Version Id
versionId True string

The version ID (e.g., v1) that identifies the product version to be returned.

Returns

Name Path Type Description
DUNS Number
duns string

The D-U-N-S Number is an identification number assigned by D&B that uniquely identifies the entity in accordance with the Data Universal Numbering System (D-U-N-S).

Primary Business Name
primary_name string

The single name by which the entity is primarily known or identified.

Trade Style Name
trade_style string

The name that the entity trades under for commercial purposes  although its registered  legal name used for contracts and other formal situations may be another name.

Street Address
address.streetline1 string

The first line of the address where the entity is located.

Street Address (2)
address.streetline2 string

The second line of the address where the entity is located.

Address City
address.city string

The name of the city, town, township, village, borough, etc. in which this address is located.

Territory Code
address.territory_code string

The standard code of the locally governed area that forms part of a centrally governed nation to identify where this address is located.

Territory Name
address.territory_name string

The name of the locally governed area that forms part of a centrally governed nation to identify where this address is located.

Postal Code
address.postal_code string

An identifier used by the local country Postal Authority to identify where the business is located.

ISO Country Code
address.isoalpha2code string

The two-letter country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the business entity.

ISO Country Name
address.country_name string

The country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the business entity.

Telephone ISD Code
phone.international_code string

This sequence of digits contains the International Subscriber Dialling (ISD) code.

Telephone Number
phone.number string

A sequence of digits used for voice communication with the entity. This sequence of digits includes the area code or city code and domestic dialing code.

Industry Code
primary_sic string

The code that identifies the business activity in which the entity is engaged.

Industry Code Description
industrycode.description string

The description for the corresponding Industry Code.

Employee Quantity Details (Local)
employees.local integer

The total number of people engaged by the entity to perform its operations. The scope of this employee figure is identified in informationScopeDescription.

Employee Quantity Details (Total)
employees.global integer

The total number of people engaged by the entity to perform its operations. The scope of this employee figure is identified in informationScopeDescription.

Financial Statement To Date
financials.todate date-time

The date when the accounting period ended.  If the Reliability Code denotes the figures are projected (future), then this is the date when the accounting period will end.

Sales Revenue Amount in USD
financials_global.value integer

The monetary value of income received from customers from the sale of the entity's goods and/or services in USD.  This is the gross sales minus any returns, rebates/discounts, allowances for damages or shortages, shipping expenses passed on to the customer.

Sales Revenue Amount in the local currency
financials_local.value integer

The monetary value of income received from customers from the sale of the entity's goods and/or services in local currency.  This is the gross sales minus any returns, rebates/discounts, allowances for damages or shortages, shipping expenses passed on to the customer.

Local currency code
financials_local.currency string

The local currency code for this entity.

Location Types
location_types string

A semi-colon delimited list of Location Types for this entity.

Single Location Indicator
is_single_location boolean

Indicates if the entity is a Single Location or not.

Parent D-U-N-S Number
parent.duns string

The D-U-N-S number of the parent entity. A parent is a corporation that owns more than 50% of another corporation's capital stock; these owned companies are subsidiaries to the parent entity. 

Parent Business Name
parent.name string

The business name of the parent entity. A parent is a corporation that owns more than 50% of another corporation's capital stock.

Domestic Ultimate D-U-N-S Number
domestic_ultimate.duns string

The D-U-N-S Number of the highest level parent within a corporate family tree that is domiciled in the same country as the requested entity. A parent is a corporation that owns more than 50% of another corporation's capital stock. A subject may be its own domestic ultimate.

Domestic Ultimate Name
domestic_ultimate.name string

The name of the highest business in the family tree that is in the same country as the subject.

Global Ultimate D-U-N-S Number
global_ultimate.duns string

The D-U-N-S number of the highest level parent within a corporate family tree. A parent is a corporation that owns more than 50% of another corporation's capital stock. A subject may be its own global ultimate. 

Global Ultimate Name
global_ultimate.name string

The primary name of the global ultimate business.

Business Legal Structure
entity_type integer

The D&B Code for the corresponding Business Legal Structure

Business Legal Structure Description
entity_type.description string

The name of the legal form or structure of the entity as registered with government authorities (e.g., partnership, corporation, private limited company, government department, proprietorship). A unique code assigned by D&B to identify the legal form or structure of the entity as registered with government authorities

Delisted Indicator
is_delisted boolean

Indicator as to the whether or not the entity has asked that their data not be included in D&B's marketing file for prospecting.

Operating Status
operating_status integer

The D&B code for the corresponding Operating Status

Operating Status Description
operating_status.description string

The entity's functional state or trading status (e.g., active, out of business). A unique code assigned by D&B to identify the entity's functional state or trading status.