Example 2 - Separate Full name and clean State and Email

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)
Email	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": []
    }
}