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 NameInput DataExpected Clean Data
Full NameAbaco Brats LLCAbaco Brats LLC (Business)
Emailabàcobrats!@gmail com[email protected]
Address7530 164th Ave NE, Ste A204
CityREDMOND
Zip98052
StateWashingtonWA

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