Example 1 - Clean First/Country/Email

In this example we will user the DataPrep API to clean First Name, Country code and Email from the following record:

Field Name	Input Data	Expected Clean Data
Name	Bu/!bba	Bubba
Email	bubbagump!@gmailcom	removed as not a valid email
Business Name	bubba gumps
Title	CEO
Address	7530 164th Ave NE, Ste A204
City	Redmond
Zip	98052
Country	USA	US
Date (System generated):	11 12 2018

Short-form (GET)

http://api.versium.com/v2/dataprep?actions[]=email:Email:Email&actions[]=first:Name:Name&actions[]=country:Country:Country&Name=Bu/!bba&Email=bubbagump!@gmailcom.&Business=bubba gumps&Address=7530 164th Ave NE, Ste A204&City=Redmond&Title=CEO&Zip=98052&Country=USA&Date (System generated)=11 12 2018

Long-form (POST)

URL

http://api-stg.versium.com/v2/dataprep

Body

{
  "actions": [
    {
      "name": "first",
      "inputFields": [
        "Name"
      ],
      "outputFields": [
          "Name"
      ]
    },
    {
        "name": "email",
        "inputFields": [
            "Email"
        ],
        "outputFields": [
            "Email"
        ]
    },
    {
        "name": "country",
        "inputFields": [
            "Country"
        ],
        "outputFields": [
            "Country"
        ]
    }
  ],
  "inputs": [
    {
      "Name": "Bu/!bba",
      "Email": "bubbagump!@gmailcom.",
      "Business": "bubba gumps",
      "Title": "CEO",
      "Address": "7530 164th Ave NE, Ste A204",
      "City": "Redmond",
      "Zip": "98052",
      "Country": "USA",
      "Date (System generated)": "11 12 2018"
    }
  ]
}

Response

{
    "versium": {
        "version": "2.0",
        "match_counts": [],
        "num_matches": 0,
        "num_results": 1,
        "query_id": "3604f7b10729dc5703c550e3ac2d0cc4",
        "query_time": 0.03641009330749512,
        "results": [
            {
                "Address": "7530 164th Ave NE, Ste A204",
                "Business": "bubba gumps",
                "City": "Redmond",
                "Country": "US",
                "Date_(System_generated)": "11 12 2018",
                "Email": "",
                "Name": "Bubba",
                "Title": "CEO",
                "Zip": "98052"
            }
        ],
        "input_query": []
    }
}