# Treasury Supplied Balances — Exact Row Deduplication + Explicit Missing-Value Fill

> Treasury Supplied Balances — Exact Row Deduplication + Explicit Missing-Value Fill is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-30).

Deduplicates exact duplicate rows and fills missing opening/closing balance values in treasury supplied balance records using zero, mean, or median imputation.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-finance-16-054?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-30
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/treasury-supplied-balances-exact-row-deduplication-explicit-missing-95379a00
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_6YYYIlccXOUHbiE4oooyc

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability treasury-supplied-balances-exact-row-deduplication-explicit-missing-95379a00 -d '<json body>'
```

Example prompt: I have a dataset of treasury supplied balance records with some duplicate rows and null closing_balance values — can you deduplicate the exact duplicates and fill the missing closing_balance values using median imputation? Here are up to 200 rows with row_id, instrument_group, date, opening_balance, and closing_balance fields.

## When to prefer this

Choose this endpoint when you have treasury supplied balance data (opening and closing balances by instrument group and date) that needs both exact row deduplication and explicit missing-value imputation in a single call. It is ideal for pre-reporting data cleaning workflows where you need two coordinated reports — a deduplicated view and a filled view — from the same batch of up to 200 rows, without any external lookup or live data dependency. Prefer this over general-purpose data cleaning tools when your data specifically follows the treasury balance schema (row_id, instrument_group, date, opening_balance, closing_balance).

## Known failure modes

- Input array exceeds 200 rows — request will be rejected
- Missing required fields (row_id, instrument_group, date, opening_balance, closing_balance) on any row causes validation error
- Invalid date format (not YYYY-MM-DD) causes schema rejection
- Numeric values outside ±1,000,000,000,000 are rejected
- Invalid method enum value (not zero/mean/median) causes error
- Invalid field enum value (not opening_balance/closing_balance) causes error
- Empty input array (minItems: 1) is rejected

## How this service works

Treasury supplied balances — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied treasury supplied balances records (opening_balance, closing_balance). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.

## Output

Returns two independent analytical reports: (1) a deduplicated version of the input rows with exact duplicate records removed, and (2) the dataset with missing values in the specified balance field (opening_balance or closing_balance) explicitly filled using the chosen method (zero, mean, or median). Both reports operate on the same input batch of up to 200 rows using local analytical engines with no external data lookup.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "instrument_group",
     "date",
     "opening_balance",
     "closing_balance"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "closing_balance": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "opening_balance": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "instrument_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "closing_balance": 1,
     "opening_balance": 10,
     "instrument_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "closing_balance": 2,
     "opening_balance": 20,
     "instrument_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "closing_balance": 3,
     "opening_balance": 15,
     "instrument_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "closing_balance": 4,
     "opening_balance": 30,
     "instrument_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "opening_balance",
    "closing_balance"
   ],
   "type": "string",
   "default": "opening_balance"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/treasury-supplied-balances-exact-row-deduplication-explicit-missing-95379a00/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)