Configuration - Dun & Bradstreet Data Blocks¶

This section describes how you configure ACD for Dun & Bradstreet Data Blocks. You need to configure ACD in these places:

D&B Connect portal configuration
Runtime configuration
Application configuration
View configuration

Runtime Configuration¶

ACD uses D&B Direct+ Connect API to provide company data. Which data will be available is dependent on which data blocks have been configured in the previous step. To see available mapping properties, head over to D&B Direct+ Connect Documentation.

Countries¶

You must configure which country ACD should search in as default. This is done via the defaultCountry parameter and it should be added as an ISO-2 country code. The chosen country must be activated in the customer's agreement with D&B.

Registration Numbers¶

There can be a variety of different registration numbers associated with an organization. We have support for mapping business registration number and tax registration number. This is done by using the keywords "Business", "Trade", or "Tax", see mapping example below.

Example¶

This is a complete D&B Data Blocks provider specific configuration for ACD. See general configuration for a description of each parameter.

{
  "dnbdirect": {
    "defaultCountry": "SE"
  },
  "mapping": [
    {
      "limeProperty": "name",
      "providerProperty": "organization.primaryName"
    },
    {
      "limeProperty": "visitingaddress1",
      "providerProperty": "organization.primaryAddress.streetAddress.line1"
    },
    {
      "limeProperty": "visitingaddress2",
      "providerProperty": "organization.primaryAddress.streetAddress.line2"
    },
    {
      "limeProperty": "visitingzipcode",
      "providerProperty": "organization.primaryAddress.postalCode"
    },
    {
      "limeProperty": "visitingcity",
      "providerProperty": "organization.primaryAddress.addressLocality.name"
    },
    {
      "limeProperty": "www",
      "providerProperty": "organization.websiteAddress.0.url"
    },
    {
      "limeProperty": "registrationno",
      "providerProperty": "organization.registrationNumbers.Trade.registrationNumber"
    },
    {
      "limeProperty": "acd_vatno",
      "providerProperty": "organization.registrationNumbers.Tax.registrationNumber"
    },
    {
      "limeProperty": "acd_maintradecode",
      "providerProperty": "organization.primaryIndustryCode.usSicV4"
    },
    {
      "limeProperty": "acd_maintrade",
      "providerProperty": "organization.primaryIndustryCode.usSicV4Description"
    },
    {
      "limeProperty": "country",
      "providerProperty": "organization.country"
    },
    {
      "limeProperty": "phone",
      "providerProperty": "organization.telephone"
    },
    {
      "limeProperty": "acd_turnover",
      "providerProperty": "organization.financials.0.yearlyRevenue.0.value"
    },
    {
      "limeProperty": "acd_turnovercurrency",
      "providerProperty": "organization.financials.0.yearlyRevenue.0.currency"
    }    
  ],
  "propertiesToPopulateSearchWith": {
    "searchText": [
      "name"
    ],
    "city": [
      "postalcity"
    ]
  },
  "limetypeCompany": "company",
  "propertyProviderId": "acd_id",
  "propertyLastUpdated": "acd_lastupdated",
  "propertyResponsible": "coworker",
  "propertySavingError": "acd_errormessage",
  "propertyName": "name",
  "provider": "dnbdatablocks",
  "customCommandId": "",
  "last_checked_for_updates": "2022-06-10 07:10:03"
}

Application Configuration¶

ACD is using the application level configuration in order to configure API credentials for D&B Direct+ and D&B Connect.

Windows on-premise Installations¶

For Windows on-premise installations, the application level configuration is expressed in the file:

%ProgramData%\Lundalogik\LIME Pro Server\application_config.yaml

Add the following to the application_config.yaml file:

<application-name>:
  secrets:
    addon-acd:
      dnbdatablocks:
        credentials:
          client_id: <dnb-data-blocks-client-id>
          secret: <dnb-data-blocks-api-secret>

Restart the web server.

Cloud¶

For Cloud installations, the application level configuration is configured in CAFE (Cloud Administration).

Add the following to the Secret box in the application configuration in CAFE:

addon-acd:
  dnbdatablocks:
    credentials:
      client_id: <dnb-data-blocks-client-id>
      secret: <dnb-data-blocks-api-secret>

View Configuration¶

Add ACD's web component and the newly created fields to the company view configuration as described below.

Company¶

Card¶

Note

Remember to do this for all existing variants.

Add ACD's web component acd-update-object as a widget on the card view configuration.
Add the following as a section to your card view configuration.

json { "title": "Dun & Bradstreet Data Blocks Information", "controls": [ { "property": "acd_id", "readonly": true, "visibleOnCreate": false }, { "property": "acd_maintradecode", "readonly": true, "visibleOnCreate": false }, { "property": "acd_maintrade", "readonly": true, "visibleOnCreate": false }, { "property": "acd_vatno", "readonly": true, "visibleOnCreate": false }, { "property": "acd_unittype", "readonly": true, "visibleOnCreate": false }, { "property": "acd_unitstatus", "readonly": true, "visibleOnCreate": false }, { "property": "acd_email", "readonly": true, "visibleOnCreate": false }, { "property": "acd_noofemployeesunit", "readonly": true, "visibleOnCreate": false }, { "property": "acd_legalname", "readonly": true, "visibleOnCreate": false }, { "property": "acd_legalform", "readonly": true, "visibleOnCreate": false }, { "property": "acd_noofemployeescompany", "readonly": true, "visibleOnCreate": false }, { "property": "acd_turnover", "readonly": true, "visibleOnCreate": false }, { "property": "acd_turnovercurrency", "readonly": true, "visibleOnCreate": false }, { "property": "acd_groupname", "readonly": true, "visibleOnCreate": false } ] }

Table¶

Add the following as column properties to the table view configuration.

    {
      "property": "acd_id",
      "isDefault": false
    },
    {
      "property": "acd_lastupdated",
      "isDefault": false
    },
    {
      "property": "acd_maintradecode",
      "isDefault": false
    },
    {
      "property": "acd_maintrade",
      "isDefault": false
    },
    {
      "property": "acd_vatno",
      "isDefault": false
    },
    {
      "property": "acd_unittype",
      "isDefault": false
    },
    {
      "property": "acd_unitstatus",
      "isDefault": false
    },
    {
      "property": "acd_email",
      "isDefault": false
    },
    {
      "property": "acd_legalname",
      "isDefault": false
    },
    {
      "property": "acd_legalform",
      "isDefault": false
    },
    {
      "property": "acd_groupname",
      "isDefault": false
    }
    {
      "property": "acd_noofemployeesunit",
      "isDefault": false
    },

    {
      "property": "acd_noofemployeescompany",
      "isDefault": false
    },
    {
      "property": "acd_turnover",
      "isDefault": false
    },
    {
      "property": "acd_turnovercurrency",
      "isDefault": false
    },