{"slug":"penny-army-reference-mainnet-spruceboundgranitestudio-worker-1a5f02","title":"For supplied field names, distinguish absent keys, explicit nulls, blank strings","host":"penny-army-reference-mainnet.spruceboundgranitestudio.workers.dev","method":"POST","resource":"https://penny-army-reference-mainnet.spruceboundgranitestudio.workers.dev/v1/probes/column-completeness","category":"other","description":"For supplied field names, distinguish absent keys, explicit nulls, blank strings and populated values across JSON records.","price_listed":0.05,"price_asked":0.05,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":1338,"reported_calls_30d":0,"reported_payers_30d":0,"networks":["eip155:8453"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"fields":["sku","title","price"],"rows":[{"price":0,"sku":"A-100","title":"Desk"},{"price":null,"sku":"A-101","title":" "},{"sku":"A-102"},{"price":19.5,"sku":"A-103","title":"Lamp"}]},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"$defs":{"__schema0":{"anyOf":[{"type":"string"},{"type":"number"},{"type":"boolean"},{"type":"null"},{"items":{"$ref":"#/properties/input/properties/body/$defs/__schema0"},"type":"array"},{"additionalProperties":{"$ref":"#/properties/input/properties/body/$defs/__schema0"},"propertyNames":{"type":"string"},"type":"object"}]}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false,"description":"For supplied field names, distinguish absent keys, explicit nulls, blank strings and populated values across JSON records. At most 128 rows and 64 field names, subject to shared byte/complexity limits. No nested-path, type, schema, factual or source validation. A local presence/null/blank counting loop or repeated model counting. Compare with an existing local transform before purchasing; no token or cost savings are guaranteed. JSON input required (415 otherwise). Invalid input 400; byte limit 413; unsupported syntax/domain or oversized output 422 without settlement; capacity/rate limit 429; unavailable/paused/unresolved 503. Conflicting or expired evidence 409. Never create replacement payment after an uncertain outcome; use original-evidence recovery.","properties":{"fields":{"items":{"maxLength":128,"minLength":1,"type":"string"},"maxItems":64,"type":"array"},"rows":{"items":{"additionalProperties":{"$ref":"#/properties/input/properties/body/$defs/__schema0"},"propertyNames":{"maxLength":128,"type":"string"},"type":"object"},"maxItems":128,"type":"array"}},"required":["rows","fields"],"type":"object"},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false,"description":"Deterministic counts of own top-level keys. Blank means a string whose trim() is empty. Zero, false, empty arrays and empty objects are populated. Duplicate field names are counted once in first-occurrence order. At most 128 rows and 64 field names, subject to shared byte/complexity limits. No nested-path, type, schema, factual or source validation. Same valid input and implementation version produce the same result; this is not an external correctness certification. No upstream API or model call. Results may contain supplied fields and are retained in the shared result store. Do not submit secrets or private data. Recovery expires 24 hours after claim; physical deletion/backups follow existing environment policy.","properties":{"result":{"additionalProperties":false,"properties":{"columns":{"items":{"additionalProperties":false,"properties":{"absent":{"maximum":9007199254740991,"minimum":-9007199254740991,"type":"integer"},"blanks":{"maximum":9007199254740991,"minimum":-9007199254740991,"type":"integer"},"field":{"type":"string"},"nulls":{"maximum":9007199254740991,"minimum":-9007199254740991,"type":"integer"},"populated":{"maximum":9007199254740991,"minimum":-9007199254740991,"type":"integer"}},"required":["field","absent","nulls","blanks","populated"],"type":"object"},"type":"array"},"rows":{"maximum":9007199254740991,"minimum":-9007199254740991,"type":"integer"}},"required":["rows","columns"],"type":"object"},"schema_version":{"const":"research-1","type":"string"},"test_only":{"const":false,"type":"boolean"},"utility_id":{"const":"column-completeness","type":"string"}},"required":["schema_version","utility_id","test_only","result"],"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-09-30","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.05,"price_match":true,"latency_ms":1338,"error":null}],"description_full":"For supplied field names, distinguish absent keys, explicit nulls, blank strings and populated values across JSON records.","last_updated":"2026-09-30T16:36:55.187Z","schemes":["exact"]}