Add Row API | Help Center

Creates a new row in All Time Data.

Authentication

Include your API key in the header:

x-api-key: YOUR_API_KEY

Headers

Header	Type	Required	Description
`x-api-key`	string	Yes	Your API key for authentication
`Content-Type`	string	Yes	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

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