Mapping Additional D&B Data Fields

Review the CMPELF data model and identify any gaps with attributes and data containers for D&B data that you would like returned for your customer data. Once the gaps have been identified, manually create any required new attributes and data containers to store the incoming data.

To parse the data blocks' JSON response, the built-in default data mappings can be used to handle any data within the standard CMPELF product. However, JavaScript must be used for any data that was created as part of the gap analysis.

For more information about data blocks, refer to the topic Data Blocks in the Data Integration documentation

The JavaScript below shows how to parse and store D&B data to STEP, including examples for attributes and data containers.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
var dnbResultCMPELF = dnbManager.executeBusinessActionWithDnbIntegrationContext(dnbEnrichRequestCMPELF);
 
if (dnbResultCMPELF.getIntegrationException()) {
 
    dataIssuesReport.addError(dnbResultCMPELF.getIntegrationException().getMessage(), currentObject, enrichIntegrationStatusAttributeCMPELF);
 
} else {
 
    //Get the JSON
 
    var dnbOrganization = currentObject.getDnbOrganization();
 
    var jsonResult = dnbOrganization.getValue('DnBJSONCompanyProfileData').getSimpleValue();
 
    //log.info(jsonResult);
 
    var responseObject = JSON.parse(jsonResult);
 
 
var targetAttr = node.getValue('DnBReliabilityDnBCode');

The result is shown in 'D&B Enrichment Records' > 'D&B Financials (manual mapped)'.