Accelerate the Value of Data

Save Enrichment Mapping

Learn about the operation to save enrichment mappings.

Request

POST: {dnbConnectorUrl}/config/profiles/{profile}/mappings/enrichment
Table 1. Parameters
Parameter Name RequiredDescription
HeadersContent-TypeYesShould be Content-Type:application/json.
HeadersAuthorizationYesReltio access token in the form Bearer: <<token>>, see Authentication API.
PathprofileYesProfile Name.
BodyYes Enrichment mapping JSON

Body

[
  {
    "operation": "shift",
    "spec": {
      "OrderProductResponse": {
        "OrderProductResponseDetail": {
          "Product": {
            "Organization": {
              "#configuration/sources/DnB": "[4].crosswalks[0].type",
              "#Real Time": "[4].attributes.DnBSource[].value",
              "SubjectHeader": {
                "DUNSNumber": [
                  "[4].attributes.DUNSNumber[].value",
                  "[4].crosswalks[0].value"
                ],
                "MarketabilityIndicator": "[4].attributes.MarketabilityIndicator[].value",
                "LastUpdateDate": {
                  "\\$": "[4].attributes.DnBLastUpdateDate[].value"
                },
                "OrganizationSummaryText": "[4].attributes.OrganizationSummaryText[].value",
                "TransferDUNSNumberRegistration": {
                  "*": {
                    "TransferDate": {
                      "\\$": "[4].attributes.PriorDUNSNUmber[&2].value.TransferDate[].value"
                    },
                    "TransferredFromDUNSNumber": "[4].attributes.PriorDUNSNUmber[&1].value.TransferredFromDUNSNumber[].value",
                    "TransferredToDUNSNumber": "[4].attributes.PriorDUNSNUmber[&1].value.TransferredToDUNSNumber[].value",
                    "TransferReasonText": {
                      "*": {
                        "\\@DNBCodeValue": "[4].attributes.PriorDUNSNUmber[&3].value.TransferReasonCode[&1].value",
                        "\\$": "[4].attributes.PriorDUNSNUmber[&3].value.TransferReasonText[&1].value"
                      }
                    }
                  }
                }
              },
              "OrganizationName": {
                "OrganizationPrimaryName": {
                  "*": {
                    "OrganizationName": {
                      "\\$": "[4].attributes.Name[].value"
                    }
                  }
                },
                "TradeStyleName": {
                  "*": {
                    "OrganizationName": {
                      "\\$": "[4].attributes.TradeStyleName[&2].value.OrganizationName[].value"
                    }
                  }
                },
                "FormerOrganizationPrimaryName": {
                  "*": {
                    "OrganizationName": {
                      "\\$": "[4].attributes.TradeStyleName[&2].value.FormerOrganizationPrimaryName[].value"
                    }
                  }
                }
              },
              "Telecommunication": {
                "TelephoneNumber": {
                  "*": {
                    "TelecommunicationNumber":  "[5].sa.Phone[&1].value.Number[].value",
                    "UnreachableIndicator":     "[5].sa.Phone[&1].value.Unreachable[].value",
                    "InternationalDialingCode": "[5].sa.Phone[&1].value.CountryCode[].value",
                    "#Phone":                   "[5].sa.Phone[&1].value.Type[].value",
                    "#true":                    "[5].sa.Phone[&1].value.PrimaryPhoneFlag[].value"
                  }
                },
                "FacsimileNumber": {
                  "*": {
                    "TelecommunicationNumber":  "[5].ma.Phone[&1].value.Number[].value",
                    "UnreachableIndicator":     "[5].ma.Phone[&1].value.Unreachable[].value",
                    "InternationalDialingCode": "[5].ma.Phone[&1].value.CountryCode[].value",
                    "#Fax":                     "[5].ma.Phone[&1].value.Type[].value",
                    "#true":                    "[5].ma.Phone[&1].value.PrimaryPhoneFlag[].value"
                  }
                },
                "WebPageAddress": {
                  "*": {
                    "TelecommunicationAddress": {
                      "@": "[4].attributes.WebsiteURL[].value"
                    }
                  }
                }
              },
              "OrganizationDetail": {
                "StandaloneOrganizationIndicator": "[4].attributes.OrganizationDetail[0].value.Standalone[].value",
                "FamilyTreeMemberRole": {
                  "*": {
                    "FamilyTreeMemberRoleText": {
                      "\\$": "[4].attributes.OrganizationDetail[0].value.MemberRole[&2].value"
                    }
                  }
                },
                "ControlOwnershipDate": {
                  "\\$": "[4].attributes.OrganizationDetail[0].value.OwnershipDate[].value"
                },
                "ControlOwnershipTypeText": {
                  "\\$": "[4].attributes.OrganizationDetail[0].value.OwnershipType[].value"
                },
                "BoneyardOrganizationIndicator": "[4].attributes.OrganizationDetail[0].value.BoneyardOrganization[].value",
                "OperatingStatusText": {
                  "\\$": "[4].attributes.OrganizationDetail[0].value.OperatingStatus[].value"
                },
                "OrganizationStartYear": "[4].attributes.OrganizationDetail[0].value.StartYear[].value",
                "FranchiseOperationTypeText": {
                  "\\$": "[4].attributes.OrganizationDetail[0].value.FranchiseOperationType[].value"
                },
                // not verified yet
                "OperatingStatusComment": {
                  "OperatingStatusFreeFormComment": {
                    "\\$": "[4].attributes.OrganizationDetail[0].value.OperatingStatusComment[].value"
                  }
                }
              },
              "Location": {
                "PrimaryAddress": {
                  "*": {
                    "StreetAddressLine": {
                      "0": {
                        "LineText":                       "[5].sa.Addresses[&3].value.AddressLine1[].value"
                      },
                      "1": {
                        "LineText":                       "[5].sa.Addresses[&3].value.AddressLine2[].value"
                      },
                      "#Shipping":                        "[5].sa.Addresses[&2].value.AddressType[].value",
                      "#true":                            "[5].sa.Addresses[&2].value.Primary[].value",
                      "@(1,PostalCode)":                  "[5].sa.Addresses[&2].value.PostalCode[].value",
                      "@(1,PrimaryTownName)":             "[5].sa.Addresses[&2].value.City[].value",
                      "@(1,TerritoryOfficialName)":       "[5].sa.Addresses[&2].value.StateProvince[].value",
                      "@(1,LatitudeMeasurement)":         "[5].sa.Addresses[&2].value.DnBLatitude[].value",
                      "@(1,LongitudeMeasurement)":        "[5].sa.Addresses[&2].value.DnBLongitude[].value",
                      "@(1,RegisteredAddressIndicator)":  "[5].sa.Addresses[&2].value.Registered[].value",
                      "@(1,ResidentialAddressIndicator)": "[5].sa.Addresses[&2].value.Residential[].value",
                      "@(1,CountryISOAlpha2Code)":        "[5].sa.Addresses[&2].value.Country[].value"
                    },
                    "PremisesDetail": {
                      "*": {
                        "PremisesAreaMeasurement": "[4].attributes.FacilitySizeInSqFeet[].value"
                      }
                    }
                  }
                },
                "MailingAddress": {
                  "*": {
                    "StreetAddressLine": {
                      "0": {
                        "LineText":                       "[5].ma.Addresses[&3].value.AddressLine1[].value"
                      },
                      "1": {
                        "LineText":                       "[5].ma.Addresses[&3].value.AddressLine2[].value"
                      },
                      "#Mailing":                         "[5].ma.Addresses[&2].value.AddressType[].value",
                      "@(1,PostalCode)":                  "[5].ma.Addresses[&2].value.PostalCode[].value",
                      "@(1,PrimaryTownName)":             "[5].ma.Addresses[&2].value.City[].value",
                      "@(1,TerritoryOfficialName)":       "[5].ma.Addresses[&2].value.StateProvince[].value",
                      "@(1,LatitudeMeasurement)":         "[5].ma.Addresses[&2].value.DnBLatitude[].value",
                      "@(1,LongitudeMeasurement)":        "[5].ma.Addresses[&2].value.DnBLongitude[].value",
                      "@(1,RegisteredAddressIndicator)":  "[5].ma.Addresses[&2].value.Registered[].value",
                      "@(1,ResidentialAddressIndicator)": "[5].ma.Addresses[&2].value.Residential[].value",
                      "@(1,CountryISOAlpha2Code)":        "[5].ma.Addresses[&2].value.Country[].value"
                    },
                    "PremisesDetail": {
                      "*": {
                        "PremisesAreaMeasurement": "[4].attributes.FacilitySizeInSqFeet[].value"
                      }
                    }
                  }
                }
              },
              "Financial": {
                "KeyFinancialFiguresOverview": {
                  "*": {
                    "StatementHeaderDetails": {
                      "FinancialStatementToDate": {
                        "\\$": "[4].attributes.KeyFinancialFiguresOverview[&3].value.FinancialStatementToDate[].value"
                      },
                      "FinancialPeriodDuration": "[4].attributes.KeyFinancialFiguresOverview[&2].value.FinancialPeriodDuration[].value"
                    },
                    "SalesRevenueAmount": {
                      "*": {
                        "\\@CurrencyISOAlpha3Code": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueCurrencyCode[&1].value",
                        "\\@ReliabilityText": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueReliabilityCode[&1].value",
                        "\\@UnitOfSize": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueUnitOfSize[&1].value",
                        "\\$": "[4].attributes.KeyFinancialFiguresOverview[&3].value.SalesRevenueAmount[&1].value"
                      }
                    },
                    "ProfitOrLossAmount": {
                      "*": {
                        "\\$": "[4].attributes.KeyFinancialFiguresOverview[&3].value.ProfitOrLossAmount[].value"
                      }
                    },
                    "ProfitOrLossGrowthRate": "[4].attributes.KeyFinancialFiguresOverview[&1].value.ProfitOrLossGrowthRate[].value",
                    "SalesTurnoverGrowthRate": "[4].attributes.KeyFinancialFiguresOverview[&1].value.SalesTurnoverGrowthRate[].value"
                  }
                }
              },
              "IndustryCode": {
                "IndustryCode": {
                  "*": {
                    "IndustryCode": {
                      "\\$": "[4].attributes.IndustryCode[&2].value.IndustryCode[].value"
                    },
                    "\\@DNBCodeValue": "[4].attributes.IndustryCode[&1].value.DNBCode[].value",
                    "\\@TypeText": "[4].attributes.IndustryCode[&1].value.Type[].value",
                    "IndustryCodeDescription": {
                      "*": {
                        "\\$": "[4].attributes.IndustryCode[&3].value.IndustryCodeDescription[].value",
                        "\\@LanguageCode": "[4].attributes.IndustryCode[&3].value.IndustryCodeLanguageCode[].value",
                        "\\@WritingScriptISOAlpha4Code": "[4].attributes.IndustryCode[&3].value.IndustryCodeWritingScript[].value"
                      }
                    },
                    "DisplaySequence": "[4].attributes.IndustryCode[&1].value.DisplaySequence[].value",
                    "SalesPercentage": "[4].attributes.IndustryCode[&1].value.SalesPercentage[].value"
                  }
                }
              },
              "ActivitiesAndOperations": {
                "OperationsText": "[4].attributes.ActivitiesAndOperations[0].value.OperationsText[].value",
                "LineOfBusinessDetails": {
                  "*": {
                    "LineOfBusinessDescription": {
                      "\\$": "[4].attributes.ActivitiesAndOperations[0].value.LineOfBusinessDescription[].value",
                      "\\@LanguageCode": "[4].attributes.ActivitiesAndOperations[0].value.LanguageCode[].value"
                    }
                  }
                },
                "ImportDetails": {
                  "ImportIndicator": "[4].attributes.ActivitiesAndOperations[0].value.ImportIndicator[].value"
                },
                "ExportDetails": {
                  "ExportIndicator": "[4].attributes.ActivitiesAndOperations[0].value.ExportIndicator[].value"
                },
                "SubjectIsAgentDetails": {
                  "AgentIndicator": "[4].attributes.ActivitiesAndOperations[0].value.AgentIndicator[].value"
                }
              },
              "EmployeeFigures": {
                "IndividualEntityEmployeeDetails": {
                  // TODI - remove it
                  "IndividualEmployeeFiguresDate": "[4].attributes.EmployeeDetails[0].value.IndividualEmployeeFiguresDate[].value",
                  "TotalEmployeeQuantity": "[4].attributes.EmployeeDetails[0].value.IndividualTotalEmployeeQuantity[].value",
                  "ReliabilityText": {
                    "\\$": "[4].attributes.EmployeeDetails[0].value.IndividualReliabilityText[].value"
                  }
                },
                // not tested yet
                "IndividualEntityEmployeeDetailsHistory": {
                  "TotalEmployeeQuantity": "[4].attributes.EmployeeDetails[0].value.TotalEmployeeQuantity[].value",
                  "ReliabilityText": {
                    "\\$": "[4].attributes.EmployeeDetails[0].value.TotalEmployeeReliability[].value"
                  }
                }
              },
              "RegisteredDetail": {
                "LegalFormDetails": {
                  "LegalFormText": {
                    "\\$": "[4].attributes.LegalStatusCode[].value"
                  }
                },
                "OrganizationIdentificationNumberDetail": {
                  "*": {
                    "\\@TypeText": "[4].attributes.Identifiers[&1].value.Type[].value",
                    "OrganizationIdentificationNumber": "[4].attributes.Identifiers[&1].value.ID[].value"
                  }
                }
              },
              "Linkage": {
                "GlobalUltimateOrganization": {
                  "#configuration/entityTypes/Organization": "[0].type",
                  "#configuration/sources/DnB": "[0].crosswalks[0].type",
                  "#DnB Linkage": "[0].attributes.VendorOrganizationType[].value",
                  "#Real Time": "[0].attributes.DnBSource[].value",
                  "DUNSNumber": [
                    "[0].attributes.DUNSNumber[].value",
                    "[4].attributes.DUNSHierarchy[0].value.GlobalUltimateDUNS[].value",
                    "[0].crosswalks[0].value"
                  ],
                  "OrganizationPrimaryName": {
                    "*": {
                      "OrganizationName": {
                        "\\$": [
                          "[0].attributes.Name[&2].value",
                          "[4].attributes.DUNSHierarchy[0].value.GlobalUltimateOrganization[&2].value"
                        ]
                      }
                    }
                  },
                  "PrimaryAddress": {
                    "*": {
                      "StreetAddressLine": {
                        "0": {
                          "LineText":                 "[0].attributes.Addresses[&3].value.AddressLine1[].value"
                        },
                        "1": {
                          "LineText":                 "[0].attributes.Addresses[&3].value.AddressLine2[].value"
                        },
                        "#Shipping":                  "[0].attributes.Addresses[&2].value.AddressType[].value",
                        "#true":                      "[0].attributes.Addresses[&2].value.Primary[].value",
                        "@(1,PostalCode)":            "[0].attributes.Addresses[&2].value.PostalCode[].value",
                        "@(1,PrimaryTownName)":       "[0].attributes.Addresses[&2].value.City[].value",
                        "@(1,TerritoryOfficialName)": "[0].attributes.Addresses[&2].value.StateProvince[].value",
                        "@(1,CountryISOAlpha2Code)":  "[0].attributes.Addresses[&2].value.Country[].value"
                      }
                    }
                  }
                },
                "DomesticUltimateOrganization": {
                  "#configuration/entityTypes/Organization": "[1].type",
                  "#configuration/sources/DnB": "[1].crosswalks[0].type",
                  "#DnB Linkage": "[1].attributes.VendorOrganizationType[].value",
                  "#Real Time": "[1].attributes.DnBSource[].value",
                  "DUNSNumber": [
                    "[1].attributes.DUNSNumber[].value",
                    "[4].attributes.DUNSHierarchy[0].value.DomesticUltimateDUNS[].value",
                    "[1].crosswalks[0].value"
                  ],
                  "OrganizationPrimaryName": {
                    "*": {
                      "OrganizationName": {
                        "\\$": [
                          "[1].attributes.Name[&2].value",
                          "[4].attributes.DUNSHierarchy[0].value.DomesticUltimateOrganization[&2].value"
                        ]
                      }
                    }
                  },
                  "PrimaryAddress": {
                    "*": {
                      "StreetAddressLine": {
                        "0": {
                          "LineText":                 "[1].attributes.Addresses[&3].value.AddressLine1[].value"
                        },
                        "1": {
                          "LineText":                 "[1].attributes.Addresses[&3].value.AddressLine2[].value"
                        },
                        "#Shipping":                  "[1].attributes.Addresses[&2].value.AddressType[].value",
                        "#true":                      "[1].attributes.Addresses[&2].value.Primary[].value",
                        "@(1,PostalCode)":            "[1].attributes.Addresses[&2].value.PostalCode[].value",
                        "@(1,PrimaryTownName)":       "[1].attributes.Addresses[&2].value.City[].value",
                        "@(1,TerritoryOfficialName)": "[1].attributes.Addresses[&2].value.StateProvince[].value",
                        "@(1,CountryISOAlpha2Code)":  "[1].attributes.Addresses[&2].value.Country[].value"
                      }
                    }
                  }
                },
                "HeadquartersOrganization": {
                  "#configuration/entityTypes/Organization": "[2].type",
                  "#configuration/sources/DnB": "[2].crosswalks[0].type",
                  "#DnB Linkage": "[2].attributes.VendorOrganizationType[].value",
                  "#Real Time": "[2].attributes.DnBSource[].value",
                  "DUNSNumber": [
                    "[2].attributes.DUNSNumber[].value",
                    "[4].attributes.DUNSHierarchy[0].value.HeadquartersDUNS[].value",
                    "[2].crosswalks[0].value"
                  ],
                  "OrganizationPrimaryName": {
                    "*": {
                      "OrganizationName": {
                        "\\$": [
                          "[2].attributes.Name[&2].value",
                          "[4].attributes.DUNSHierarchy[0].value.HeadquartersOrganization[&2].value"
                        ]
                      }
                    }
                  },
                  "PrimaryAddress": {
                    "*": {
                      "StreetAddressLine": {
                        "0": {
                          "LineText":                 "[2].attributes.Addresses[&3].value.AddressLine1[].value"
                        },
                        "1": {
                          "LineText":                 "[2].attributes.Addresses[&3].value.AddressLine2[].value"
                        },
                        "#Shipping":                  "[2].attributes.Addresses[&2].value.AddressType[].value",
                        "#true":                      "[2].attributes.Addresses[&2].value.Primary[].value",
                        "@(1,PostalCode)":            "[2].attributes.Addresses[&2].value.PostalCode[].value",
                        "@(1,PrimaryTownName)":       "[2].attributes.Addresses[&2].value.City[].value",
                        "@(1,TerritoryOfficialName)": "[2].attributes.Addresses[&2].value.StateProvince[].value",
                        "@(1,CountryISOAlpha2Code)":  "[2].attributes.Addresses[&2].value.Country[].value"
                      }
                    }
                  }
                },
                "ParentOrganization": {
                  "#configuration/entityTypes/Organization": "[3].type",
                  "#configuration/sources/DnB": "[3].crosswalks[0].type",
                  "#DnB Linkage": "[3].attributes.VendorOrganizationType[].value",
                  "#Real Time": "[3].attributes.DnBSource[].value",
                  "DUNSNumber": [
                    "[3].attributes.DUNSNumber[].value",
                    "[4].attributes.DUNSHierarchy[0].value.ParentDUNS[].value",
                    "[3].crosswalks[0].value"
                  ],
                  "OrganizationPrimaryName": {
                    "*": {
                      "OrganizationName": {
                        "\\$": [
                          "[3].attributes.Name[&2].value",
                          "[4].attributes.DUNSHierarchy[0].value.ParentOrganization[&2].value"
                        ]
                      }
                    }
                  },
                  "PrimaryAddress": {
                    "*": {
                      "StreetAddressLine": {
                        "0": {
                          "LineText":                 "[3].attributes.Addresses[&3].value.AddressLine1[].value"
                        },
                        "1": {
                          "LineText":                 "[3].attributes.Addresses[&3].value.AddressLine2[].value"
                        },
                        "#Shipping":                  "[3].attributes.Addresses[&2].value.AddressType[].value",
                        "#true":                      "[3].attributes.Addresses[&2].value.Primary[].value",
                        "@(1,PostalCode)":            "[3].attributes.Addresses[&2].value.PostalCode[].value",
                        "@(1,PrimaryTownName)":       "[3].attributes.Addresses[&2].value.City[].value",
                        "@(1,TerritoryOfficialName)": "[3].attributes.Addresses[&2].value.StateProvince[].value",
                        "@(1,CountryISOAlpha2Code)":  "[3].attributes.Addresses[&2].value.Country[].value"
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "0": {
        "type": "[0].type",
        "crosswalks": "[0].crosswalks",
        "attributes": "[0].attributes"
      },
      "1": {
        "type": "[1].type",
        "crosswalks": "[1].crosswalks",
        "attributes": "[1].attributes"
      },
      "2": {
        "type": "[2].type",
        "crosswalks": "[2].crosswalks",
        "attributes": "[2].attributes"
      },
      "3": {
        "type": "[3].type",
        "crosswalks": "[3].crosswalks",
        "attributes": "[3].attributes"
      },
      "4": {
        "type": "[4].type",
        "crosswalks": "[4].crosswalks",
        "attributes": "[4].attributes"
      },
      "5": {
        "ma": {
          "Addresses": {
            "*": "[4].attributes.Addresses[]"
          },
          "Phone": {
            "*": "[4].attributes.Phone[]"
          }
        },
        "sa": {
          "Addresses": {
            "*": "[4].attributes.Addresses[]"
          },
          "Phone": {
            "*": "[4].attributes.Phone[]"
          }
        }
      }
    }
  },
  {
    "operation": "com.reltio.account360.connector.dnb.mappings.SetFinancialStatementToDate"
  },
  // section below doesn't make useful actions - only replaces null to { "attributes": {}} - empty organization
  // why? - we need it in case when only one organization here and other are null - in this case last modifier will
  // create array[] instead of array[array[]] and crash conversion to List<List<>>
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "*": {
        "attributes": {
          "SomeValue": {
            "*": {
              "value": "&"
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": "[0]"
    }
  }
]

Response

HTTP CODE:
Success: 200

Errors:  
400 Bad Request
404 Not Found
500 Internal Server Error