Add Row API

Creates a new row in All Time Data.

Endpoint

POST https://commissionconnector.com/api/add-row

Authentication

Include your API key in the header:

x-api-key: YOUR_API_KEY

Headers

Header	Type	Required	Description
`x-api-key`	string	✅	Your API key for authentication
`Content-Type`	string	✅	Must be `application/json`

Request Body

Creates a new record in the All Time Data.

Unless otherwise specified:

Strings are plain text
Dates must be in MM/DD/YYYY format
Numbers accept integers or decimals

Example:

{
  "agent_name": "John Doe",
  "carrier": "Aetna",
  "agent_id": "AGT-123",
  "agent_npn": "18374652",
  "statement_date": "09/01/2025",

  "client_full_name": "Jane Smith",
  "client_first_name": "Jane",
  "client_middle_name_initial": "A",
  "client_last_name": "Smith",

  "carrier_member_id": "MEM-1009",
  "policy_number": "PL-839201",
  "effective_date": "09/01/2025",
  "prior_plan": "No",
  "termination_date": "",
  "termination_reason": "",

  "line": "Health",
  "sub_line": "Med Adv",
  "plan_type": "MAPD",
  "plan": "Silver Advantage",
  "contract": "H1234",
  "pbp": "001",

  "member_state": "TX",
  "member_county": "Travis",

  "premium": 120.5,
  "agent_split": 0.5,
  "comp_rate": 100,
  "lives": 1,
  "commission": 120.5,
  "expected_comm": 120.5,
  "commission_action": "Advance",


  "agent_comp_plan": "Standard MAPD",
  "agent_payroll": "100.00",
  "lock_pay": false,

  "upline_1_name": "ABC Insurance",
  "upline_1_comp_plan": "Override Plan 1",
  "upline_1_payroll": "20.00"
}

Response

201 Created

Example successful response:

{
  "id": "alltime_01JABCDXYZ",
  "created_at": "09/05/2025 16:22:10",
  "data": {
    "agent_name": "John Doe",
    "carrier": "Aetna",
    "statement_date": "09/01/2025",
    "plan": "Silver Advantage",
    "commission": 120.5,
    "commission_action": "whatever",
    "...": "..."
  }
}

Field	Description
`id`	Unique ID for the newly created record
`created_at`	Timestamp when the row was saved
`data`	Echo of all stored fields

400 Bad Request

Returned when:

A date isn’t formatted as MM/DD/YYYY
A number is provided as a string ("120.5" instead of 120.5)
JSON is malformed or contains disallowed fields

Example:

{
  "error": "validation_error",
  "message": "Invalid format for 'effective_date'. Expected MM/DD/YYYY."
}

Fields Not Included

The following fields are automatically calculated or managed by ComTrack and should not be sent in the request body:

Field	Reason
`Reconcile`	Calculated automatically during commission reconciliation
`Classification`	Determined by ComTrack’s classification logic
`Your Spread`	Computed during payroll and override calculations
`Payment Period`	Derived from the `Statement Date` (e.g., “September 2025”)

If you include any of these fields in your request, they’ll be ignored.

Notes & Conventions

String fields: may be empty ("")
Number fields: must be unquoted numeric values
Boolean fields: must be true or false
Date fields: must follow MM/DD/YYYY
Empty date: send "" if no date applies
Extra fields: ignored silently by the API

Examples

cURL

curl -X POST "https://commissionconnector.com/api/add-row" \
  -H "x-api-key: YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "agent_name": "John Doe",
    "carrier": "Aetna",
    "commission": 120.5,
    "statement_date": "09/01/2025"
  }'

Python (requests)

import requests

payload = {
    "agent_name": "John Doe",
    "carrier": "Aetna",
    "commission": 120.5,
    "statement_date": "09/01/2025"
}

headers = {
    "x-api-key": "YOUR_API_KEY",
    "Content-Type": "application/json"
}

r = requests.post("https://commissionconnector.com/api/add-row", json=payload, headers=headers)
print(r.status_code, r.json())

Node.js (axios)

import axios from "axios";

const res = await axios.post(
  "https://commissionconnector.com/api/add-row",
  {
    agent_name: "John Doe",
    carrier: "Aetna",
    commission: 120.5,
    statement_date: "09/01/2025"
  },
  {
    headers: {
      "x-api-key": process.env.COMMISSION_CONNECTOR_KEY,
      "Content-Type": "application/json"
    }
  }
);

console.log(res.data);

Change Log

2025-10-14
- Added full field schema
- Enforced MM/DD/YYYY date format
- Clarified that Payment Period is automatically derived (not user-submitted)
- Listed excluded calculated fields