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
|
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. |