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