{"uid":"cap_ci77TiMhZLPnZNGI9_apm","slug":"structured-data-observations-record-quality-audit-string-51064fe8","name":"Structured Data Observations — Record Quality Audit + String Normalisation + Adjacent Row Changes","description":"Structured data observations — Record quality audit + String normalisation + Adjacent row changes: Record quality audit + String normalisation + Adjacent row changes 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-200?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_Mwkiu4lWz2lQ5Rfj20CTy","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 analytical reports (record quality audit, string normalisation, and adjacent row changes) on up to 200 rows of structured observations data containing valid_items and total_items fields.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and adjacent row changes analysis on my structured observations data? I have 12 rows with fields row_id, site_group, date, valid_items, and total_items — focus the field analysis on valid_items.","exampleUseCases":[{"title":"Observations dataset quality check","prompt":"I've got about 50 rows of daily observations from our monitoring system with site_group, date, valid_items, and total_items columns. Can you run a record quality audit, string normalisation, and adjacent row changes report on them so I can spot any dirty records or inconsistencies?"},{"title":"Detecting day-over-day shifts in metrics","prompt":"We track valid_items and total_items across multiple site groups each day — can you analyse these 80 observation rows and give me the adjacent row changes report focused on valid_items so I can see where big day-to-day jumps are happening?"},{"title":"Cleaning site group labels in observations","prompt":"Our data team suspects site_group names in our observations table are inconsistently formatted. Can you run string normalisation plus a quality audit across these 30 rows to surface any casing or whitespace issues?"}],"resultDescription":"Returns three independent reports for the supplied rows: (1) a record quality audit flagging nulls, missing fields, and anomalies; (2) a string normalisation report identifying inconsistencies in text fields like site_group; and (3) an adjacent row changes report showing value differences between consecutive rows for the selected field (valid_items or total_items). All analysis is performed locally on the supplied data — no external lookups or predictions.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit","Missing required fields (row_id, site_group, date, valid_items, total_items) in one or more row objects","Date field does not match YYYY-MM-DD pattern — validation error","Field selector not one of the allowed enum values (valid_items, total_items)","Payment not included or insufficient — x402 payment required at $0.01 USDC"],"whenToPreferThis":"Choose this endpoint when you need three complementary data-quality reports (quality audit, string normalisation, and adjacent row changes) on structured observation records in a single call. It is ideal for datasets up to 200 rows where all analysis should be performed locally on supplied data without any external lookups, predictions, or live data access. It is especially useful when your records include both numeric metrics (valid_items, total_items) and categorical text fields (site_group) that may need cleaning.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:19.284Z","isFirstParty":false,"canonicalSlug":"structured-data-observations-record-quality-audit-string-51064fe8"}