Reltio Connect

 View Only
  • 1.  String Cleanser syntax. Documentation is a little vague

    Posted 26 days ago

    Reading through the documentation. I don't see much that can help me resolve why this is not working.
    https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/string-cleanser

                      {
                          "uri": "configuration/entityTypes/<organization>/cleanse/infos/PortalIdCleanser",
                          "useInCleansing": true,
                          "sequence": [
                              {
                                  "chain": [
                                      {
                                          "cleanseFunction": "StringFunctionCleanser",
                                          "resultingValuesSourceTypeUri": "configuration/sources/ReltioCleanser",
                                          "proceedOnSuccess": true,
                                          "proceedOnFailure": false,
                                          "mapping": {
                                              "inputMapping": [
                                                  {
                                                      "attribute": "configuration/entityTypes/<organization>/attributes/PortalIds/attributes/Type",
                                                      "mandatory": true,
                                                      "allValues": false,
                                                      "cleanseAttribute": "Type"
                                                  }
                                              ],
                                              "outputMapping": [
                                                {
                                                  "attribute": "configuration/entityTypes/<organization>/attributes/PortalIds/attributes/Type",
                                                  "mandatory": true,
                                                  "allValues": false,
                                                  "cleanseAttribute": "OutputText"
                                                }
                                              ]
                                          },
                                          "params": {
                                              "casing": "Title"
                                          }
                                      }
                                  ]
                              }
                          ]
                      },

    The value in question is a nested attribute. 
    PortalIds
    -Type
    -Id

    Trying to do the cleanse on the type. Trying to enforce Title casing but it is doing nothing. Any assistance would be appreciated.


    ------------------------------
    Steven Gibson
    AvidXChange
    NY
    ------------------------------


  • 2.  RE: String Cleanser syntax. Documentation is a little vague

    Reltio Employee
    Posted 2 days ago

    Hi Steven,

    Hope the below information is helpful. I see the following challenges with your configuration. 

    1. I see you have used <organization>, I believe it's just a placeholder and should be replaced with EntityType "Organization"
    2. In the outputMapping the cleanseAttribute : "OutputText" please replace with the same attribute as the input attribute "Type"

    I have tested the below config locally and it's working fine. Please try to use this and customize it based on your need. 

    {
    "uri": "configuration/entityTypes/Organization/cleanse/infos/PortalIdCleanser",
    "useInCleansing": true,
    "sequence": [
    {
    "chain": [
    {
    "cleanseFunction": "StringFunctionCleanser",
    "resultingValuesSourceTypeUri": "configuration/sources/ReltioCleanser",
    "proceedOnSuccess": true,
    "proceedOnFailure": false,
    "mapping": {
    "inputMapping": [
    {
    "attribute": "configuration/entityTypes/Organization/attributes/PortalIds/attributes/Type",
    "mandatory": true,
    "allValues": false,
    "cleanseAttribute": "Type"
    }
    ],
    "outputMapping": [
    {
    "attribute": "configuration/entityTypes/Organization/attributes/PortalIds/attributes/Type",
    "mandatory": true,
    "allValues": false,
    "cleanseAttribute": "Type"
    }
    ]
    },
    "params": {
    "casing": "Title"
    }
    }
    ]
    }
    ]
    }


    ------------------------------
    Girish Kalburgi
    Reltio
    NC
    ------------------------------