help with json format for batch create prospects with pypardot in Python

Question

I'm interested in creating multiple new prospects from a CSV file with the batch_create method for Prospects objects in the pypardot package in Python. The method calls for the prospect information (email, name, ...) in JSON format. After reading in the csv file I'm using json.dumps() to create the JSON format but I keep on getting an

error#71: invalid JSON (http://developer.pardot.com/kb/error-codes-messages/#error-code-71).

Here is what my info looks like after json.dumps()

{"prospects": [{"first_name": "fname1", "last_name": "lname1", "email": "[email protected]"},
{"first_name": "fname2", "last_name": "lname2", "email": "[email protected]"}]}

The data type is a string.

Answer 1

Based on the Json samples in the documentation (api V3) and the error code, your json is incorrectly formated.

{
    "prospects": {
        "1234": {
            "first_name": "New first name",
            "last_name": "New last name"
        },
        "[email protected]": {
            "first_name": "New first name",
            "last_name": "New last name"
        },
        "[email protected]": {
            "first_name": "New first name",
            "last_name": "New last name"
        }
    }
}

if you are using the API V 4, then you need to add the square brackets as you did:

{
    "prospects": [
        {"email":"[email protected]","first_name":"First name","last_name":"Last name"},
        {"email":"[email protected]","first_name":"First name","last_name":"Last name"},
        {"email":"[email protected]","first_name":"First name","last_name":"Last name"}
    ]
}