{"uid":"cap_mItL5JmyhC017g670r7rt","slug":"structured-data-observations-record-quality-audit-string-bcba2d29","name":"Structured Data Observations — Record Quality Audit + String Normalisation + Daily Sum Series","description":"Structured data observations — Record quality audit + String normalisation + Daily sum series: Record quality audit + String normalisation + Daily sum series for supplied structured data observations records (valid_items, total_items). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-web-08-198?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","site_group","date","valid_items","total_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"site_group":{"type":"string","default":"","maxLength":80},"total_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"valid_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","site_group":"group-a","total_items":1,"valid_items":10},{"date":"2026-10-02","row_id":"row-2","site_group":"group-b","total_items":2,"valid_items":20},{"date":"2026-10-03","row_id":"row-3","site_group":"group-a","total_items":3,"valid_items":15},{"date":"2026-10-04","row_id":"row-4","site_group":"group-b","total_items":4,"valid_items":30}],"maxItems":200,"minItems":1},"field":{"enum":["valid_items","total_items"],"type":"string","default":"valid_items"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_bHjbTdmHQrO1AvmSn148N","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Runs three local analytical reports on structured observations data: record quality audit, string normalisation, and daily sum series — up to 200 rows, for valid_items or total_items.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and daily sum series on my observations data — here are 4 rows with row IDs, site groups, dates, valid_items and total_items — and report on the valid_items field?","exampleUseCases":[{"title":"Data quality audit before pipeline load","prompt":"I have a batch of 50 structured observation rows with row_id, site_group, date, valid_items, and total_items — can you run a full record quality audit on them and also normalise the string fields and generate a daily sum series for valid_items?"},{"title":"Daily item count rollup by date","prompt":"Take these 30 observation records across multiple site groups and dates and compute the daily sum series for total_items, plus flag any quality issues in the records."},{"title":"Spotting anomalies before reporting","prompt":"Before I send this dataset to my manager, can you audit these 120 observation rows for record quality problems, normalise any inconsistent strings, and give me a daily sum breakdown for valid_items?"}],"resultDescription":"Three independent analytical reports based on the supplied rows: (1) a record quality audit flagging issues like missing values or malformed rows, (2) a string normalisation report on text fields like site_group, and (3) a daily sum series aggregating the selected numeric field (valid_items or total_items) by date. No external data is fetched; all analysis is local.","failureModes":["Input array is empty (minItems:1 violation)","More than 200 rows submitted (maxItems:200 violation)","date field does not match YYYY-MM-DD pattern","row_id is empty or exceeds 80 characters","field enum value is not 'valid_items' or 'total_items'","Numeric values outside allowed range (-1e12 to 1e12)"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of structured observation data with date, site_group, valid_items, and total_items fields and need three bundled local reports — quality audit, string normalisation, and daily sums — in a single low-cost call ($0.01 USDC). Prefer it over single-report endpoints when you need all three analyses together without external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:31:52.330Z","isFirstParty":false,"canonicalSlug":"structured-data-observations-record-quality-audit-string-bcba2d29"}