Hi Steven,
Hope the below information is helpful. I see the following challenges with your configuration.
- I see you have used <organization>, I believe it's just a placeholder and should be replaced with EntityType "Organization"
- 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
------------------------------
Original Message:
Sent: 09-01-2023 10:26
From: Steven Gibson
Subject: String Cleanser syntax. Documentation is a little vague
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
------------------------------