API for Cleanser
Use this generic API call in order to cleanse data without any webMethods OneData configurations required.
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. For example, IN_Address from the row 1 1000 IN_Address.
URL
http://host:port/custom_webMethods_OneData_application_name/rest/
webMethods_OneData_repository_ID/webMethods_OneData_Project/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"
} ]
}
}
You can describe the API specification using Swagger as shown below:
Swagger URL:
http://host:port/custom_webMethods_OneData_application_name/rest/
webMethods_OneData_repository_ID/webMethods_OneData_Project/DQ/cleanser/swagger
Example: http://localhost:8080/WMOnedata/rest/OD98HAPA/Standard%20Project/DQ/cleanser/swagger.