{"uid":"cap_38SQl9nHOCV6UOO2y-w0e","slug":"penny-army-column-completeness-probe-c5424eb8","name":"Penny Army Column Completeness Probe","description":"For supplied field names, distinguish absent keys, explicit nulls, blank strings and populated values across JSON records.","url":"https://penny-army-reference-mainnet.spruceboundgranitestudio.workers.dev/v1/probes/column-completeness?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","propertyNames":{"type":"string","maxLength":128},"additionalProperties":{"$ref":"#/properties/input/properties/body/$defs/__schema0"}},"maxItems":128},"fields":{"type":"array","items":{"type":"string","maxLength":128,"minLength":1},"maxItems":64}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.05","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.05/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_iosWUJ-fekoKMjTu8_efb","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes JSON records to classify each specified field as absent (missing key), explicitly null, blank string, or populated, across a batch of rows.","exampleAgentPrompt":"For these 50 JSON records, tell me which of the fields 'email', 'phone', 'address', and 'date_of_birth' are absent entirely, explicitly null, blank strings, or actually filled in — I need to understand the completeness pattern per field.","exampleUseCases":[{"title":"Pre-ETL data quality audit","prompt":"Before we load these customer records into the warehouse, check the fields 'customer_id', 'email', 'signup_date', and 'referral_code' across all 80 rows — I want to know which ones are missing keys, which are null, which are empty strings, and which have real values."},{"title":"API response completeness check","prompt":"Here are 40 JSON responses from our third-party supplier feed. For the fields 'sku', 'price', 'stock_count', and 'description', break down how many records fall into each category: key absent, null, blank, or populated."},{"title":"Survey response profiling","prompt":"I have these 120 survey response records and I need to know how complete the answers are for 'age', 'region', 'income_bracket', and 'open_feedback' — can you separate out the ones where the key is missing entirely from those that are null or just an empty string?"}],"resultDescription":"A per-field breakdown across all submitted rows indicating how many records fall into each completeness category: absent key (field not present in the object), explicit null (key present but value is null), blank string (key present with empty string value), and populated (key present with a non-null, non-empty value).","failureModes":["rows array exceeds 128 items — request rejected with validation error","fields array exceeds 64 items or contains empty strings — validation failure","malformed JSON body — parse error returned","field name exceeds 128 characters — schema violation","payment not included or insufficient — 402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need to rigorously distinguish between three distinct forms of 'missing' data — absent keys, explicit nulls, and blank strings — in a batch of JSON records. It is particularly valuable before ETL pipelines, data ingestion, or data quality reporting where the semantic difference between a field that was never sent, one that was sent as null, and one that was sent as an empty string matters for downstream logic. Prefer it over generic schema validators that only check types or presence without differentiating nulls from blanks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T06:33:47.139Z","isFirstParty":false,"canonicalSlug":"penny-army-column-completeness-probe-c5424eb8"}