API for Cleanser
Use this generic API call in order to cleanse data without any OneData configurations required. This API is only applicable to the OneData Matcher. Before you use this API, you must define the rules on which matching should be done, and include the inputDataset and matchCandidate attributes.
cleansing the data without any OneData configurations. This API is applicable only to webmethods Locate. You must pass the data in the “inputdataset” attribute and the attribute names you want to receive in the API response must be specified in the child attribute outputAttributes of the parent attributeNames. The column name must be the name of the default attributes specified in the OD_MD_DQSRV_MPNG metadata table. Additionally, you can also specify custom names to the columns if you provide the correct mapping in the child attributes inputAttributes and outputAttribues under the parent attributes columnName (custom names), attributeName (default attributes).
You can also include functions for rules, projects, and objects in this generic API call. These are described in the sections that follow.
URL
http://host:port/custom_OneData_application_name/rest/OneData_repository_ID/schema/DQ/cleanser
Example: http://localhost:8080/WMOnedata/rest/OD98HAPA/Standard%20Project/DQ/cleanser
Mandatory Input Attributes
Required: | outputAttributes, inputDataSet |
Example of API Syntax
{
"dqConfig" : {
"additionalConfig" : {
}
},
"outputAttributes" : [ {
"attributeName" : "OUT_Organization"
}, {
"attributeName" : "OUT_Address"
}, {
"attributeName" : "OUT_PostalCode"
}, {
"attributeName" : "OUT_Locality"
} ],
"inputDataSet" : {
"rows" : [ {
"columns" : [ {
"name" : "IN_Organization",
"value" : "SoftwareAg"
}, {
"name" : "IN_Address",
"value" : "300 Concord Road"
}, {
"name" : "IN_PostalCode",
"value" : "01821"
}, {
"name" : "IN_Country",
"value" : "US"
} ],
"pkIdentifier" : "111"
},
{
"columns" : [ {
"name" : "IN_Organization",
"value" : "SAG"
}, {
"name" : "IN_Address",
"value" : "433 Hakensack Avenue"
}, {
"name" : "IN_PostalCode",
"value" : "07601"
}, {
"name" : "IN_Country",
"value" : "US"
} ],
"pkIdentifier" : "222"
},
{
"columns" : [ {
"name" : "IN_Organization",
"value" : "AG"
}, {
"name" : "IN_Address",
"value" : "1246 Everett Avenue"
}, {
"name" : "IN_PostalCode",
"value" : "40204"
}, {
"name" : "IN_Country",
"value" : "US"
} ],
"pkIdentifier" : "333"
} ]
}
}