In this example we will user the DataPrep API to separate Full name into individual or business, clean and standardize State name and clean Email from the following record:
Field Name | Input Data | Expected Clean Data |
---|---|---|
Full Name | Abaco Brats LLC | Abaco Brats LLC (Business) |
abàcobrats!@gmail com | [email protected] | |
Address | 7530 164th Ave NE, Ste A204 | |
City | REDMOND | |
Zip | 98052 | |
State | Washington | WA |
Short-form (GET)
http://api.versium.com/v2/dataprep?actions[]=namecatparse:Fullname:Category,Prefix,First,Middle,Last,Suffix,Busname&actions[]=state:State:State&Fullname=ABACO BRATS LLC&Email=abà[email protected]&City=REDMOND&Address=7530 164th AVE NE. Ste A204&State=Washington&Zip=98052
Long-form (POST)
URL
http://api-stg.versium.com/v2/dataprep
Body
{
"actions": [
{
"name": "namecatparse",
"inputFields": [
"Fullname"
],
"outputFields": [
"Category",
"Prefix",
"First",
"Middle",
"Last",
"Suffix",
"Busname"
]
},
{
"name": "state",
"inputFields": [
"State"
],
"outputFields": [
"State"
]
}
],
"inputs": [
{
"Fullname": "ABACO BRATS LLC",
"Address": "7530 164th Ave NE, Ste A204",
"City": "REDMOND",
"State": "Washington",
"Zip": "98052",
"Email": "abà[email protected]"
}
]
}
Response
{
"versium": {
"version": "2.0",
"match_counts": {
"data_prep": 1
},
"num_matches": 1,
"num_results": 1,
"query_id": "1f174beeca697f1088e999b8d0bad834",
"query_time": 0.03231000900268555,
"results": [
{
"Address": "7530 164th Ave NE, Ste A204",
"City": "REDMOND",
"Email": "[email protected]",
"Fullname": "ABACO BRATS LLC",
"State": "WA",
"Zip": "32073",
"Category": "BUSINESS",
"Prefix": "",
"First": "",
"Middle": "",
"Last": "",
"Suffix": "",
"Busname": "ABACO BRATS LLC"
}
],
"input_query": []
}
}