D&B Optimizer [DEPRECATED]

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
Flow Standard All Flow regions except the following:
     -   US Government (GCC)
PowerApps Standard All PowerApps regions except the following:
     -   US Government (GCC)

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.

Required Parameters

Product Id
string
The product ID provided by D&B that identifies the product to be returned.
Version Id
string
The version ID (e.g., v1) that identifies the product version to be returned.
Country ISO Alpha Code
string
The 2-letter country code, defined by the International Organization for Standardization (ISO) ISO 3166-1 scheme identifying the country of the entity.

Optional Parameters

Name
string
Up to 240 characters used to find the entity by its primary name, tradestyle names, or former names.
Street Address Line 1
string
Up to 70 characters of the first line of the entity's street address.
Street Address Line 2
string
Up to 70 characters of the second line of the entity's street address
Postal Code
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
string
1 to 50 characters that identifies the city, town, township, village, borough, etc. where the entity is located.
Address Region
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
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
string
A URL used to identify an entity by its email domain.
Email
string
An email address used to identify an entity by its email domain.
Registration Number
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
string
A unique code assigned by D&B to identify the type of registration number.
Confidence Lower Level
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
string
Provides the ability to exclude entities based on several properties.

Returns

DUNS Number
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
string
The single name by which the entity is primarily known or identified.
Trade Style Name
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
string
The first line of the address where the entity is located.
Street Address (2)
string
The second line of the address where the entity is located.
Address City
string
The name of the city, town, township, village, borough, etc. in which this address is located.
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
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
string
An identifier used by the local country Postal Authority to identify where the business is located.
ISO Country Code
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
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
string
This sequence of digits contains the International Subscriber Dialling (ISD) code.
Telephone 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
string
The code that identifies the business activity in which the entity is engaged.
Industry Code Description
string
The description for the corresponding Industry Code.
Employee Quantity Details (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)
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
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
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
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
string
The local currency code for this entity.
Location Types
string
A semi-colon delimited list of Location Types for this entity.
Single Location Indicator
boolean
Indicates if the entity is a Single Location or not.
Parent D-U-N-S Number
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
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
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
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
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
string
The primary name of the global ultimate business.
Business Legal Structure
integer
The D&B Code for the corresponding Business Legal Structure
Business Legal Structure 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
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
string
Match Data Profile (MDP) Codes indicate if and how each component type was matched in the returned candidate.
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
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
integer
The D&B code for the corresponding Operating Status
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
string
Match Grade - Organization Name
Match Grade - Street Number
string
Match Grade - Street Number
Match Grade - Street Name
string
Match Grade - Street Name
Match Grade - Town/City
string
Match Grade - Town/City
Match Grade - State/Region
string
Match Grade - State/Region
Match Grade - PO Box
string
Match Grade - PO Box
Match Grade - Phone Number
string
Match Grade - Phone Number
Match Grade - Postal Code
string
Match Grade - Postal Code
Match Grade - Density
string
Match Grade - Density
Match Grade - Uniqueness
string
Match Grade - Uniqueness
Match Grade - SIC Code
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.

Required Parameters

D-U-N-S Number
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
string
The product ID provided by D&B that identifies the product to be returned.
Version Id
string
The version ID (e.g., v1) that identifies the product version to be returned.

Returns

DUNS Number
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
string
The single name by which the entity is primarily known or identified.
Trade Style Name
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
string
The first line of the address where the entity is located.
Street Address (2)
string
The second line of the address where the entity is located.
Address City
string
The name of the city, town, township, village, borough, etc. in which this address is located.
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
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
string
An identifier used by the local country Postal Authority to identify where the business is located.
ISO Country Code
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
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
string
This sequence of digits contains the International Subscriber Dialling (ISD) code.
Telephone 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
string
The code that identifies the business activity in which the entity is engaged.
Industry Code Description
string
The description for the corresponding Industry Code.
Employee Quantity Details (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)
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
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
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
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
string
The local currency code for this entity.
Location Types
string
A semi-colon delimited list of Location Types for this entity.
Single Location Indicator
boolean
Indicates if the entity is a Single Location or not.
Parent D-U-N-S Number
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
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
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
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
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
string
The primary name of the global ultimate business.
Business Legal Structure
integer
The D&B Code for the corresponding Business Legal Structure
Business Legal Structure 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
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
integer
The D&B code for the corresponding Operating Status
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.