如何将DataFrame转换为Constant Contact API要求的精确格式？

Got it, let's break down how to get your DataFrame into the exact format the Constant Contact API expects. The key issue with using to_json() directly is that it only serializes the DataFrame's own rows/columns—you need to wrap that data in the required top-level structure first, then convert to JSON.

Step 1: Understand the Target Payload Structure #

First, let's clarify what the API expects. Your final 'data' parameter should look like this (note the import_data key and the array-wrapped list_id):

{
  "import_data": [
    {
      "email_address": "john.doe@example.com",
      "first_name": "John",
      "last_name": "Doe"
    },
    {
      "email_address": "jane.smith@example.com",
      "first_name": "Jane",
      "last_name": "Smith"
    }
  ],
  "lists": [
    {
      "list_id": ["123456"]  // Even single IDs must be in square brackets
    }
  ]
}

Step 2: Convert Your DataFrame to a List of Dictionaries #

First, turn your DataFrame rows into a list of Python dictionaries (this preserves the column names as keys, which matches the API's contact fields):

import pandas as pd
import json

# Example DataFrame with your contact data
df = pd.DataFrame({
    "email_address": ["john.doe@example.com", "jane.smith@example.com"],
    "first_name": ["John", "Jane"],
    "last_name": ["Doe", "Smith"]
})

# Convert DataFrame to list of dictionaries (one dict per row)
contact_records = df.to_dict('records')

Step 3: Build the Full API Payload #

Now wrap the contact records in the required structure, including the import_data key and your list(s) with properly formatted list_id:

# Replace "YOUR_LIST_ID_HERE" with your actual Constant Contact list ID
payload = {
    "import_data": contact_records,
    "lists": [
        {
            "list_id": ["YOUR_LIST_ID_HERE"]
        }
    ]
}

# If you need to add multiple lists, just extend the array:
# "list_id": ["LIST_ID_1", "LIST_ID_2"]

Step 4: Serialize to JSON #

Finally, convert the complete payload dictionary to a JSON string—this is what you'll pass to the API's data parameter:

api_data = json.dumps(payload, indent=2)  # Indent is optional, makes output readable

Key Notes #

• Why not use df.to_json() directly? The DataFrame's to_json() method only outputs the data from the frame itself. It can't add the top-level import_data key or the nested lists structure required by the API. Building the full payload as a Python dictionary first gives you full control over the structure.
• Always wrap list_id in square brackets: Even if you're only importing to one list, the API requires list_id to be an array. Failing to do this will cause validation errors.

内容的提问来源于stack exchange，提问作者RustyShackleford